Search Results edw_sicm_inv_lines_hook

Overview

EDW_SICM_INV_LINES_HOOK is an Oracle Application Object Library package owned by the APPS schema. It belongs to the Oracle Enterprise Data Warehouse (EDW) and Supply Chain Intelligence (SICM) family of database objects, and its identification header (FIIAILHS.pls, version 120.0, dated August 2002) associates it with the procurement and payables extract framework. The package is classified under the generic API classification of OTHER within the ETRM repository, indicating that it is not a public, supported business API but rather an internal hook used by the warehouse collection infrastructure.

Its stated business purpose, inferred from its name and its single exposed function, is to act as a pre-collection hook for invoice line fact extraction. In the EBS warehouse architecture, the fact collection process invokes registered hook packages at defined points so that customer-specific or module-specific logic can prepare, filter, or augment data before the primary fact load executes. EDW_SICM_INV_LINES_HOOK fulfils that role for the AP invoice lines fact group, allowing the caller to determine whether collection should proceed.

Key Procedures and Functions

The package exposes exactly one documented program unit, as declared in the specification:

• Pre_Fact_Collect — A function that returns a BOOLEAN. It accepts one argument, p_object_name, which identifies the fact or object being collected. The function is designed to be called before fact collection occurs, allowing the implementation to perform preparatory validation, configuration checks, or conditional logic that influences whether the subsequent collection step runs. A TRUE return value conventionally signals that collection may continue.

No additional procedures, functions, or overloads are documented in the package specification. The implementation body is not part of the published metadata, so the specific conditional logic executed by Pre_Fact_Collect is not externally documented.

Tables Accessed

ETRM records five tables referenced through APPS synonyms during execution of the package:

• FII_AP_INV_LINES_FSTG — The staged AP invoice lines fact table, the primary target of the invoice lines collection process. The hook likely inspects staging state or volume before collection begins.
• EDW_ITEM_ITEMORG_LTC — An item-to-item-organization level table used within the EDW item dimension load, referenced for item organization context.
• EDW_ITEM_ITEMREV_LTC — The corresponding item revision level table, used to resolve item revision information during dimension processing.
• POA_DNB_ITEMS — A Dun & Bradstreet item classification table, typically used for supplier and spend analytics enrichment.
• POA_DNB_TRD_PRTNR — The associated D&B trading partner table, supplying partner-level attributes for the same analytics domain.

These references indicate that the hook validates or prepares item dimension and trading partner context in support of the invoice lines fact load.

Usage Notes

As a hook package, EDW_SICM_INV_LINES_HOOK is not invoked directly by end users. It is called by the fact collection driver during the extraction and load cycle, most commonly when the invoice lines collection program is executed from the Supply Chain Intelligence Administrator responsibility or through the corresponding concurrent program. Reference metadata confirms the package is referenced by one other package within the APPS schema, consistent with its subordinate, callback-style role.

Customers implementing extensions generally do not modify this package; instead they may attach custom logic through supported extension mechanisms. Custom code should treat Pre_Fact_Collect as an internal call point. Because the package is shipped with the EBS data warehouse extract components, it is present in both release 12.1.1 and 12.2.2 with an unchanged specification signature.