Wednesday 15 December 2021

How to set org context in Oracle Apps R12 in back-end in case of multiple org-id?

Set Multi org/Single org operating unit form plsql:
1-exec MO_GLOBAL.INIT('Give Application name');
To set Multi Org unit:
2- exec MO_GLOBAL.INIT('M');
To set Single  Org unit:
3- exec MO_GLOBAL.INIT('S');
Explanation: mo_global.init checks the application_short_name parameter against table fnd_mo_product_init and decides by the table's status column to proceed further with multiple or single org logic.

If the application_short_name parameter passed is not registered in that table, mo_global.init will fail. Oracle added the dummy short names 'M' and 'S' to fnd_mo_product_init to allow calling the procedure without a real apps name.



-Initialization of view
R12--> mo_global.set_policy_context(S,org_id) ;

11i -> dbms_application_info.set_client_info(:org_id);
If we know the user id, rep id, and app_resp_id then we can use the below query
fnd_global.apps_initialize(:p_user_id, :p_resp_id, :p_app_resp_id);

No comments:

Post a Comment