Search Results hri_bpl_geography

Overview

HRI_BPL_GEOGRAPHY is an Oracle EBS PL/SQL package owned by the APPS schema that belongs to the Oracle HR Intelligence (HRI) family of business processing logic (BPL) components. It supports the geography and regional dimension of the HR Intelligence analytical model by resolving and delivering geographic attributes used across HR reporting and warehousing structures. In the context of Oracle EBS 12.1.1 and 12.2.2, this package functions as a utility layer within the HR Intelligence stack that exposes standardized geographic reference data to dependent views and packages.

The package carries a status of VALID in the ETRM metadata and is classified as an OTHER API type, indicating it is an internal supporting component rather than a public, versioned integration API. Its primary dependency footprint is light: it references SYS.STANDARD and is referenced by HRI_OLTP_VIEW_GEOGRAPHY.

Key Procedures and Functions

The documented package interface consists of a single callable:

• GET_REGION_CODE — Returns a region code value associated with a geographic entity. This function supports the HR Intelligence geography dimension by translating geographic context into a standardized region identifier, allowing reporting structures to classify and group data by region.

No parameter lists are published in the available metadata, and no other procedures or functions are documented for this package. The package body is present and valid, though its internal helper routines are not exposed in the ETRM documentation.

Tables Accessed

The package interacts with the following tables through APPS synonyms:

• HR_LOCATIONS_ALL — Stores the physical location definitions for an enterprise, including address, region, and geographic classification data. GET_REGION_CODE relies on this table as the source of truth for location-based region resolution.
• BIS_DIMENSIONS — The Business Intelligence System dimension repository, which defines the analytical dimensions used by Oracle HR Intelligence. Access to this table allows the package to align geographic values with the dimensional model used by HR reporting and the warehouse.

These two tables together indicate that the package bridges operational HR location data and the analytical geographic dimension.

Usage Notes

Because HRI_BPL_GEOGRAPHY is referenced by HRI_OLTP_VIEW_GEOGRAPHY, its most common invocation path is indirect: the geography view calls the package during query execution to derive region codes for dimensional reporting. The package is not intended to be called directly from end-user forms or seeded concurrent programs; it operates beneath the HR Intelligence reporting layer.

Custom development should treat this package as an internal component. Direct calls are possible from custom PL/SQL where region-code resolution is required, but such usage depends on the stability of the HRI schema and should be validated against each EBS release, particularly when upgrading between 12.1.1 and 12.2.2. The reference relationship shown in the metadata is limited to a single dependent entity, confirming its narrow, specialized role. Oracle lists this object under proprietary confidential documentation; no public API contract or parameter interface is published, so consumers should not assume signature stability across patches. Where region resolution is needed outside HR Intelligence, the underlying HR_LOCATIONS_ALL data can be queried directly, but doing so bypasses the dimensional alignment provided by the package and BIS_DIMENSIONS.