Sunday, April 27, 2014

SQL statements to initialize org id in session

In order to retrieve data from organization specific views like AP_INVOICES, PO_LINE_LOCATIONS . We need to initialize organization id in session , we can do that by executing below statements .

if oracle apps version is R12 or more .

Begin
mo_global.set_policy_context('S', &org_id);
End;

oracle apps version is 11i,

Begin
apps.Fnd_Client_Info.Set_Org_Context(&org_id);
End;

No comments:

Post a Comment