In Oracle E-Business Suite, it becomes necessary to do this call when an API is called or SQL Query is run from SQ Plus/TOAD like tools. This ‘fnd_global’ API calls sets the environment properly so that SQL Queries specific to few key base tables return rows back.
This ‘fnd_global’ API call has 3 key parameters
fnd_global.apps_initialize (user_id, responsibility_id, responsibility_application_id)
For example, in SQL Plus, this can be called as shown below:
Where, 123 – user_id from fnd_user table
456 – responsibility_id from fnd_responsibility table
800 – application_id from fnd_application table