How
to find whether MULTI_ORG is enabled for the application or not?
Columns in the table FND_PRODUCT_GROUPS:
SQL> Select * FROM
FND_PRODUCT_GROUPS
Columns in the table FND_PRODUCT_GROUPS:
RELEASE_NAME
PRODUCT_GROUP_TYPE
MULTI_ORG_FLAG
MULTI_LINGUAL_FLAG
MULTI_CURRENCY_FLAG
From
the backend, How to set Client Info in Backend?
Ø DBMS_APPLICATION_INFO.SET_CLIENT_INFO
('org_id');
Ex: DBMS_APPLICATION_INFO.SET_CLIENT_INFO (103);
Ø FND_CLIENT_INFO.SETUP_CLIENT_INFO
(application_id => <application_id>
,responsibility_id
=><Resp Id>
,user_id =><User id>
,security_group_id =><Security Group
Id>);
Ex:
FND_CLIENT_INFO.SETUP_CLIENT_INFO(application_id
=> 660,
responsibility_id
=>21623,
user_id =>0,
security_group_id
=>0);
How
to set Client Info in Reports?
Before Report:
DBMS_APPLICATION_INFO.SET_CLIENT_INFO
('org_id');
Ex: DBMS_APPLICATION_INFO.SET_CLIENT_INFO (103);