BI APPS 7.9.6.x: EBS HR-ORG Based Security SQL Does Not Return All Organizations (Doc ID 1594352.1)

Last updated on JULY 31, 2014

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6 [1340] to 7.9.6.4 [Release V7]
Information in this document applies to any platform.

Symptoms

SQL provided in the BI Apps Security Guide Release 7.9.6.x for HR ORG based security does not return all organizations allowed for a user based on his responsibilities/security profile in EBS. 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms