Thursday, October 16, 2008

Initializing Oracle Applications environment in Oracle Release 12i

Initializing Oracle Applications environment in Oracle Release 12i
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Problem Description : Not able to see data from views synonyms even after setting the apps envirenment in Oracle applications release 12i
----------------------------------------------
We need to set the mo global parameter to see the data in 12i , If
R12 Multi-Org Access Control (MOAC) exists in setup.

begin
fnd_global.apps_initialize(1210, 20678, 222);
mo_global.init('AR');
end;

The parameters used here are:
1. User_ID
2. Responsibility_ID
3. Responsibility_Application_ID


Link for more details
http://www.ltsolutions.eu/r12_pdf/R12_Multi-Org_Access_Control.pdf
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

No comments: