How To Run SQL as An Applications Mode in SQL*PLUS


  1. Login to SQL*PLUS as the ‘APPS’  application user.
  2. Obtain the user id, responsibility id, application id and security group for the intended applications user/responsibility combination you want to run the SQL with:
      1. SELECT USER_ID,RESPONSIBILITY_ID,RESPONSIBILITY_APPLICATION_ID,
        SECURITY_GROUP_ID
        FROM FND_USER_RESP_GROUPS
        WHERE USER_ID = (SELECT USER_ID
        FROM FND_USER
        WHERE USER_NAME = '&user_name')
        AND RESPONSIBILITY_ID = (SELECT RESPONSIBILITY_ID
        FROM FND_RESPONSIBILITY_VL
        WHERE RESPONSIBILITY_NAME = '&resp_name');
  3. Execute the APPS_INITIALIZE function to authorize the user:
      1. exec FND_GLOBAL.APPS_INITIALIZE (user_id, resp_id, appl_id, security_group_id );
  4. Run any sql, result will based on result you get when u see it through Oracle Applications.
Advertisements

One thought on “How To Run SQL as An Applications Mode in SQL*PLUS

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s