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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment