Search Results ra_customers_interface




Overview
Explore in AI Chat

Overview

ARP_CINT is a private helper package in the Oracle Receivables module of Oracle E-Business Suite. Its name reflects its purpose: Customer INTerface processing. The package body provides the low-level logic used to validate and enrich customer and customer address data staged in the RA_CUSTOMERS_INTERFACE table before that data is promoted into the base customer tables. The header comment (ARPLCINB.pls, version 120.2, last modified 2005/10/30) indicates the package has been stable across the 11i and R12 code lines, including EBS 12.1.1 and 12.2.2.

A central responsibility of the package is derivation of the location accounting flexfield (code combination ID) for customer addresses. In EBS, each customer site must be associated with a valid GL code combination for the receivables location flexfield. ARP_CINT isolates that derivation into a reusable routine so that concurrent customer import programs do not duplicate the logic.

Key Procedures and Functions

The ETRM metadata documents two program units within the package body:

  • UP_CUST_INT — The primary update routine that processes rows staged in RA_CUSTOMERS_INTERFACE. It evaluates pending interface rows (those with a null interface_status) for a given request_id and applies validation and enrichment prior to the records being imported into the customer tables. This is the main workhorse invoked during a customer interface run.
  • CINT_GEN_LOC_CCID — Generates or derives the location code combination identifier (ccid) required for a customer address site. The private variable loc_ccid and the ccid_error1 exception (associated with Oracle error -20000) in the body are consistent with this routine raising a controlled error when a valid code combination cannot be determined.

Tables Accessed

Two tables are referenced by the package, both through APPS synonyms:

  • RA_CUSTOMERS_INTERFACE — the customer interface staging table. The declared private cursor val_address_segs selects address-related columns (country, city, state, county, province, postal_code, address_attribute1 through address_attribute10) from this table. The cursor filters on interface_status IS NULL, a non-null orig_system_address_ref, and the supplied request_id, and joins to system parameters on country. A correlated subquery on ROWID restricts processing to a single row per originating address reference, and a site_use_code clause was added to resolve Bug 235747.
  • AR_SYSTEM_PARAMETERS — supplies the default_country value used to qualify which staged address rows are eligible for validation. This ensures only addresses matching the operating unit's default country are processed by the cursor.

Usage Notes

ARP_CINT is an internal (private) package. It is not intended for direct invocation by end users or custom code and does not appear in the ETRM "referenced by" list, meaning no other documented package depends on it directly. It is invoked in practice by the seeded Customer Interface concurrent program and the underlying customer import APIs that drive RA_CUSTOMERS_INTERFACE processing. Because the package relies on a request_id passed at runtime, execution is always scoped to a specific concurrent request.

Customers migrating to 12.1.1 or 12.2.2 should treat ARP_CINT as Oracle-owned and non-customizable. Any customization of customer import behavior should be performed through supported hooks or post-import concurrent programs rather than by modifying this package body, which would be overwritten by patching.