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

No comments: