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

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s