Search Results get_cons_bill_number




Overview
Explore in AI Chat

Overview

ARRX_TX is a transactional reporting package in the Oracle E-Business Suite Receivables (AR) module, owned by the APPS schema. It provides the procedural infrastructure behind the AR Transaction reports — principally the standard Receivables transaction detail and summary reports and their related audit and forecast variants. The package follows the traditional Oracle Reports/PLSQL server-side report driver pattern: a main entry point is invoked as a concurrent program runnable, while the report itself calls supporting procedures to construct the query, bind parameters, and post-process fetched rows. The package name prefix "ARRX" identifies the Receivables tax report family, while the "TX" suffix signals its transaction-oriented content.

Key Procedures and Functions

The package exposes nineteen documented program units, organised into four logical report families plus a small set of utility helpers.

  • ARTX_REP, BEFORE_REPORT, BIND, AFTER_FETCH — the primary transaction report driver. ARTX_REP accepts the full complement of run-time selection criteria (completed/posted flags, GL and transaction date ranges, transaction type/class, balancing segment, bill-to customer name and number, currency, payment method, document sequence, reporting level and entity, account ranges, batch source, transaction class, and request id) and returns the standard concurrent program RETCODE/ERRBUF pair. BEFORE_REPORT initialises report state, BIND supplies bind variables to the report query, and AFTER_FETCH performs per-row post-processing.
  • ARTX_REP_CHECK, CHECK_BEFORE_REPORT, CHECK_BIND, CHECK_AFTER_FETCH — the parallel driver for the "check" variant of the transaction report, used to reconcile transaction activity against payment and distribution records.
  • ARTX_REP_FORECAST, FORECAST_BEFORE_REPORT, FORECAST_BIND — the forecast report family, used for cash forecasting based on scheduled receipts. This is the family associated with the searched term.
  • ARTX_SALES_REP, SALES_BEFORE_REPORT, SALES_BIND, SALES_AFTER_FETCH — the sales-journal extract driver set.
  • GET_CONS_BILL_NUMBER — a utility returning the consolidated billing number for a bill-to context.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, WHERE_LAST_UPDATE — audit-fencing utilities that expose the last update user and date and generate the WHERE clause fragment used to filter rows by last update information.

Tables Accessed

The package reads and references the following APPS synonyms:

  • RA_CUSTOMER_TRX and RA_CUSTOMER_TRX_LINES — the core transaction headers and lines driving all four report families.
  • RA_CUST_TRX_LINE_GL_DIST — distribution and accounting lines, used for balancing segment and account filters and for report showing accounting detail.
  • AR_PAYMENT_SCHEDULES — installments, used principally by the forecast and check variants to derive scheduled receipts.
  • AR_CONS_INV — consolidated invoice/billing relationships, used in support of GET_CONS_BILL_NUMBER.
  • AR_SYSTEM_PARAMETERS_ALL — system-level defaults consulted during report initialisation.
  • DBMS_SQL and DUAL — used for dynamic query construction (typically in the WHERE_LAST_UPDATE and BIND paths) and trivial value selection.

Usage Notes

ARRX_TX is typically invoked from the Receivables standard concurrent programs that back the AR transaction detail, check, forecast, and sales reports, and from Oracle Reports executions that call the BEFORE_REPORT, BIND, and AFTER_FETCH hooks during report parsing and execution. It is classified as a non-API ("OTHER") package, meaning Oracle does not publish it as a supported programmatic interface; customisations that call it directly do so at their own risk and must track any change in its signature. The package is referenced by one other package in the ETRM metadata. The most recent source header recorded is $Header: ARRXTXS.pls 120.6 2005/12/15, indicating that the program units are stable and unchanged across the 12.1.1 and 12.2.2 releases.