Search Results arh_arxcudci_pkg




Overview
Explore in AI Chat

Overview

ARH_ARXCUDCI_PKG is a Receivables package in the Oracle E-Business Suite Applications (APPS) schema that supports customer data conversion and initialization. The name follows the AR (Receivables) and CUDCI (customer data conversion/interface) naming convention used throughout the ARH family of customer-related database objects. The package exposes a single documented program unit, INITIALIZE, which is used to retrieve and return the system-level customer setup defaults that govern how customer records are created, validated, numbered, and grouped.

The package header was last modified under the $Header$ tag ARHSTDS.pls 120.2 (June 2005), confirming it as a long-standing component of the Oracle Receivables data model that has remained stable across the 12.1.1 and 12.2.2 releases. Its API classification is documented as OTHER, meaning it is an internal helper rather than a published open interface or public API.

Key Procedures and Functions

The ETRM metadata documents exactly one program unit:

  • INITIALIZE — Returns a set of customer-related system option values to the calling program. The header declares the parameters as IN OUT NOCOPY, indicating the procedure receives a working set of variables and populates or refreshes them with the current Oracle Receivables system parameter values. The variables cover customer type, tax printing option, grouping rule, reciprocal customer creation, automatic customer and site numbering, profile class, allow change of customer name, customer keys usage, service organization, address validation, location structure, postal code range, home and default country codes and display, address style, and functional currency. The procedure does not perform validation or commit; it is purely an initialization/retrieval step that primes a conversion or interface routine with the configured environment.

No other procedures or functions are documented for this package. Callers should not assume the existence of additional public entry points beyond those declared in the package header.

Tables Accessed

The package references the following tables through APPS synonyms, which are the logical sources for the INITIALIZE values:

  • AR_SYSTEM_PARAMETERS — The primary source of the initialization values. It holds the Receivables system options such as customer type, tax printing option, automatic customer and site numbering, allow change of customer name, and functional currency.
  • HZ_CUST_PROFILE_CLASSES — Supplies the default customer profile class and related profile-class configuration used when creating customer records.
  • RA_GROUPING_RULES — Provides the grouping rule definitions applied when grouping transactions or customer data during conversion and processing.

These tables are read to populate the IN OUT parameters; the package is not documented as writing to them.

Usage Notes

ARH_ARXCUDCI_PKG is typically invoked from within Oracle Receivables customer conversion and data-loading routines that need the current system-level defaults before creating customer, address, or site records. Because it references AR_SYSTEM_PARAMETERS and profile-class and grouping-rule setup tables, it is generally called after Receivables system options have been configured and before customer records are inserted or validated. It is not a user-facing API and is not exposed through a form or concurrent program directly; instead it is called internally by the ARH customer conversion code that consumes its returned values.

The package is referenced by zero other packages in the documented metadata, indicating it is a leaf dependency that depends on the three setup tables but is not itself a shared utility. When invoking it from custom code, callers must supply and initialize all IN OUT variables, since the NOCOPY semantics mean the procedure may modify the actual parameters in place without copying. Because the package is classified OTHER rather than PUBLIC, its interface should be treated as internal and subject to change without notice across patches and release upgrades.