Search Results sync_star_itemcatg_from_coi

Overview

INV_ENI_ITEMS_STAR_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM (E-Business Suite Technical Reference Manual) as an "OTHER" API. It belongs to the Enterprise Item (ENI) integration layer of the Inventory module, a set of components introduced to support the synchronization of item master and item category data with external or downstream systems through the Item Open Interface and associated staging infrastructure. The "STAR" suffix indicates that the package operates on staged item records — that is, rows held in intermediate or staging tables prior to validation and import into the production item and category tables. The package is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2, and it exposes four documented procedures. Its primary business purpose is to keep staging data aligned with the current state of items and category assignments, and to propagate category set assignments from the source interfaces into the ENI staging structures so that subsequent concurrent processes can validate and load them cleanly.

Key Procedures and Functions

The package exposes the following four documented subprograms, whose purposes are described without reference to specific parameter lists:

• SYNC_CATEGORY_ASSIGNMENTS — Reconciles category assignments between the interface tables and the ENI staging tables. It ensures that category set associations for staged items are current and internally consistent before downstream validation.
• UPDATE_ENI_STAGING_TABLE — Applies updates to the ENI staging table, reflecting changes detected in source item or category data. It is the mechanism by which staged rows are refreshed rather than re-created.
• SYNC_STAR_ITEMS_FROM_IOI — Synchronizes staged STAR item records from the Item Open Interface (IOI). This procedure pulls item-level data originating from the open interface into the ENI staging structures.
• SYNC_STAR_ITEMCATG_FROM_COI — Synchronizes staged STAR item category records from the Category Open Interface (COI), moving category-level assignments into the ENI staging area.

Tables Accessed

The ETRM metadata for this package does not enumerate specific base tables. Recorded dependencies are limited to the SYS schema and the STANDARD package, consistent with a package body that is largely procedural. Functionally, the procedures operate against the ENI staging table (referenced by UPDATE_ENI_STAGING_TABLE) and the source Item Open Interface and Category Open Interface tables implied by the SYNC_STAR_ITEMS_FROM_IOI and SYNC_STAR_ITEMCATG_FROM_COI procedures. Because the APPS synonyms referenced are not itemized in the available metadata, the exact table names should be confirmed by inspecting the package body in the database. The absence of documented APPS-synonym table references suggests the package reads and writes through interface table views or dynamic references rather than static base-table names.

Usage Notes

INV_ENI_ITEMS_STAR_PKG is referenced by four other packages: INVIDIT2, INVPOPIF, INV_ITEM_CATEGORY_OI, and INV_ITEM_CATEGORY_PVT. This dependency pattern indicates that the package is invoked indirectly during Item Open Interface processing, item import, and item category open interface flows rather than being called directly from a form. It is typically triggered by concurrent programs that load or validate item and category interface data, or by the calling packages listed above during their own processing of staged records. Custom code extending the ENI or Item Open Interface flows may call these procedures directly to force synchronization of staged item and category data. Because the package belongs to the ENI integration layer, changes to it should be treated as high-impact: it participates in the data path feeding the item and category open interfaces and, as such, is subject to the standard EBS patching and upgrade processes for APPS-owned objects.