Search Results hri_bpl_oe_order




Overview
Explore in AI Chat

Overview

APPS.HRI_BPL_OE_ORDER is a valid PL/SQL package in the Oracle E-Business Suite Applications schema (APPS), classified under the ETRM object repository as an "OTHER" API type. It belongs to the HRI (Human Resources Intelligence) BPL (Business Process Library) family of packages, a set of utility programs used within Oracle EBS analytics and self-service reporting frameworks to resolve business keys and identifiers at runtime. In the context of Oracle EBS 12.1.1 and 12.2.2, this package serves as an internal helper for order management data extraction, providing lookup routines that translate or derive reference identifiers associated with Order Management entities.

The package is confirmed VALID in the ETRM metadata and is documented with both a package specification and package body. Its positioning in the HRI_BPL namespace indicates it is invoked by reporting or extraction engines rather than transactional forms, and it is explicitly listed as referenced by OTFV_CUST_RESTRICTED_EVENTS, an Order Management-related view/event object. The package depends on SYS.STANDARD, the standard PL/SQL package.

Key Procedures and Functions

The ETRM metadata documents three callable units, each oriented toward resolving identifiers from Order Management records:

  • GET_LINE_NUMBER — Retrieves the line number associated with an order line, allowing callers to resolve the human-readable line sequence for a given Order Management line record.
  • GET_ORDER_NUMBER — Retrieves the order number for a given Order Management header or order entity, providing the business-facing order identifier.
  • GET_HEADER_ID — Resolves the internal header identifier (HEADER_ID) for an order, which is the primary key used across Order Management tables.

These routines are identifier-resolution helpers rather than transactional APIs. Their purpose is to map between internal surrogate keys and the business-visible numbers used in reporting, analytics, and downstream event processing. No parameter lists are published in the provided metadata, and their signatures should not be assumed from this summary.

Tables Accessed

The package references two core Order Management tables via APPS synonyms:

  • OE_ORDER_HEADERS_ALL — The canonical Order Management header table, storing one row per order. It is accessed to obtain the order number and the header identifier.
  • OE_ORDER_LINES_ALL — The Order Management lines table, storing one row per order line. It is accessed to obtain line numbers and to relate lines to their parent header.

These tables are the standard Order Management base tables, consistent with the identifier-resolution role described above. The package is expected to perform read-only lookups against them.

Usage Notes

HRI_BPL_OE_ORDER is typically invoked indirectly by other Oracle EBS components rather than called directly by end users. In this deployment, it is referenced by OTFV_CUST_RESTRICTED_EVENTS, indicating use within an Order Management or fulfillment event/analytics flow. Custom code, BI Publisher reports, or concurrent programs that require order, line, or header identifier resolution against OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL may call these procedures, though they should be treated as internal and unsupported for direct customer use. Because they rely on standard Order Management tables, behavior is consistent across both 12.1.1 and 12.2.2. Developers should validate signatures in the target instance before calling these routines from custom code.