Search Results load_interface_lines

Overview

EGO_ITEM_AML_PVT is a private PL/SQL package in the APPS schema that supports the Approved Manufacturer List (AML) interface within Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its central role is to move AML data from the open interface staging table into the production item master structures, and to purge processed or rejected rows from that staging area. The AML interface is part of the broader item interface framework managed by the EGO (Enterprise Governance and Optimization) module, which governs item definition, revision control, and lifecycle management in R12.

The package is classified as a PVT API, meaning it is not intended for direct customer invocation. It is consumed internally by other EGO packages, most notably EGO_ITEM_OPEN_INTERFACE_PVT, which orchestrates the item open interface process as a whole. The AML interface allows manufacturers and manufacturer part numbers to be associated with items in bulk, either as new assignments or as updates and deletions against existing AML entries.

Key Procedures and Functions

• LOAD_INTERFACE_LINES — Reads rows staged in the AML open interface and validates then loads them into the item master AML tables. This procedure performs the core insert and update work, resolving references to manufacturers, manufacturer part numbers, item catalog groups, and object lifecycle definitions. Validation failures are typically written to the interface error table for review and correction.
• DELETE_AML_INTERFACE_LINES — Removes rows from the AML interface staging table once they have been successfully processed or after they have been identified as unprocessable. This supports the cleanup phase that keeps the interface table manageable across repeated submission cycles.

Tables Accessed

The package touches a substantial set of base and interface tables, all referenced through APPS synonyms:

• EGO_AML_INTF — the AML open interface staging table that holds incoming AML rows to be loaded or deleted.
• MTL_MFG_PART_NUMBERS and MTL_MANUFACTURERS — the production manufacturer and manufacturer part number records that AML rows resolve to or create.
• EGO_MFG_PART_NUM_CHGS — captures changes to manufacturer part numbers that result from the load.
• MTL_ITEM_CATALOG_GROUPS_B, MTL_PARAMETERS, and EGO_OBJ_TYPE_LIFECYCLES — provide item catalog group, inventory organization parameter, and lifecycle context used during validation and insertion.
• EGO_IPI_TRANSACTION_ID_S — supplies transaction identifiers for interface activity.
• MTL_INTERFACE_ERRORS — receives error messages when interface rows fail validation.
• FND_LOOKUP_VALUES, FND_DESCR_FLEX_CONTEXTS, FND_OBJECTS, FND_NEW_MESSAGES, and FND_USER — support lookups, descriptive flexfield context resolution, object registration, error message text, and user identification.
• HZ_PARTIES — used in the context of party or supplier identification where AML data references trading partners.

Usage Notes

EGO_ITEM_AML_PVT is invoked indirectly whenever an AML interface load is executed through the item open interface process. In the standard R12 flow, users populate the EGO_AML_INTF table via a SQL*Loader or similar mechanism, then submit the Item Open Interface concurrent program. EGO_ITEM_OPEN_INTERFACE_PVT calls this private package to perform the load and subsequent deletion of interface rows. The package should not be called directly from custom code; instead, the public interface package EGO_ITEM_OPEN_INTERFACE_PVT or the seeded concurrent program should be used so that commit control, error handling, and validation ordering remain intact.

Because this is a PVT package, Oracle does not guarantee its signature across patches or upgrades. Any custom dependency on the internal procedures described above is unsupported and should be reviewed during upgrade testing from 12.1.1 to 12.2.2, since the underlying EGO and MTL table structures and lifecycle logic evolved between those releases.