How can we retrieve data from standard Oracle Applications view?


All views in release 11.5 are operating unit dependent. Before querying from the views, org context needs to be set.

OBTAINING ORG_ID AND SETTING CONTEXT
———————————————————
1) Please launch the applications and select the appropriate responsibility

2) Then use Edit -> Preferences -> Profiles

3) Query for profile MO: Operating Unit

4) Place cursor in the field where the operating unit is specified (Default Value or User Value)

5) Then use Help > Diagnostics > Examine
and then select $PROFILE_VALUES in block and then DEFAULT_PROFILE_VALUE or PROFILE_OPTION_VALUE as
field

6) Get this value and then set the context using SQL:
SQL> Exec dbms_application_info.set_client_info(&org_id)

7) Now run the query for the view

One thought on “How can we retrieve data from standard Oracle Applications view?

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