Search Results delete_acct

Overview

ARP_BILLS_RECEIVABLE_MAIN is a PL/SQL package owned by the APPS schema that serves as the Accounting Entry (AE) derivation method for accounting events associated with the receivable applications layer for Receipts and Credit Memos in Oracle Receivables. It participates directly in the Subledger Accounting architecture of Oracle E-Business Suite, providing the single entry point through which receipt application and credit memo accounting events are transformed into accounting entry lines. The package is classified as an OTHER API in the ETRM metadata and is positioned at the applications layer, meaning it derives the accounting treatment for how receipts are applied against transactions rather than for receipts or invoices in isolation.

Key Procedures and Functions

The ETRM metadata documents two procedures for this package:

• EXECUTE — The documented AE derivation method for all accounting events associated with the receivable applications layer for Receipts and Credit Memos. According to the source header, it acts as a single entry point for easy extensibility and performs a defined sequence of work: reading event data, reading transaction and setup data, determining which AE lines are affected, deriving the AE lines, and returning those lines in a PL/SQL table along with a creation status. The documented parameters include a mode indicator (document or accounting event mode), a document record, an event record, an output AE lines table, and an output AE lines creation status.
• DELETE_ACCT — Documented as the second procedure in the package. Its documented presence indicates that the package supports removal of previously derived accounting entries for the receivable applications layer, allowing accounting generated for a receipt or credit memo application event to be reversed or cleared when the underlying event is no longer valid for accounting.

Tables Accessed

The package references the following tables through APPS synonyms, reflecting its role in reading receivable application data and writing derived accounting distributions:

• AR_ADJUSTMENTS — Read for adjustment activity related to receivables, including credit memo and adjustment treatment affecting the application event.
• AR_DISTRIBUTIONS — The principal accounting distributions table; derived AE lines are persisted and deleted here.
• AR_PAYMENT_SCHEDULES — Provides installment and payment schedule context for the transaction being applied.
• AR_RECEIVABLE_APPLICATIONS — The core source of application activity linking receipts, credit memos, and adjustments to transactions.
• AR_TRANSACTION_HISTORY — Supplies audit and status history for the transaction.
• RA_CUSTOMER_TRX and RA_CUSTOMER_TRX_LINES — Supply the transaction header and line detail that drive the accounting derivation.
• RA_CUST_TRX_LINE_GL_DIST — Provides line-level general ledger distribution information for the transaction.
• DUAL — Used for single-row PL/SQL evaluation and control-flow logic.
• PLITBLM — The PL/SQL table maintenance utility used to manipulate the AE lines table returned by EXECUTE.

Usage Notes

The package is invoked through the standard Accounting Entry derivation mechanism rather than directly by end users. In Oracle EBS 12.1.1 and 12.2.2, receipt and credit memo application events flow into the derivation engine, which calls ARP_BILLS_RECEIVABLE_MAIN.EXECUTE to build the corresponding accounting lines. DELETE_ACCT is used to remove those lines when the event is unwound or corrected. Because the ETRM metadata records only one referencing package and documents two procedures, customizations should avoid calling EXECUTE directly and instead rely on the supported derivation framework. Any customer extension of accounting logic for receipt applications should be implemented as a separate derivation method registered against the same events, preserving the delivered behavior of this package.