Search Results ar_cons_inv_trx




Overview
Explore in AI Chat

Overview

ARP_BF_BILL is a private PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It supports the consolidated billing feature set within Oracle Receivables, specifically the creation and reprinting of consolidated billing invoices generated by the ARXCBI concurrent report. The package is classified as "OTHER" under standard API categorization, meaning it is not a public transactional API but an internal utility leveraged by Receivables billing engine components.

The package body defines several PL/SQL index-by tables used to hold transactional override data during processing, including collections keyed to customer_trx_id, term_id, billing_date, and term_due_date sourced from RA_CUSTOMER_TRX. It also exposes a debug and logging helper, write_debug_and_log, which writes messages to the concurrent manager log file when a concurrent request ID is present and delegates additional tracing to arp_standard.debug.

Key Procedures and Functions

The ETRM metadata documents three report-oriented procedures/functions within this package. The header excerpt explicitly reveals the following:

  • reprint — Updates consolidated billing invoice rows, or rows tied to a specified concurrent request, so their print status is set to 'PENDING'. This enables the ARXCBI report to reprint previously generated consolidated billing invoices. Its arguments are documented as P_consinv_id (the consolidated billing invoice) and P_request_id (the concurrent request ID).
  • write_debug_and_log — Internal helper that writes diagnostic messages to the concurrent request log file when FND_GLOBAL.CONC_REQUEST_ID is not null, and forwards the message to arp_standard.debug. It swallows exceptions to avoid disrupting processing.
  • An additional REPORT-classified procedure completes the documented set of three, consistent with the package's role in driving the ARXCBI consolidated billing output.

Parameter lists beyond those shown are not disclosed in the supplied metadata and should not be assumed.

Tables Accessed

The package reads and writes the following documented tables (referenced through APPS synonyms), which support consolidated billing and its underlying Receivables data:

Usage Notes

ARP_BF_BILL is invoked internally by Oracle Receivables consolidated billing processes and the ARXCBI concurrent program. The reprint procedure is typically called when a user wants to regenerate a previously printed consolidated invoice without creating a new one, effectively resetting the print status to 'PENDING'. Because the package is classified as OTHER and no other packages reference it (0 dependents), it is not intended for direct external API consumption; customization should avoid calling it directly and instead rely on supported Receivables APIs. When invoked in a concurrent context, write_debug_and_log ensures diagnostic messages are captured in the request log, aiding troubleshooting of consolidated billing runs.