Search Results arp_process_credit




Overview
Explore in AI Chat

Overview

The APPS.ARP_PROCESS_CREDIT package is a core AutoInvoice processing package within Oracle Receivables, responsible for the creation and maintenance of credit memo transaction records during the AutoInvoice import cycle. When AutoInvoice processes interface data originating from external feeder systems, order management, or other modules, credit memos and on-account credits must be validated and written into the Receivables transaction schema. This package encapsulates that persistence logic, handling header-level and line-level inserts and updates against the RA_CUSTOMER_TRX and RA_CUSTOMER_TRX_LINES tables, applying currency conversion context from FND_CURRENCIES, resolving transaction types, and distributing accounting flexfield amounts to the lines' general ledger distributions.

The package is registered in ETRM as VALID under the APPS schema and is classified as an internal "OTHER" API rather than a public open interface. As such, it is not intended for direct invocation by external integrations; it forms part of the internal processing engine invoked by AutoInvoice's master driver logic. The package is tightly coupled to the credit memo workflow and complements packages such as ARP_PROCESS_FREIGHT and the coverage packages ARP_PROCESS_CREDIT_INS_COVER and ARP_PROCESS_CREDIT_UPD_COVER, which were generated to provide instrumentation and code-coverage verification over the insert and update paths respectively.

Key Procedures and Functions

The documented interface of the package exposes six procedures, each addressing a distinct stage of credit processing:

  • INSERT_HEADER — Creates the credit memo header record in the Receivables transaction tables, establishing the transaction identity, currency, transaction type, and customer linkage required before line processing can proceed.
  • UPDATE_HEADER — Applies corrections or enrichment to an existing credit memo header, typically used when AutoInvoice re-processes or adjusts a previously created credit.
  • INSERT_LINE — Inserts individual credit memo lines, associating each line with its parent transaction and populating the line-level accounting distribution rows in the GL distribution table.
  • UPDATE_LINE — Modifies existing credit memo lines to reflect amended quantities, amounts, or accounting attributes flagged during validation.
  • FREIGHT_POST_UPDATE — Performs post-processing adjustments to freight-related amounts on credit memos after the primary line records have been written, ensuring freight charges are correctly reflected in the credit.
  • INIT — Initializes the package session state, establishing the working variables and context needed by the subsequent header and line procedures.

Tables Accessed

The package operates against a defined set of Receivables and shared tables. RA_CUSTOMER_TRX and RA_CUSTOMER_TRX_LINES hold the credit memo header and line records. RA_CUST_TRX_LINE_GL_DIST receives the accounting distributions generated for each line. RA_CUST_TRX_TYPES provides the transaction type definition that governs credit memo behavior, while RA_CUST_TRX_LINE_SALESREPS and RA_SALESREPS supply salesperson assignment and commission context. AR_MEMO_LINES supports memo-line reconciliation, and FND_CURRENCIES supplies currency precision and conversion attributes. Additional documented references include AR_ADJUSTMENTS, AR_PAYMENT_SCHEDULES, AR_SYSTEM_PARAMETERS, and the Subledger Accounting tables XLA_EVENTS and XLA_TRANSACTION_ENTITIES_UPG, indicating that the package also participates in the creation of accounting events for the created credits. The dependency listing confirms direct references to AR_MEMO_LINES, FND_CURRENCIES, RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_LINES, RA_CUST_TRX_LINE_GL_DIST, RA_CUST_TRX_TYPES, and RA_SALESREPS.

Usage Notes

ARP_PROCESS_CREDIT is an internal engine package and should not be called directly from custom code or concurrent program registrations. It is referenced by ARP_CACHE_UTIL, ARP_PROCESS_CREDIT itself (recursive internal calls), the coverage packages ARP_PROCESS_CREDIT_INS_COVER and ARP_PROCESS_CREDIT_UPD_COVER, and ARP_PROCESS_FREIGHT, with five dependent packages in total.

In EBS 12.1.1 and 12.2.2 the package is invoked implicitly during AutoInvoice execution whenever a credit memo or on-account credit transaction is imported. Functional users trigger this work through the AutoInvoice Master Program and its associated validation and import programs. Because the package writes directly to core Receivables tables, any customization should target the AutoInvoice interface tables (RA_INTERFACE_LINES_ALL and related interface tables) rather than attempting to bypass the engine. The presence of XLA references confirms that in R12 the package participates in Subledger Accounting event creation, so integrators should expect corresponding accounting entries to be generated as a by-product of credit processing.