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

oracle oracle-apps oracleapplications
Nikhil picture Nikhil · Mar 13, 2014 · Viewed 94.2k times · Source

I have executed the query for single org-id and it is working properly.

begin mo_global.set_policy_context('S',204); end;

But for multiple cases I executed the following queries but it is not working

begin mo_global.set_policy_context('M',204); end;

Even I tried running this- begin mo_global.set_policy_context('M',null); end;

I just want to know the 2nd parameter in case of multiple org-id.

Answer

Andy Haack picture Andy Haack · May 26, 2016

a simple and failsafe call for multiple org init is:

exec mo_global.init('M');

and for single:

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.

Related questions

Oracle EBS: Get profile values

I was working with Oracle R12 application.Can anybody suggest some queries to identify the Profile names and Profile values related to a particular product/item selected?? I tried using SELECT * FROM fnd_profile_options_vl po, fnd_profile_option_…

Read More
Issue while running UNIX shell script from Oracle concurrent Program

I am trying to run a HOST script which I have build in KSH shell using an Oracle Concurrent Program. My Test script is as follows: echo "System Parameters passed by Concurrent Manager" echo "+--------------------------------------------+" XXWIN_PROGRAM=$0 XXWIN_LOGIN=$1 XXWIN_…

Read More
Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More