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_initialize(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;
******************************************************************************
TKS very much, help me a lot.
ReplyDelete