Search Results ar_cons_inv_trx_lines

Overview

ARP_CONSINV is a PL/SQL package body owned by the APPS schema that supports Oracle Receivables' consolidated invoicing and consolidated billing functionality. Consolidated invoicing allows an enterprise to combine multiple transactions belonging to the same customer or bill-to grouping into a single, summarized customer invoice rather than issuing individual invoices. The ARP_CONSINV package encapsulates the server-side logic that identifies candidate transactions, groups them according to consolidation rules, generates the consolidated transaction lines, and manages the relationship between the consolidated invoice and the underlying detail transactions. In Oracle EBS 12.1.1 and 12.2.2, this package operates within the Receivables transaction model, interacting with the customer transaction, consolidated invoice, and payment schedule tables that form the backbone of the AR subsystem.

Key Procedures and Functions

The documented ETRM metadata identifies a single classified procedure, REPORT. Consistent with the naming and the package's dependency on the consolidated invoice tables (AR_CONS_INV, AR_CONS_INV_TRX, AR_CONS_INV_TRX_LINES), REPORT drives the consolidated invoice processing and reporting logic, evaluating the pending consolidation records and producing the output used to build or refresh consolidated transactions. Because the package body is classified as OTHER rather than as a public API, its procedures are not intended as a formally supported integration surface; they implement internal processing invoked by the consolidation workflow. The metadata documents only this procedure explicitly, and no parameter lists are published.

Tables Accessed

ARP_CONSINV references a broad set of Receivables and Trading Community tables through APPS synonyms. The consolidated invoice structure is represented by AR_CONS_INV, AR_CONS_INV_ALL, and AR_CONS_INV_S, which hold the consolidation header and its translation and sequence data. AR_CONS_INV_TRX and AR_CONS_INV_TRX_LINES store the mapping between a consolidated invoice and its constituent detail transactions, and the transaction line detail itself. Transaction data is drawn from RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_LINES, and RA_CUSTOMER_TRX_LINES_ALL. Financial impact is derived from AR_PAYMENT_SCHEDULES, AR_RECEIVABLE_APPLICATIONS, AR_ADJUSTMENTS, and AR_CASH_RECEIPTS, which together describe installments, application activity, adjustments, and receipts affecting the source transactions.

Customer and site context is resolved through HZ_CUSTOMER_PROFILES, HZ_CUST_ACCT_SITES, and HZ_CUST_SITE_USES, while payment terms for the consolidated output are read from RA_TERMS and RA_TERMS_LINES. Control behavior is governed by AR_SYSTEM_PARAMETERS, and utility logic is provided by ARP_ETAX_UTIL, ARP_GLOBAL, and ARP_STANDARD. The package also relies on the PUBLIC synonym DUAL, PLITBLM, and the SYS-owned DBMS_STANDARD and STANDARD packages.

Usage Notes

ARP_CONSINV is not referenced by any other database object and is not exposed as a documented public API, which indicates it is invoked internally by Receivables consolidation processes rather than called directly by customer extensions. It is typically reached through the Consolidated Billing Invoice workflow and the related concurrent programs and forms that manage consolidated invoicing, where user-entered selection and grouping criteria are persisted to the AR_CONS_INV family of tables and subsequently processed. Because the search term ar_cons_inv_trx_lines corresponds to the transaction line detail table populated through this logic, developers investigating consolidation data should expect ARP_CONSINV to be the primary writer of AR_CONS_INV_TRX and AR_CONS_INV_TRX_LINES. Custom code should avoid direct invocation of its procedures; instead, integrate through supported Receivables APIs and rely on ARP_CONSINV only for understanding how consolidated invoice records are constructed and maintained.