Dear All,
When you received the following Warning message on login page of Oracle Application...
Reason: "FND: Debug Log Enabled" Profile Set to "YES".
Solution: "FND: Debug Log Enabled" Profile Set "NO"
Navigator:
Login ---> system administrator responsibility ---> System Profile Values ---> "FND: Debug Log Enabled" Profile.
Tuesday, April 14, 2009
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
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:
Posts (Atom)