Search Results xfr_item_type_property

Overview

APPS.CZ_IMP_IM_XFR is an Oracle EBS 12.1.1 / 12.2.2 PL/SQL package belonging to the Oracle Product Hub (formerly Oracle Product Information Management) module, as indicated by the CZ_ prefix and the IM (Item Master) naming convention. The package provides the item-master import transformation (XFR) layer that moves staging records held in the CZ_IMP_* interface tables into their corresponding production base tables in the CZ_* schema. In the standard Oracle Product Hub import architecture, data is loaded from external sources into interface tables, validated and transformed, and then transferred to the destination item tables; this package implements the transfer stage. Its five procedures correspond one-to-one with the main item-master entities: items, item property values, item types, item type properties, and properties. Each procedure is invoked against a specific run identifier and can be constrained to an import group, supporting phased or partitioned processing of large item-master loads.

Source comments indicate the package body has been in ship status since 2006 and remains present in 12.1.1 and 12.2.2 environments. It is classified under ETRM as API classification OTHER, meaning it is not part of the formally supported public API set but is documented for reference by Oracle's E-Business Technical Reference Manual.

Key Procedures and Functions

• XFR_ITEM_MASTER — Transfers item-master header records from the interface table to the production item-master table, accepting a run identifier, commit size, maximum error threshold, import group, and output counters for inserts, updates, and failures.
• XFR_ITEM_PROPERTY_VALUE — Transfers item property-value assignments, populating the item property-value destination from the corresponding interface staging table.
• XFR_ITEM_TYPE — Transfers item type definitions from the interface layer into the production item type table.
• XFR_ITEM_TYPE_PROPERTY — Transfers item type property definitions, establishing which properties are valid for which item types.
• XFR_PROPERTY — Transfers property definitions themselves. This procedure carries an additional p_rp_folder_id parameter (likely a responsibility/folder identifier) in addition to the common run, commit, error, group, and counter parameters, and is the procedure most closely associated with the xfr_property search term.

All five procedures share a common signature pattern: an input run identifier, commit size, maximum error count, import group, three OUT/IN OUT counters for inserts, updates, and failures. This uniformity allows them to be orchestrated by a single driver that advances the counters and commits in controlled batches.

Tables Accessed

The packages reads from interface (CZ_IMP_*) tables and writes to destination (CZ_*) tables:

• CZ_IMP_ITEM_MASTER / CZ_ITEM_MASTERS — source and destination for item-master records.
• CZ_IMP_ITEM_PROPERTY_VALUE / CZ_ITEM_PROPERTY_VALUES — property-value staging and production.
• CZ_IMP_ITEM_TYPE / CZ_ITEM_TYPES — item type staging and production.
• CZ_IMP_ITEM_TYPE_PROPERTY / CZ_ITEM_TYPE_PROPERTIES — type-property staging and production.
• CZ_IMP_PROPERTY / CZ_PROPERTIES — property definition staging and production.
• CZ_PS_PROP_VALS — property value associated with page/PS structures, consulted during property value transfer.
• CZ_RP_ENTRIES — repository/folder entries, referenced by XFR_PROPERTY (consistent with its p_rp_folder_id parameter).
• CZ_INTL_TEXTS_S / CZ_LOCALIZED_TEXTS / FND_LANGUAGES — translation support, used to propagate localized text for item and property descriptions across installed languages.

The constant declarations cnDefSrcAppId and cnDefSrcTypeCode (both -1) provide default source application and type codes used during transfer processing.

Usage Notes

CZ_IMP_IM_XFR is typically invoked from Oracle Product Hub import concurrent programs or from the Import Workbench after interface records have been validated. The procedures should generally be called in dependency order — properties and item types before item type properties and item property values, and item master before or alongside those — to satisfy referential requirements. Because the counters are IN OUT and passed across calls, a wrapper program commonly invokes each procedure per import group, aggregating inserts, updates, and failures. The MAX_ERR parameter enables fail-fast behavior: processing can halt once errors exceed the supplied threshold. The COMMIT_SIZE parameter controls batch commit frequency, which matters for very large item-master loads. Custom code should not call this package directly against production data without first confirming a corresponding interface load and understanding that XFR_PROPERTY additionally requires a valid repository folder identifier. Direct invocation outside the standard import flow risks referential inconsistencies in the destination CZ_* tables.