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


1 comment to fnd_global.apps_initialize

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>