Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Apps - Using FND_GLOBAL.APPS_INITIALIZE() function

HawkerHunterDec 27 2021

Hello friends,
I want to use a few public APIs to create/update records in Oracle EBS base tables.
I understand that before using the APIs I have to use the FND_GLOBAL.APPS_INITIALIZE(user_id,resp_id, resp_appl_id) function to initialize the Oracle APPS environment if we use the APIs in our script to be run from SQL Developer or Toad.
I would like to know, how to use this function at run time i.e.: to fetch the login user id, resp_id and resp_appl_id and feed in to FND_GLOBAL.APPS_INITIALIZE () function for the person who has run the concurrent program and the responsibility from which the user has run the program.
Or is it that at runtime, we do not have to initialize the environment using FND_GLOBAL.APPS_INITIALIZE () function at all.
Thanks and Regards
Hawker

Comments
Post Details
Added on Dec 27 2021
1 comment
16,717 views