Search Results ego_icc_bulkload_pvt




Overview
Explore in AI Chat

Overview

EGO_ICC_BULKLOAD_PVT is the private bulk-loading engine that supports the Item Catalog Category (ICC) interface within Oracle E-Business Suite. Internet-enabled Item Catalog Categories, together with Smart Items, are maintained by Oracle Product Information Management / Inventory, and the ICC functionality allows administrators to define and edit item catalog category structures, generated attribute functions, and attribute group associations. Because these structures are frequently maintained in volume, EBS provides an interface-table based bulk load mechanism rather than relying exclusively on the maintainable UI. This package is the program unit that consumes records staged in the ICC interface tables and applies them to the base tables.

The package is classified as PVT (private API), sitting beneath public entry points such as the concurrent-based interface processing logic. It is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema (ordinarily APPS) rather than the package owner. Header comment history indicates the file EGOVICCS.pls at version 120.4, so it is a legacy ICC component carried forward into 12.1.1 and 12.2.2.

Internally, the package declares constants that identify the bulk-load entities — ICC_HEADER, ICC_VERSIONS, AG_ASSOCS, ICC_FUNCTIONS, and FN_PARAM_MAPS — together with the interface table names that stage each entity, and a flow-type flag distinguishing concurrent-program invocation from direct API invocation. Default processing values cover the item catalog key flexfield (structure number 101, KFF name MICG), the seeded attribute group type EGO_MASTER_ITEMS, and the generated functions NUMBER_GENERATION and DESC_GENERATION.

Key Procedures and Functions

  • IMPORT_ICC_INTF — the primary worker routine named in the user's search. It orchestrates the bulk import of Item Catalog Category data from the interface tables into the EGO base tables, driving the entity-level processing for headers, versions, attribute group associations, functions, and function parameter maps.
  • GET_CATALOG_GROUP_ID — resolves or derives the catalog group identifier required when associating imported ICC records with the appropriate catalog group version.
  • DELETE_PROCESSED_ICC — removes records that have already been processed from the interface tables, keeping the staging area clean and allowing repeat runs without reprocessing the same rows.
  • CONSTRUCT_COLLTN_AND_VALIDATE — builds the internal collection structures used by the validation logic and applies the entity-level validation rules before the data is written to the base tables.

Tables Accessed

Interface tables read and cleaned by the package include MTL_ITEM_CAT_GRPS_INTERFACE, EGO_ICC_VERS_INTERFACE, EGO_ATTR_GRPS_ASSOC_INTERFACE, and EGO_FUNC_PARAMS_MAP_INTERFACE, each corresponding to a defined ICC entity. Base and supporting tables include EGO_MTL_CATALOG_GRP_VERS_B for catalog group versions, EGO_ACTIONS_B, EGO_DATA_LEVEL_B, EGO_FUNC_PARAMS_B, and EGO_MAPPINGS_B for function and mapping definitions, and the flexfield usage/context extension tables EGO_FND_DF_COL_USGS_EXT and EGO_FND_DSC_FLX_CTX_EXT. Concurrency and lock control are handled through FND_CONCURRENT_REQUESTS, FND_USER, and the EGO_OBJECT_LOCK / EGO_OBJECT_LOCK_S pair, which serialize concurrent ICC load activity.

Usage Notes

Because EGO_ICC_BULKLOAD_PVT is a private package, it is not intended for direct customer invocation. It is normally reached through the ICC bulk-load concurrent program and the associated public interface APIs, which stage data in the ICC interface tables and then call this package to validate and apply it. Two other packages reference it, confirming its role as a subordinate processing unit. Custom code should not call these procedures directly; the supported path is to populate the interface tables and run the delivered concurrent process.