Search Results ra_interface_distributions




Overview
Explore in AI Chat

Overview

ARP_EBS_AUTOINV_PREPROC is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Releases 12.1.1 and 12.2.2. It supports the AutoInvoice processing flow within Oracle Receivables by performing pre-processing adjustments on interface data before the standard AutoInvoice engine transfers records into the production transaction tables. The package is classified under the ETRM metadata with an API classification of OTHER, indicating that it is not exposed as a public, supported API but rather functions as an internal utility invoked within the AutoInvoice pipeline.

The primary business concern addressed by this package is the treatment of European Monetary Union (EMU) legacy currencies. Prior to the full transition to the euro, certain currencies maintained fixed conversion relationships that had to be applied consistently across interface distributions and sales credits. ARP_EBS_AUTOINV_PREPROC identifies interface lines denominated in these EMU currencies, applies the fixed-rate conversion into the functional currency, and flags affected credit memos with error messages where the transaction date exceeds the currency's active end date.

Key Procedures and Functions

The package exposes a single documented procedure, UPDATE_TRX. It accepts a request identifier, a functional currency code, and an IN OUT error code parameter, and drives the entire preprocessing routine. Internally, UPDATE_TRX performs three coordinated operations:

  • Identification of distinct EMU currency codes present in the interface lines for a given request, together with each currency's active end date, using a cursor joined against FND_CURRENCIES filtered on derive_type equal to 'EMU'.
  • Insertion of error records into RA_INTERFACE_ERRORS for credit memos whose transaction date falls after the EMU currency's end date, using the seeded message string fetched via FND_MESSAGE.GET_STRING with the token AR_RAXTRX_CONV_CM.
  • Conversion of amounts on RA_INTERFACE_DISTRIBUTIONS and sales credit split amounts on RA_INTERFACE_SALESCREDITS to the functional currency using GL_CURRENCY_API.CONVERT_AMOUNT with the 'EMU FIXED' conversion type and SYSDATE as the effective date, and nullification of the accounted amount on the distributions rows.

Tables Accessed

The package reads and writes a defined set of Receivables and shared interface tables through APPS synonyms:

  • RA_INTERFACE_LINES_GT — the global temporary staging table queried to enumerate the currencies and interface line identifiers associated with the current request. The user's search term, "ra_interface_lines_gt", references this table directly.
  • RA_INTERFACE_LINES — the persistent interface table used to locate credit memo lines eligible for error flagging.
  • RA_INTERFACE_ERRORS — written to record conversion-related rejection messages against affected interface line IDs and org IDs.
  • RA_INTERFACE_DISTRIBUTIONS — updated in place so that distribution amounts reflect EMU fixed conversion and accounted amounts are cleared for re-derivation.
  • RA_INTERFACE_SALESCREDITS — updated so that sales credit splits reflect the converted functional currency amount.
  • FND_CURRENCIES — read to determine which currencies are flagged as EMU and to obtain their active end dates.
  • RA_CUST_TRX_TYPES — read to restrict error flagging to transaction types of class 'CM' (credit memo).

Usage Notes

ARP_EBS_AUTOINV_PREPROC is invoked automatically as part of the AutoInvoice concurrent program execution rather than being called directly from Oracle Forms or custom code. It is not referenced by any other documented package in the ETRM catalog, which confirms its role as a leaf-level preprocessor within the AutoInvoice flow. Because it operates on data staged in RA_INTERFACE_LINES_GT and related interface tables scoped by request_id, the procedure must execute within the same request context that populated those interface rows. Custom implementations that load AutoInvoice interface data directly should be aware that this package will attempt EMU fixed-rate conversions on any qualifying lines, and that errors inserted into RA_INTERFACE_ERRORS will cause the affected credit memos to be rejected during the standard validation phase.