Results for “arp_bf_bill”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ARP_BF_BILL is an Oracle Receivables package owned by APPS that drives the Consolidated Billing Invoice Print and Accept/Reject concurrent programs in Oracle E-Business Suite 12.1.1 and 12.2.2. The package exposes a record type, ReportParametersType, that consolidates all submission parameters for these reports, together with overloaded Report procedures that serve as the entry points invoked by the concurrent manager. Its principal business purpose is to print consolidated billing invoices generated against billing cycles, including the ability to restrict output by customer name, customer number, bill-to site, billing date range, currency, payment term, and consolidated invoice identifier, and to support the downstream Accept/Reject processing of those consolidated invoices.

Key Procedures and Functions

ETRM documents three procedure entries, all named REPORT and differentiated by signature overload:

• Report(P_report IN ReportParametersType) — The single-argument form accepts the packaged record type carrying every print and selection parameter in one structure. It is convenient for callers that build the record programmatically.
• Report(...) with individual IN parameters plus Errbuf OUT NOCOPY VARCHAR2 and Retcode OUT NOCOPY NUMBER — The primary concurrent-program interface for invoice printing. It returns a standard EBS completion code (Retcode) and message buffer (Errbuf) for the concurrent manager. Its parameters include P_print_option, P_org_id, P_print_output, P_billing_cycle_id, P_billing_date, P_currency, customer name/number low-high ranges, bill-to site low-high, P_term_id, P_detail_option, and defaults for P_consinv_id and P_request_id.
• Report(...) (Accept/Reject overload) with Errbuf, Retcode, and a distinct parameter set — This overload supports the Accept/Reject variant, selecting by customer number, bill-to site, bill date range, and consolidated invoice range rather than billing cycle and currency.

The user search term p_print_option corresponds to the P_print_option IN parameter (and the identically named print_option VARCHAR2(12) field in ReportParametersType), which controls the print mode — for example whether output is produced for printing, for an accept/reject run, or for review — and therefore determines which of the overloads is relevant.

Tables Accessed

Per ETRM, the package references these APPS-synonym tables:

• AR_CONS_INV, AR_CONS_INV_S, AR_CONS_INV_TRX, AR_CONS_INV_TRX_LINES — Consolidated invoice headers, their transactions, and transaction lines; the core print data.
• AR_CONS_BILL_CYCLES_B — Billing cycle definition, used when P_billing_cycle_id is supplied.
• HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES, HZ_CUSTOMER_PROFILES — Customer, site, and profile information for name/number and bill-to selection and for report display.
• AR_PAYMENT_SCHEDULES, AR_RECEIVABLE_APPLICATIONS, AR_ADJUSTMENTS, AR_CASH_RECEIPTS — Transaction balances, applications, adjustments, and receipts supporting invoice detail and reconciliation figures.
• AR_AGING_BUCKETS, AR_AGING_BUCKET_LINES, AR_SYSTEM_PARAMETERS — Aging definitions and Receivables system options used for bucket and defaulting behavior.

Usage Notes

ARP_BF_BILL is normally invoked from the Receivables concurrent program definitions for consolidated billing invoice printing and for accept/reject processing, where the concurrent manager calls the multi-argument Report overload and supplies Errbuf and Retcode. P_print_option is passed through from the concurrent program's parameter form or from a custom launcher to select the processing mode. Because the package is classified OTHER rather than as a public API and is referenced by zero other packages, it should be treated as an internal implementation unit: custom code may invoke the documented Report overloads, but callers must pass P_org_id to respect multi-org security and should expect no supported extension points beyond the supplied parameters.