Tuesday, December 04, 2012

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;
 ******************************************************************************

2 comments:

  1. Anonymous11:40:00 PM

    Having read this I believed it was really informative.
    I appreciate you finding the time and energy to put this article
    together. I once again find myself personally spending a significant amount of time both reading and posting comments.
    But so what, it was still worthwhile!

    Also visit my web page -

    ReplyDelete
  2. Anonymous6:48:00 AM

    Heya just wanted to give you a quick heads up and let you know a few of the pictures aren't loading correctly.
    I'm not sure why but I think its a linking issue.
    I've tried it in two different web browsers and both show the same
    results.

    ReplyDelete






Please provide your valuable feedback ............