Results for “cz_imp_ps_node”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.CZ_IMP_PS_NODE is an Oracle E-Business Suite PL/SQL package that belongs to the Oracle Configurator (CZ) schema family and functions as part of the Configurator import infrastructure. Its primary purpose is to process staging ("IMP") records and load them into the operational Configurator model tables, specifically for PS (Product Structure / model node) definitions, localized text entries, and development project constructs. The package name embeds the import ("IMP") and the target entity ("PS_NODE"), indicating that it moves data from interface tables such as CZ_IMP_PS_NODES into the base tables CZ_PS_NODES and CZ_PS_NODES_S.

The header comment, sourcing czipsns.pls version 120.1 (shipped 2006/06/29), confirms the package is a long-standing component of the Configurator data model, present from early 11i releases and carried forward unchanged into 12.1.1 and 12.2.2. ETRM classifies it as API classification OTHER, meaning it is not a formally published end-user API but an internal utility invoked by the Configurator import framework.

Key Procedures and Functions

The package documents fifteen procedures, grouped into repeating "PS_NODE", "INTL_TEXT", and "DEVL_PROJECT" families that each follow a common run pattern:

• KRS_PS_NODE – Key/relationship selection phase for product-structure nodes; identifies which staged rows are valid for processing within a run.
• CND_PS_NODE – Conditional/CND phase; validates staged node data and increments the FAILED counter for rejected rows.
• MAIN_PS_NODE – Main processing engine that inserts or updates CZ_PS_NODES records, tracking INSERTS, UPDATES, FAILED, and DUPS counters.
• XFR_PS_NODE – Transfer phase that moves committed node data between staging and target tables within a transfer group.
• RPT_PS_NODE – Reporting procedure producing the outcome summary for a given RUN_ID.
• KRS_INTL_TEXT, CND_INTL_TEXT, MAIN_INTL_TEXT, XFR_INTL_TEXT, RPT_INTL_TEXT – Parallel phases for localized text import, loading into CZ_LOCALIZED_TEXTS and CZ_INTL_TEXTS_S.
• KRS_DEVL_PROJECT, CND_DEVL_PROJECT, MAIN_DEVL_PROJECT, XFR_DEVL_PROJECT, RPT_DEVL_PROJECT – Parallel phases for development project import into CZ_DEVL_PROJECTS from CZ_IMP_DEVL_PROJECT.

All processing procedures share a consistent parameter convention (RUN_ID, COMMIT_SIZE, MAX_ERR, in/out counters, and inXFR_GROUP), reflecting the standard Configurator bulk-import signature.

Tables Accessed

Through APPS synonyms the package reads and writes: CZ_IMP_PS_NODES and CZ_IMP_DEVL_PROJECT as staging sources; CZ_PS_NODES, CZ_PS_NODES_S, CZ_DEVL_PROJECTS, CZ_LOCALIZED_TEXTS, CZ_INTL_TEXTS_S, and CZ_ITEM_MASTERS as targets and lookups; CZ_IMP_ITEM_PROPERTY_VALUE, CZ_IMP_LOCALIZED_TEXTS, CZ_MODEL_REF_EXPLS, CZ_RP_ENTRIES, CZ_RULES, CZ_RULE_FOLDERS, and CZ_DB_SETTINGS as supporting configuration and reference data.

Usage Notes

CZ_IMP_PS_NODE is invoked by the Configurator concurrent import programs and by four other packages that reference it. Administration typically runs the Configurator import concurrent request, which automatically calls the KRS, CND, MAIN, XFR, and RPT phases in sequence for each entity family. The "node -po" search term reflects the node/relationship processing relevant to model structure loading. Direct custom invocation is possible but unsupported, as the package is classified OTHER and is not exposed through forms.