Search Results ak_region_code

Overview

APPS.HRI_MTDT_AK_REGION is a metadata registry package body belonging to the Oracle E-Business Suite Human Resources Intelligence (HRI) product family. Its role is to seed and expose the mapping between Application Key (AK) region identifiers, used by the Oracle EBS Analytics and KPI/portlet framework, and Oracle Human Resources worker type classifications. In Oracle EBS 12.1.1 and 12.2.2 the HR Intelligence dashboards, contingent worker KPIs, and related portlets resolve their target population by joining a region code (for example HRI_K_WMV_C_ATVTY) to a worker type surrogate key foreign key value such as CWK, denoting contingent workers. This package body supplies that association programmatically so that the AK region metadata definitions remain consistent with the delivered HRMS analytics content, rather than being hard-coded in each individual report or portlet definition.

The package header carries the version identifier hrimdakr.pkb 120.5 with a header date of 2005/09/20, confirming it is shipped as a standard, non-customized Oracle object (noship) and has been carried forward largely unchanged into the 12.2.2 code line.

Key Procedures and Functions

The ETRM metadata documents a single entry point:

• GET_AK_REGION_WKTH_WKTYP — Returns the worker type surrogate key association for a given AK region code. It is the public accessor that allows callers in the Analytics region engine to translate an AK region identifier into the worker type context (WKTH / worker type) that governs which employees or contingent workers appear in the associated KPI or portlet query.
• set_metadata — An internal, package-initialization procedure. It populates the private collection l_ak_region_mtdt_tab of type ak_region_metadata_tabtype by repeatedly assigning region codes to worker type keys. All entries visible in the source excerpt map region codes to the value CWK, indicating exclusive coverage of contingent worker content in this release.

The seeded regions follow a clear naming convention: HRI_K_ prefixes KPI reports (for example contingent activity and contingent low-performer KPIs), while HRI_P_ prefixes portlets and graphs, including supplier, workload, and low-performer bucket variants.

Tables Accessed

No database tables are referenced directly by this package. Metadata is held entirely in the PL/SQL associative array l_ak_region_mtdt_tab, keyed by the AK region code string and indexed into the HRMS worker type column. The ETRM record lists no APPS synonyms accessed and no direct table dependencies, which is consistent with a pure lookup package whose data is compiled into the database rather than persisted in a table.

Usage Notes

This package is invoked implicitly rather than by end users. When the Oracle EBS Analytics engine renders HR Intelligence KPI reports or dashboard portlets, it resolves the region definition through HRI_MTDT_AK_REGION, thereby determining that the region should be evaluated against the contingent worker population. Because the package is dependency-free and has no callers recorded in the ETRM metadata, it is best treated as an internal framework component in Oracle EBS 12.1.1 and 12.2.2. Extensions or custom regions that introduce non-contingent worker types would require Oracle-supplied configuration rather than direct modification of this seeded body, since the region list is fixed at compile time. The package should not be modified in a production instance; any change invalidates the object's standard status and may break the AK region resolution performed by the Analytics layer.