Search Results main_address_uses

Overview

APPS.CZ_IMP_AC_MAIN is a PL/SQL package in Oracle E-Business Suite Release 12.1.1 and 12.2.2 that belongs to the customer data import infrastructure of the Oracle Customer Relationship Management and Trading Community Architecture (TCA) product family. The package name encodes its role: "CZ" denotes the customer data conversion layer used by Oracle's legacy import utilities, "IMP" indicates import processing, and "AC" refers to the Account/Address conversion routines. This package coordinates the bulk loading, validation, and reconciliation of customer master data — contacts, customers, addresses, address uses, end users, and end-user groups — into the TCA model.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer, which is standard practice for EBS packages that must respect invoker-rights security during multi-organization imports. The header comment ($Header: cziacmns.pls 115.15) reflects a maintenance lineage dating to December 2002, indicating this is a long-standing, stabilized routine rather than new development.

Within the Oracle EBS architecture, CZ_IMP_AC_MAIN serves as a transaction controller for bulk customer imports. It is not an end-user form component; rather, it is invoked by the higher-level import driver and by concurrent programs that process staging records into live TCA entities. Its primary business function is to guarantee that imported interface data is validated, transformed, and inserted or updated in a controlled, restartable manner while capturing error and duplication statistics.

Key Procedures and Functions

The package exposes 24 documented procedures, organized into three logical families. The CND_* procedures — CND_CONTACT, CND_CUSTOMER, CND_ADDRESS, CND_ADDRESS_USES, CND_CUSTOMER_END_USER, CND_END_USER, CND_END_USER_GROUP, and CND_USER_GROUP — perform the conditioning and validation stage. Each accepts an interface run identifier, a commit size, and a maximum error threshold, and returns a failed-record count. These routines parse and validate staged rows before any data is written to TCA.

The MAIN_* procedures — MAIN_CONTACT, MAIN_CUSTOMER, MAIN_ADDRESS, MAIN_ADDRESS_USES, MAIN_CUSTOMER_END_USER, MAIN_END_USER, MAIN_END_USER_GROUP, and MAIN_USER_GROUP — constitute the core processing stage. In addition to the run identifier, commit size, and error threshold, they return insert, update, failure, and duplicate counts, and accept an XFR_GROUP parameter that scopes processing to a specific transfer group. These procedures write the validated data to the destination tables.

The RPT_* procedures — RPT_CONTACT, RPT_CUSTOMER, RPT_ADDRESS, and RPT_ADDRESS_USES — generate reporting output over the processed records, providing reconciliation statistics for each entity type.

Tables Accessed

The package references ten tables through APPS synonyms. The staging/interface tables CZ_IMP_ADDRESS, CZ_IMP_ADDRESS_USE, CZ_IMP_CONTACT, CZ_IMP_CUSTOMER, CZ_IMP_CUSTOMER_END_USER, CZ_IMP_END_USER, CZ_IMP_END_USER_GROUP, and CZ_IMP_USER_GROUP hold the raw imported data prior to transformation. The control tables CZ_XFR_RUN_INFOS and CZ_XFR_RUN_RESULTS record run-level metadata and outcome statistics, enabling restartability and audit of each import batch.

Usage Notes

CZ_IMP_AC_MAIN is typically invoked from a concurrent program or a parent PL/SQL driver that supplies the run identifier and commit sizing parameters. Administrators and technical consultants use it during customer data migration and periodic TCA refreshes. It is referenced by one other package, which orchestrates the sequencing of conditioning, main processing, and reporting phases. Because it relies on invoker rights, the calling user must possess appropriate privileges on the CZ_IMP and CZ_XFR objects.