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