Showing posts with label Oracle Report. Show all posts
Showing posts with label Oracle Report. Show all posts

Saturday, April 11, 2009

How to Retrieve row from TABLE or SYNONYM for an ORG_ID in r12

I hope everyone face this issue when try to retrieve rows from TABLE or SYNONYM for an Org_id.

for example:
select * from AR_CASH_RECEITPS_V;

Result: NO ROWS SELECTED

Actually Security reason we can't retrieve rows from ORG ID tables/synonym. we need to set "ORG ID" first.

For the R12
SQL*Plus
exec mo_global.set_policy_context('S', &org_id);

Toad and SQL Developer
Begin
mo_global.set_policy_context('S', &org_id);
End;

Refer Metalink Note for more details: 416710.1