Search Results update_interface_table




Overview
Explore in AI Chat

Overview

APPS.EGO_ICC_BULKLOAD_PVT is the private implementation package body that supports bulk loading of Item Catalog Group and Item Catalog Category (ICC) definitions in Oracle E-Business Suite. It is part of the EGO (Enterprise Goods and Oracle Product Information Management) metadata bulkload framework, and it is specifically responsible for processing staged rows that originate from external spreadsheets or interface files and are loaded into interface tables before being validated and merged into the base ICC tables.

The package is classified as PVT, meaning it is not intended as a public API. Its procedures are invoked internally by the bulkload controller logic, primarily from the concurrent program that drives ICC interface imports. In Oracle EBS 12.1.1 and 12.2.2, the package continues to serve the same purpose: it translates user-maintained interface rows into validated catalog group associations, transaction attribute definitions, and catalog version records. The package body includes extensive debugging support through the write_debug and log_error helper routines, which route messages to the EGO_METADATA_BULKLOAD_PVT logger and the interface error tables.

Key Procedures and Functions

The documented procedures and functions of EGO_ICC_BULKLOAD_PVT are:

  • IMPORT_ICC_INTF — The main entry point. It reads the staged ICC interface rows, performs validation and lookup resolution, and drives the loading cycle. It is the primary target for users searching for an "update interface table" style operation, as it coordinates the movement of data from interface to base tables and manages the associated status updates.
  • GET_CATALOG_GROUP_ID — Resolves or retrieves the internal catalog group identifier required to associate incoming interface records with the correct Item Catalog Group.
  • DELETE_PROCESSED_ICC — Removes interface rows that have already been processed, preventing duplicate or stale records from being re-imported during subsequent runs.
  • CONSTRUCT_COLLTN_AND_VALIDATE — Constructs the in-memory collection of interface records and performs validation checks before the data is committed to the base tables. This procedure underpins the version comparison logic that ensures new versions are created only when transaction attributes change.

These procedures work together to guarantee that bulk ICC loads are idempotent, validated, and consistent with existing catalog versions. The package also maintains several package-level counters (g_icc_rec_count, g_ag_assoc_rec_count, g_fn_param_map_count, g_icc_vers_rec_count) that track how many records were processed in each category during a single run.

Tables Accessed

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

Usage Notes

EGO_ICC_BULKLOAD_PVT is not called directly from Oracle Forms. It is invoked by the bulkload concurrent program and by the parent bulkload framework. The documented metadata shows it is referenced by two other packages, confirming its role as a subordinate implementation unit rather than a standalone API. Customizations should not call this package directly; instead, use the public EGO product interfaces and the standard bulkload concurrent program. When troubleshooting "update_interface_table" behavior, the relevant logic is found in IMPORT_ICC_INTF and CONSTRUCT_COLLTN_AND_VALIDATE, which together stage, validate, and update interface rows before DELETE_PROCESSED_ICC clears the processed records after a successful run.