Search Results arp_group_inv




Overview
Explore in AI Chat

Overview

ARP_GROUP_INV is an Oracle E-Business Suite Receivables (AR) package that supports the Consolidated Billing Invoice process. It is owned by the APPS schema and declared with AUTHID CURRENT_USER, meaning its unqualified database references resolve against the privileges of the calling user rather than the package owner. The package drives the generation and validation of consolidated invoices, which combine multiple transactions belonging to a single customer or bill-to grouping into one invoice document. Consolidated billing is commonly used where a customer expects a single periodic statement rather than individual invoices per transaction.

The package operates on the AR_CONS_INV consolidation tables and the Receivables interface tables. Its design follows the standard Receivables batch pattern: read source transactions, validate them, persist consolidation grouping data, and then produce interface records that are subsequently processed into actual transactions. The private header comment indicates a legacy lineage ("ARPMINVS.pls"), reflecting an older module name associated with consolidated invoice maintenance.

Key Procedures and Functions

  • generate — Drives generation of the consolidated invoice data for a given concurrent request. It is the primary entry point used when a consolidation run is executed.
  • validate_data — Performs validation across the selected source transactions before or during the consolidation run, identifying records that cannot be consolidated.
  • update_ps — Updates payment schedules associated with the transactions being consolidated, aligning installment and due-date information with the newly formed consolidated invoice.
  • validate_group — Validates the consolidation group assembled for the run. This is the procedure associated with the user's search term "validate_group." It accepts a request identifier and returns the count of rejected rows through an OUT NOCOPY parameter, allowing the caller to report how many records failed grouping validation.

Tables Accessed

Documented references fall into several functional groups:

Usage Notes

ARP_GROUP_INV is normally invoked indirectly through the Consolidated Billing Invoice concurrent program, which supplies the request identifier passed to generate, validate_data, and update_ps. Direct calls from forms or custom PL/SQL are uncommon; because the package is not referenced by any other documented package, it functions as a top-level worker rather than a shared library. Customizations should call validate_group only within a controlled run context, since it depends on consolidation data already staged for the request. Validation failures are surfaced through the returned rejected-row count and RA_INTERFACE_ERRORS.