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]
Please set the application context as per (fnd_request.submit_request Returning 0 Using pl/sql block [ID 812879.1]).
I just follow all your suggestion.. this is a great help..thank you.