Create Responsibility and Attched the oracle Custon form to the Responsibility. When the Custom Form is OPEN with This Responsibility, For which Organization Name is Assign to This Responsibility is Default set in the Custom Form.

Create Responsibility and Attched the oracle Custon form to the Responsibility. When the Custom Form is OPEN with This Responsibility, For which Organization Name is Assign to This Responsibility is Default set in the Custom Form.

Index:

SL    Seq No   
1    1    Function        OPL Cylinder Tracking - CRC   
      2    Description    OPL Cylinder Tracking - CRC   
               
2    3    Menu             OPL_GHORASHAL_OM   
      4    Description    OPL Ghorashal OM SuperUser   
               
        Responsibility creation    System Administrator > Security > Users > Responsibility   
3    5    Custom Responsibility    OPL Ghorashal OM SuperUser   
      6    Application                     Order Management   
      7    Responsibility KEY        OPL GHORASHAL OM SUPERUSER   
      8    Description                      OPL Ghorashal OM SuperUser   
               
4    9    Data Group    Name    Standard   
    10                 Application    Order Management   
        System Administrator > Profile > System       
5    11         Profile    MO: Default Operating Unit             OPL_UNIT_OU
      12         MO: Operating Unit    OPL_UNIT_OU        OPL_UNIT_OU
      13         MO: Security Profile    OMERA BUSINESS GROUP    OMERA BUSINESS GROUP
      14         HR: Security Profile    OMERA BUSINESS GROUP    OMERA BUSINESS GROUP
               
6    15    Assingnment of  Custom Responsibility to the USER
        System Administrator > Security > Users > Define    
               
7    16    Organization Access
        Inventory > Setup > Organization > Organization Access   
                 
8    17    Table/Veiw    ORG_ACCESS_V   
 

Nevigation > Application Developer > Application > Function

Click on the Function for the Custom Form Function name

Search the Function name in the Function Window.

Like : OPL Cylinder Tracking – CRC

Step By Sequence No
1	Function	OPL Cylinder Tracking - CRC
2	Description	OPL Cylinder Tracking - CRC

3	Menu	OPL_GHORASHAL_OM
4	Description	OPL Ghorashal OM SuperUser

Then Create the Menu for the Respective Function you created, and Assign the Function Name to the Menu.

Menu                                    : OPL_GHORASHAL_OM

User Menu Name            : OPL_GHORASHAL_OM

Menu Type                         : Standard

Description                         : OPL Ghorashal OM SuperUser

Function Name                                 : OPL Cylinder Tracking – CRC

Then Create the Responsibility  >

System Administrator > Security > Users > Responsibility

	Responsibility creation
5	Custom Responsibility	OPL Ghorashal OM SuperUser
6	Application	Order Management
7	Responsibility KEY	OPL GHORASHAL OM SUPERUSER
8	Description	OPL Ghorashal OM SuperUser

9	Data Group	Name	Standard
10		Application	Order Management

Menu : OPL_GHORASHAL_OM

(This MENU we have already created in the above and we attached this MENU to this Responsibility)

Then go to the Profile Option to set the Organization.

In Responsibility Check Box Type the Responsibility Name and In Profile Type OM% to set the Setup

11	Profile	MO: Default Operating Unit		OPL_UNIT_OU
12		MO: Operating Unit	OPL_UNIT_OU	OPL_UNIT_OU
13		MO: Security Profile	OMERA BUSINESS GROUP	OMERA BUSINESS GROUP
14		HR: Security Profile	OMERA BUSINESS GROUP	OMERA BUSINESS GROUP

Assingnment of  Custom Responsibility to the USER

15

Assingnment of  Custom Responsibility to the USER

System Administrator > Security > Users > Define

16

Organization Access

Inventory > Setup > Organization > Organization Access

Org                                         : PO3

Application                         : Order Management

Responsibility Name       : OPL Cylinder Tracking-Ghorashal 

17

Table/Veiw

ORG_ACCESS_V

In the Custom Form Write the Code for fetch the RESPO_ID

Write The code in FORM level Trigger in WHEN-NEW-FORM-INSTANCE

---- Query for Responsibility ID and With This Resp_id fetch the Organization Name in Plant Name Filed --

                 Begin

                                :Parameter.P_RESP_ID:=FND_GLOBAL.RESP_ID;             

                End;

Then Write the query in LOV for LOV_PLANT_NAME

SELECT ORGANIZATION_NAME , ORGANIZATION_CODE, ORGANIZATION_ID

 FROM   ORG_ACCESS_V OAE

 WHERE OAE.RESPONSIBILITY_ID = NVL(:PARAMETER.P_RESP_ID, OAE.RESPONSIBILITY_ID )

Then Go to this Responsibility to OPEN the Respective From.

 

In this Respective Custom form,  We get the Organization Name with that Responsibility Assign