Search Results cz_imp_ac_main




Overview
Explore in AI Chat

Overview

APPS.CZ_IMP_AC_MAIN is a valid PL/SQL package body in the Oracle E-Business Suite APPS schema, belonging to the Oracle ETRM (Enterprise Territory and Resource Management) / Trade Management family of components. Its role is to orchestrate the import and processing of account-related master data — customers, contacts, addresses, address uses, end users, end user groups, and user groups — between the staging tables prefixed CZ_IMP_ and the corresponding ETRM transactional structures. The package is classified under the generic API category OTHER, indicating that it is a supporting internal engine rather than a formally published public API.

The naming convention reveals the internal layering: the CND_ prefixed units apply conditions or validations, the MAIN_ prefixed units perform the principal import / load logic for each entity, and the RPT_ prefixed units handle reporting or reconciliation output. The single entry point pattern and the presence of run-control tables (CZ_XFR_RUN_INFOS and CZ_XFR_RUN_RESULTS) confirm that the package is driven by a transfer-run framework in which each execution is tracked and its outcome recorded.

Key Procedures and Functions

The ETRM metadata documents 24 procedures and functions. These are grouped logically as follows:

In addition to the CND_, MAIN_, and RPT_ units, the package exposes dependency on sibling packages CZ_IMP_AC_KRS and CZ_IMP_AC_XFR, which together form the import/transfer pipeline. No parameter lists are documented in the ETRM metadata; the procedures are therefore described by purpose only.

Tables Accessed

The package reads and writes the following documented tables (accessed through APPS synonyms):

Staging tables hold the incoming data; run tables provide the audit and reconciliation context that the RPT_ procedures report against.

Usage Notes

CZ_IMP_AC_MAIN is typically invoked by a concurrent program or by the parent transfer-run framework that populates CZ_XFR_RUN_INFOS for the run and consumes CZ_XFR_RUN_RESULTS after completion. It is called from within the ETRM import pipeline alongside CZ_IMP_AC_KRS and CZ_IMP_AC_XFR rather than directly by end users. The package is not referenced by any other database object in the ETRM dependency map, indicating it functions as a terminal driver in the account-import chain. Because the procedures are internal, direct invocation is normally restricted to supported ETRM import flows; custom code should call the supported ETRM import APIs rather than the CND_, MAIN_, or RPT_ units directly. The package is valid in both Oracle EBS 12.1.1 and 12.2.2.