Search Results cint_gen_loc_ccid




Overview
Explore in AI Chat

Overview

ARP_CINT is a customer interface maintenance package within the Oracle Receivables (AR) module of Oracle E-Business Suite. It resides in the APPS schema and is declared with AUTHID CURRENT_USER, meaning its unqualified object references resolve against the privileges and schema of the calling user rather than the package owner. The package supports the Customer Interface workflow, the mechanism by which customer records originating in external systems, legacy conversions, or feeder programs are loaded into the Receivables customer tables through the RA_CUSTOMERS_INTERFACE staging table. It provides low-level utility routines that update interface row status and messages and that derive location identifiers for interface records, supplementing the standard concurrent-based load process. The source header indicates a version date of October 2005 and a single shipped revision, reflecting a stable, low-change utility package carried forward into EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

  • UP_CUST_INT — This procedure updates a single row of the customer interface. Its parameters supply the warning text, the location identifier, the message text, the interface status, and the ROWID of the target interface record. It is the standard error- and status-writing routine used when a feeder program needs to record the outcome of processing a specific interface row, whether that outcome is a successful load, a warning, or a rejection with an explanatory message.
  • CINT_GEN_LOC_CCID — This procedure generates the location code combination identifier for customer interface records. Its parameters pass the concurrent request context (request ID, user ID, program application ID, program ID, last update login, application ID, and language ID), indicating that it is designed to run under a concurrent program and to derive or populate the location CCID values required before interface rows can be validated and loaded.

Tables Accessed

  • RA_CUSTOMERS_INTERFACE — The primary staging table for customer interface data. UP_CUST_INT writes status, message, and warning columns on individual rows, while CINT_GEN_LOC_CCID operates across the interface rows to populate location identifiers. This table is the central artifact of the customer import process.
  • AR_SYSTEM_PARAMETERS — The Receivables system options table. It is read to obtain setup values, such as default location or organization parameters, that govern how location identifiers are derived during interface processing.

Usage Notes

ARP_CINT is not intended for direct end-user invocation. It is called by the Receivables Customer Interface concurrent programs and by related feeder programs that populate RA_CUSTOMERS_INTERFACE before submission of the standard customer load. Custom conversion or integration code that inserts interface rows may call UP_CUST_INT to stamp processing outcomes consistently with the seeded workflow, and may invoke CINT_GEN_LOC_CCID to ensure location code combinations are generated correctly prior to load. Because the procedures accept and act on a ROWID and explicit user context values, callers are responsible for supplying correct row identifiers and session information. The package is referenced by no other documented packages, confirming its role as a leaf-level utility rather than a reusable framework component. The ETRM search token "cacte 0.5" does not correspond to any documented element of this package; the two documented routines, UP_CUST_INT and CINT_GEN_LOC_CCID, are the only supported entry points. Customizations should avoid modifying the shipped specification and should instead wrap these procedures in their own code to preserve upgrade safety.