Search Results load_intersections_interface




Overview
Explore in AI Chat

Overview

The APPS.EGO_ITEM_BULKLOAD_PKG package is a core component of the Oracle E-Business Suite Product Information Management (PIM) / Item Master bulk-loading framework. It is classified under the EGO (Engineering/Product Data) application schema and carries an API classification of OTHER, indicating that it is primarily an internal engine rather than a documented public API. Its central business function is to orchestrate the insertion and processing of item-related interface records submitted through the bulk-loading mechanism, transforming staged interface rows into validated, actionable data that the Item Master and related structures can consume.

The package is tightly bound to the EGO bulk-load architecture. It references EGO_BULKLOAD_ENTITIES and is itself referenced by EGO_BULKLOAD_ENTITIES, forming the linkage that associates an imported batch with the specific entity handlers responsible for processing its rows. This relationship positions EGO_ITEM_BULKLOAD_PKG as an entity-level processor invoked during batch execution. The package is marked VALID in both 12.1.1 and 12.2.2 environments, and it depends on FND_API for standard return-status handling and error management.

Key Procedures and Functions

The documented package exposes eight procedures and functions, each supporting a distinct phase of bulk-load processing:

  • PROCESS_ITEM_INTERFACE_LINES — The primary entry point that iterates over staged item interface rows and drives them through validation and insertion logic.
  • LOAD_INTERSECTIONS_INTERFACE — Populates intersection (cross-reference) interface tables, linking imported items to related entities.
  • PROCESS_NETWEIGHTS — Processes net weight attributes associated with imported items.
  • GET_DESC_GEN_METHOD — Retrieves the description generation method used to determine how item descriptions are derived during load.
  • GET_TRADE_ITEM_DESCRIPTOR — Returns the trade item descriptor, supporting compliance and trade-item identification requirements.
  • CLEAR_GTIN_ATTRS — Clears Global Trade Item Number (GTIN) attributes, typically invoked during cleanup or re-validation.
  • POPULATE_SEQ_GEN_ITEM_NUMS — Generates and assigns sequential item numbers where automatic numbering is configured.
  • INSERT_MTL_INTF_ERR — Writes error records into the MTL interface error structure when validation or processing fails.

Tables Accessed

The package operates across a broad set of interface and base tables via APPS synonyms. Item and batch staging is handled through EGO_BULKLOAD_INTF, EGO_IMPORT_BATCHES_B, and EGO_ITM_USR_ATTR_INTRFC (user-defined attribute interface). Cross-reference and AML data flow through EGO_AML_INTF and EGO_ITEM_PEOPLE_INTF. Structure-related interfaces include BOM_BILL_OF_MTLS_INTERFACE, BOM_COMPONENT_OPS_INTERFACE, BOM_INVENTORY_COMPS_INTERFACE, BOM_REF_DESGS_INTERFACE, and BOM_SUB_COMPS_INTERFACE, enabling bill-of-material and component data to be bulk-loaded alongside items. Supplier sourcing data is drawn from AP_SUPPLIERS and AP_SUPPLIER_SITES_ALL. Configuration and hierarchy context is provided by EGO_DATA_LEVEL_B, EGO_FND_DF_COL_USGS_EXT, and BOM_COMPONENT_COLUMNS.

Usage Notes

This package is not intended for direct invocation by end users. It is called internally by the EGO bulk-loading framework when a batch of item data is submitted, most commonly through the Item Import / Bulk Load concurrent programs or the PIM bulk-load interface. Custom code should avoid calling its procedures directly, since the parameter lists and sequencing are owned by Oracle. Because EGO_ITEM_BULKLOAD_PKG is referenced by one other package (in addition to EGO_BULKLOAD_ENTITIES), integrators should treat it as an internal dependency and route their loading through the supported EGO interface tables instead.