Low Level Logging Enabled

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.

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