Search Results process_attribute_group




Overview
Explore in AI Chat

Overview

EGO_METADATA_PUB is a public PL/SQL package in the APPS schema that supports the Oracle E-Business Suite Product Information Management (PIM) and EGO (Enterprise Data Governance / extensibility) infrastructure. Its core business function is to process the interface (staging) tables used to bulk-load and synchronize metadata definitions — attribute groups, attributes, pages, page entries, flex values, functions, and related configuration constructs — into the EGO repository. These metadata definitions drive the configurable item attributes, extensible flexfields, and page layouts that appear in the Oracle EBS user interface, particularly for inventory items, catalogs, and transactional attributes. The package acts as the processing engine behind the import and synchronization of EGO interface tables, validating and moving staged data into the live metadata structures. It is classified as a PUBLIC API (PUB), meaning it is intended for supported external invocation and not solely for internal use. In both 12.1.1 and 12.2.2, the object is documented as VALID, and it is referenced by six other database objects, indicating its role as a foundational dependency within the EGO metadata layer.

Key Procedures and Functions

The ETRM metadata documents four procedures in this package body. No parameter lists are published, so only their purposes are described:

  • PROCESS_ATTRIBUTE_GROUP — Processes staged attribute group definitions from the interface tables, handling the creation or update of attribute groups and their associations in the EGO repository.
  • PROCESS_ATTRIBUTE — Processes individual attribute definitions and attribute-group column mappings, loading validated metadata into the target EGO attribute structures.
  • PROCESS_PAGES — Processes page-level metadata, loading page definitions from the EGO pages interface into the application's configurable page model.
  • PROCESS_PG_ENTRIES — Processes page entry records, governing the individual fields or items that appear within a defined page layout.

Tables Accessed

The package references EGO and inventory interface tables through APPS synonyms. These include EGO_ATTR_GROUPS_DL_INTERFACE, EGO_ATTR_GROUPS_INTERFACE, EGO_ATTR_GROUP_COLS_INTF, and EGO_ATTR_GRPS_ASSOC_INTERFACE for attribute group, column, and association staging; EGO_FLEX_VALUE_INTF, EGO_FLEX_VALUE_SET_INTF, and EGO_FLEX_VALUE_TL_INTF for flexfield value and value set loads; EGO_FUNCTIONS_INTERFACE, EGO_FUNC_PARAMS_INTERFACE, and EGO_FUNC_PARAMS_MAP_INTERFACE for function and parameter metadata; EGO_ICC_VERS_INTERFACE and EGO_TRANS_ATTRS_VERS_INTF for version-related item catalog and transactional attribute data; EGO_PAGES_INTERFACE and EGO_PAGE_ENTRIES_INTERFACE for page and page entry loads; and MTL_ITEM_CAT_GRPS_INTERFACE for item category group staging. The package reads staged rows from these interface tables, validates them, and writes the resulting definitions into the live EGO metadata tables (the target structures implied by the interface naming conventions).

Usage Notes

EGO_METADATA_PUB is typically invoked during metadata import and setup synchronization, often from concurrent programs or background processing that consume the EGO interface tables. In a 12.1.1 or 12.2.2 environment, it may be called directly from custom PL/SQL when bulk-loading extensible attribute or page metadata, or indirectly by oracle-provided loaders. Because the package is classified as PUB and is referenced by six other objects, integrators can rely on it as a supported entry point, but they should populate the corresponding interface tables with validated data before calling the PROCESS_* procedures. Direct invocation should follow the same sequencing the standard loaders use, since the procedures assume prerequisite interface records (such as attribute groups before attributes) are already staged.