fnd_global.apps_initialize 11i, R12 and SQL

fnd_global.apps_initialize

In Oracle E-Business Suite, it becomes necessary to do this call when an API is called or SQL Query is run from

SQL 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(125,400,700);

Where,

125 – user_id from fnd_user table

400 – responsibility_id from fnd_responsibility table

700 – application_id from fnd_application table

******************************************************************************

Release 12

begin

fnd_global.apps_initialiase(user_id, responsibility_id, responsibility_application_id );

mo_global.set_org_context(81,NULL,'SQLAP');

end;

 ******************************************************************************

Oracle 11i

BEGIN

fnd_global.apps_initialize(user_id, responsibility_id, responsibility_application_id);

END;

 ******************************************************************************