This content has been marked as final. Show 3 replies
Pl post details of OS, database and EBS versions.
When executing in APPS, you need to set context before querying ".._ALL" tables
How to set the Organization Context in R12? [ID 437119.1]
Oracle Applications Multiple Organizations Access Control for Custom Code [ID 420787.1]
Setting the Applications Context (FND_GLOBAL.APPS_INITIALIZE) [ID 209185.1]