Search Results clean_dirty_skus

Overview

APPS.EGO_IMPORT_UTIL_PVT is a private PL/SQL package within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 EGO (Product Information Management / Item Master) schema. Its documented object status is VALID, and its API classification is PVT, indicating that it is intended for internal consumption by other packages rather than as a public, customer-callable interface. The package functions as a utility and orchestration layer that supports the item import process, principally by providing the reusable logic exercised by its public sibling package, EGO_IMPORT_UTIL_PVT, and by the item open interface package EGO_ITEM_OPEN_INTERFACE_PVT.

The package is not an entry point in its own right; the ETRM dependency data confirms that both EGO_IMPORT_UTIL_PVT and EGO_ITEM_OPEN_INTERFACE_PVT reference it, and that it is referenced by five other packages in total. In practical terms, it centralizes the routine work associated with staging, validating, defaulting, and copying item and structure data prior to the import into the production item tables.

Key Procedures and Functions

The documented package exposes twenty procedures/functions. They cluster into several functional areas:

• Import preprocessing and validation: PREPROCESS_IMPORT, GET_INTERFACE_ERRORS, CHECK_FOR_DUPLICATES, VALIDATE_TIMESTAMP_IN_BATCH, and UPDATE_TIMESTAMP_IN_PROD handle staging-batch readiness, duplication detection, error retrieval, and interface timestamp management.
• Copy-option processing: PROCESS_IMPORT_COPY_OPTIONS, PROCESS_COPY_OPTIONS_FOR_UDAS, and COPY_LC_PROJECTS govern how attributes, lifecycle projects, and related entities are carried forward during import copy operations.
• Item defaulting and hierarchy propagation: PROPAGATE_ITEM_NUM_TO_CHILD, DEFAULT_ORG_ASSIGNMENTS, DEFAULT_ITEM_PEOPLE, COPY_ITEM_PEOPLE_FROM_STYLE, DEFAULT_CHILD_ENTITIES, and CLEAN_DIRTY_SKUS handle assignment of organizations, people, child entities, and the cleanup and propagation of item number data.
• Variant and SKU handling: ENABLE_DISABLE_SKU_PROCESSING and PROCESS_VARIANT_ATTRS manage SKU processing flags and variant attribute values.
• Attachments and UDA processing: COPY_ATTACHMENTS, INSERT_FUN_GEN_SETUP_UDAS, CALL_UDA_APPLY_TEMPLATE, and DO_AGLEVEL_UDA_DEFAULTING manage attachment duplication and User Defined Attribute template application and defaulting.

Tables Accessed

The package reads and writes documented interface tables via APPS synonyms, including EGO_IMPORT_BATCHES_B, EGO_IMPORT_COPY_OPTIONS, EGO_IMPORT_OPTION_SETS, EGO_ITEM_ASSOCIATIONS_INTF, EGO_AML_INTF, EGO_INBOUND_MSG_EXT, EGO_ATTR_GROUP_DL, EGO_DATA_LEVEL_B, EGO_FND_DF_COL_USGS_EXT, and EGO_FND_DSC_FLX_CTX_EXT. These support import batch tracking, copy-option resolution, and attribute group defaulting.

It also touches structure interface tables: BOM_BILL_OF_MTLS_INTERFACE, BOM_COMPONENT_OPS_INTERFACE, BOM_INVENTORY_COMPS_INTERFACE, BOM_REF_DESGS_INTERFACE, and BOM_SUB_COMPS_INTERFACE, reflecting its role in propagating bill of material and component data during item import.

Usage Notes

Because it is a PVT package, EGO_IMPORT_UTIL_PVT should not be invoked directly from customer forms, concurrent programs, or custom code. It is called by its public counterpart, EGO_IMPORT_UTIL_PVT, and by EGO_ITEM_OPEN_INTERFACE_PVT, which drive the standard item open interface and import flows. Customizations requiring import-utility behavior should be routed through the public APIs that wrap this package to remain upgrade-safe across 12.1.1 and 12.2.2.