Search Results ar_cons_inv_s

Overview

The APPS.ARP_GROUP_INV package body is a server-side PL/SQL module in Oracle E-Business Suite Receivables (AR) responsible for group invoicing — the process of consolidating multiple transactions belonging to a common customer or grouping rule into a single consolidated invoice. The consolidated invoice is persisted in the AR_CONS_INV and AR_CONS_INV_S tables, with transactional detail captured in AR_CONS_INV_TRX. The package pulls source transactions from RA_CUSTOMER_TRX and RA_CUST_TRX_TYPES, validates them against Receivables system parameters and customer profile/site data, and writes rejected records to the RA_INTERFACE_ERRORS staging table. It is classified as an "OTHER" API in ETRM and is not referenced by any other database object, indicating it is invoked directly rather than as a lower-level library dependency.

Key Procedures and Functions

Four documented procedures comprise the public interface of ARP_GROUP_INV:

• GENERATE — The primary driver that creates the group/consolidated invoice. It reads candidate transactions, applies grouping logic, inserts rows into AR_CONS_INV, AR_CONS_INV_S, and AR_CONS_INV_TRX, and uses RA_INTERFACE_LINES and RA_INTERFACE_LINES_GT as staging during consolidation.
• VALIDATE_DATA — Performs pre-generation validation of the input transaction set, checking eligibility based on system parameters (AR_SYSTEM_PARAMETERS), customer profile attributes (HZ_CUSTOMER_PROFILES), and site-level configuration (HZ_CUST_ACCT_SITES and HZ_CUST_SITE_USES). Failures are written to RA_INTERFACE_ERRORS.
• VALIDATE_GROUP — Validates the group invoice header itself, verifying referenced records in AR_CONS_INV and AR_CONS_INV_S and consistency against RA_CUSTOMER_TRX and RA_CUST_TRX_TYPES before persistence.
• UPDATE_PS — Updates AR_PAYMENT_SCHEDULES to reflect the new consolidated relationship, ensuring open balances, due dates, and payment schedule linkage remain consistent after the group invoice is created.

Tables Accessed

The package reads and writes the following documented objects via APPS synonyms:

• AR_CONS_INV, AR_CONS_INV_S, AR_CONS_INV_TRX — Target tables storing the consolidated invoice header, its descriptive/sequential components, and the mapping between the consolidated invoice and source transactions.
• RA_CUSTOMER_TRX, RA_CUST_TRX_TYPES — Source transactions and their transaction type definitions.
• AR_PAYMENT_SCHEDULES — Updated by UPDATE_PS to keep payment schedules aligned with the new consolidated invoice.
• RA_INTERFACE_LINES, RA_INTERFACE_LINES_GT, RA_INTERFACE_ERRORS — Staging and error capture during validation and generation.
• HZ_CUSTOMER_PROFILES, HZ_CUST_ACCT_SITES, HZ_CUST_SITE_USES — Trading community customer and site attributes used for grouping and validation logic.
• AR_SYSTEM_PARAMETERS — System-level Receivables configuration governing invoicing behaviour.
• DUAL, STANDARD — Utility references.

Usage Notes

ARP_GROUP_INV is typically invoked from Receivables concurrent programs (notably group invoice generation and consolidation jobs), from AR forms that trigger consolidated invoice creation, or from custom PL/SQL that needs to programmatically build group invoices. Because the package directly manipulates AR_CONS_INV, AR_CONS_INV_TRX, and AR_PAYMENT_SCHEDULES, it should be called within a well-defined transaction boundary with appropriate validation (VALIDATE_DATA / VALIDATE_GROUP) preceding GENERATE. The objects AR_CONS_INV_S and AR_CONS_INV_TRX are closely tied to this package, so any search using the AR_CONS_INV_S synonym should treat ARP_GROUP_INV as the primary code path that populates and maintains those tables. Customisations must respect the ETRM classification and avoid bypassing the documented validation procedures.