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