Search Results p_amount1

Overview

The APPS.ARP_PROCESS_DEBIT_MEMO package body provides specialized sub-ledger processing logic that supports debit memo reversals within Oracle Receivables. The package is classified as an OTHER API in the ETRM metadata for Oracle EBS 12.2.2 and, by extension, applies to the 12.1.1 code line. Its principal responsibility is the creation of accounting distribution records for debit memo reversal transactions, ensuring that the two distinct code combination and amount pairs associated with a reversal are written to the receivables distribution table with the correct general ledger account assignments.

The package addresses a known defect related to percentage-based allocation. As recorded in the modification history, a divide-by-zero condition occurred when the underlying receipt amount was zero. Corrective logic was introduced so that the percentage factor resolves to 100 when the amount is zero, preventing the Ora-1476 error referenced in bug 2061395. This makes the package a small but important component of the receivables accounting engine.

Key Procedures and Functions

The ETRM metadata documents a single public procedure within this package body: LINE_POST_INSERT. Its stated purpose is to execute line post-insert logic for debit memo reversals. Specifically, it creates two distribution records corresponding to the two ccid and amount pairs supplied by the caller.

Because the metadata explicitly prohibits inferring parameter lists, the parameters should be understood only by their documented roles rather than by inventing signatures. The procedure is described as accepting a customer transaction line identifier together with two code combination identifiers and two corresponding amounts, which together represent the paired distribution legs of the reversal. The procedure is scoped as PUBLIC. Its only documented external dependency is arp_util.debug, which is used for diagnostic tracing. The procedure returns no value.

Tables Accessed

Four tables are accessed through APPS synonyms:

• RA_CUSTOMER_TRX_LINES — the transaction line source, read to derive the extended amount and line context required for distribution generation.
• RA_CUST_TRX_LINE_GL_DIST — the receivables line distribution table, into which the two new distribution records are inserted; this is the principal write target of the procedure.
• RA_CUSTOMER_TRX — the transaction header table, accessed to retrieve exchange rate information needed for currency-correct distribution amounts.
• GL_CODE_COMBINATIONS — the general ledger account validation and reference table, used to confirm the two code combination identifiers passed by the caller.

Usage Notes

The metadata records that this package is referenced by one other package, indicating it functions as a supporting routine rather than an entry point invoked directly by users. Its naming and the referenced source header (ARTEDBMB.pls) associate it with the AutoInvoice and Receivables transaction processing domain.

In practice, LINE_POST_INSERT is invoked during the accounting distribution phase of debit memo reversal processing, typically after the reversal transaction lines have been established. Because it is not a documented standalone API with a published signature set, custom code should not call it directly; instead, it should be reached through the standard Receivables transaction and reversal workflows that own its calling package. When investigating the p_amount2 parameter, note that it represents the second amount leg of the paired distribution and works in tandem with p_amount1 to balance the reversal accounting entries.