Search Results ego_upload_pub




Overview
Explore in AI Chat

Overview

APPS.EGO_UPLOAD_PUB is a public PL/SQL API package within the Oracle E-Business Suite that supports the programmatic creation and synchronization of catalog structure metadata used by Oracle Product Information Management (PIM) and the EGO (Engineering/Product Hub) schema. Its documented role is to provide a stable, callable interface for loading catalog groups, attribute group associations, item page definitions, and page entries into the EGO data model. The package header carries a header comment indicating ship status, reflecting its classification as a public API intended for supported external invocation rather than internal-only use.

The procedures in this package allow integrators and administrators to define the presentation and organizational hierarchy of catalog data without directly manipulating the underlying EGO tables. This is significant because the EGO catalog framework governs how items are categorized, displayed, and navigated in the Product Workbench and related UI flows. By exposing synchronization procedures, the package enables bulk or scripted maintenance of catalog structures that would otherwise require manual UI configuration.

Key Procedures and Functions

  • SYNC_CATALOG_GROUP — Creates or synchronizes a catalog group, including its parent, description, template, creation-allowed setting, end date, and owner, returning the catalog group identifier and standard API status outputs.
  • SYNC_CAT_ATTR_GRP_ASSOC — Establishes or updates the association between a catalog group and an attribute group, specifying data level, attribute group name and type, and an enabled flag, returning the association identifier.
  • SYNC_CAT_ITEM_PAGES — Defines or synchronizes item pages within a catalog group, capturing the internal page name, display name, description, and sequence, and returning the page identifier. This is the procedure associated with the user search term "sync_cat_item_pages".
  • SYNC_CAT_ITEM_PAGE_ENTRIES — Associates attribute groups with a specific item page, ordering them by sequence and linking via the association identifier and page internal name.
  • CREATEBASEATTRIBUTEPAGES — Documented as a supporting procedure for establishing baseline attribute page structures within the catalog framework.

Tables Accessed

The package operates against several EGO and inventory tables through APPS synonyms. EGO_PAGES_B and EGO_PAGE_ENTRIES_B store the page and page-entry definitions written by the synchronization procedures. EGO_OBJ_AG_ASSOCS_B holds the object-to-attribute-group associations. MTL_ITEM_CATALOG_GROUPS_B stores catalog group records. FND_OBJECTS and EGO_FND_DSC_FLX_CTX_EXT support object registration and descriptive flexfield context extension. PLITBLM is referenced for PL/SQL table handling. These reads and writes collectively persist the catalog hierarchy and presentation metadata.

Usage Notes

EGO_UPLOAD_PUB is typically invoked from concurrent programs, custom PL/SQL loaders, or integration scripts that provision catalog structures in bulk. Because the package is classified as PUB, it may also be called from forms or other public APIs. Callers should supply a valid API version, manage the commit flag appropriately, and inspect the return status, message count, and message data outputs. The package is referenced by at least one other package, indicating reuse within the EGO framework. Direct DML against the underlying tables should be avoided in favor of these documented synchronization entry points.