Search Results get_org_id

Overview

APPS.HRI_BPL_SECURITY is a PL/SQL package belonging to the Oracle HR Intelligence (HRI) product family, specifically the Business Intelligence (BPL) layer that supports Oracle Business Intelligence Applications integrated with Oracle E-Business Suite. Its principal business function is to resolve the identity of the user or the organizational context under which a Business Intelligence session is executing, based on the Oracle EBS responsibility used at sign-in. Because OBIEE dashboards can be launched from, or embedded within, multiple EBS responsibilities, the package exists to translate the logged-in responsibility into the correct person, manager, or organization identifier so that row-level security and data visibility rules are applied consistently.

The package header carries the version string hribpscr.pkh 120.1 and is documented as an OTHER-classified API owned by APPS. The ETRM metadata records six documented program units and a dependency on the FND_RESPONSIBILITY table.

Key Procedures and Functions

The package exposes the following documented program units (parameter lists are intentionally omitted below; only documented purpose is described):

• GET_NAMED_USER_PROFILE_VALUE — Returns the value of the profile option HRI_DBI_CHO_NMD_USR. This provides a simple accessor for a CHO (Choice) profile setting that governs named-user behaviour in the BI environment.
• GET_APPS_SIGNIN_PERSON_ID — A wrapper function that checks the new CHO profile option and returns its value when set; otherwise it falls back to FND_GLOBAL.EMPLOYEE_ID. This centralises the logic for determining the effective person identity at BI sign-in.
• GET_MGR_ID — Returns the manager identifier in OBIEE depending on the responsibility used to log in. Two versions are documented: one accepting parameters and an overloaded version that takes no parameters and derives its inputs through FND packages.
• GET_ORG_ID — Returns the organization identifier in OBIEE depending on the responsibility used to log in. As with GET_MGR_ID, both a parameterised form and a no-parameter overload exist; the overloaded form uses FND packages to set its parameters automatically. This is the function referenced by the user search term "get_org_id".

Tables Accessed

The only table documented as referenced through APPS synonyms is FND_RESPONSIBILITY. The package reads this table to map the responsibility under which a user is signed in to the corresponding organization or manager context. Because responsibility definitions carry the application and responsibility identifiers used as inputs to GET_ORG_ID and GET_MGR_ID, FND_RESPONSIBILITY is the natural source for that mapping. No writes to this table are indicated; access is read-only.

Usage Notes

HRI_BPL_SECURITY is intended for consumption by the BI/OBIEE integration layer rather than by standard EBS forms. It is typically invoked from BI session-initialisation logic, where the responsibility context must be resolved before dashboard queries execute. The presence of no-argument overloads means callers that already have an established FND session context can obtain the organization or manager identifier without supplying parameters, while callers operating outside that context can pass employee, responsibility, and application identifiers explicitly.

The package is documented as referenced by zero other packages, indicating it is largely a leaf-level utility within the APPS schema. Custom code should therefore call it directly when BI-context organization or manager resolution is required, and should treat the profile option HRI_DBI_CHO_NMD_USR as the controlling switch for named-user behaviour. Global variables g_resp_id and g_resp_key are declared in the header and are available to session-level logic within the package.