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:

Exec fnd_global.apps_initialize(123,456,800);

Where, 123 – user_id from fnd_user table
456 – responsibility_id from fnd_responsibility table
800 – application_id from fnd_application table