Search Results arp_process_header




Overview
Explore in AI Chat

Overview

ARP_PROCESS_HEADER is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Receivables (AR). It serves as the internal transaction processing engine responsible for inserting, updating, and deleting header-level records within the Receivables transaction model. In Oracle EBS 12.1.1 and 12.2.2, the package is classified as an "OTHER" API rather than a formal public API, which indicates that it is intended primarily for internal use by Oracle's own Receivables processing logic rather than as a supported integration point for customer extensions.

The package encapsulates the logic required to maintain the integrity of transaction headers, including commitments, freight handling, and post-query and post-commit processing hooks. It is a foundational component in the Receivables transaction lifecycle, invoked by higher-level packages during invoice creation, credit memo generation, deposit handling, and receipt reversal.

Key Procedures and Functions

The package exposes seven documented procedures:

  • INSERT_HEADER — Inserts a new transaction header record, establishing the core attributes of an invoice, credit memo, debit memo, or similar document.
  • UPDATE_HEADER — Modifies an existing transaction header, supporting changes to amounts, dates, and other header-level attributes.
  • DELETE_HEADER — Removes a transaction header record, typically as part of a reversal or purge operation.
  • POST_COMMIT — Executes post-commit logic following a database commit, ensuring dependent operations are synchronized after header changes are persisted.
  • UPDATE_HEADER_FREIGHT_COVER — Handles updates specific to freight-related header cover data, supporting the line-level freight distribution associated with a transaction.
  • POST_QUERY — Executes post-query logic, populating derived or cached values when a header record is retrieved.
  • INIT — Initializes package state, caching, or session-level variables required by the other procedures.

Tables Accessed

ARP_PROCESS_HEADER references a broad set of Receivables and shared tables through APPS synonyms. Core transaction tables include RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_LINES, RA_CUST_TRX_LINE_GL_DIST, and RA_CUST_TRX_TYPES, which define the transaction header, its lines, accounting distributions, and document type. AR_PAYMENT_SCHEDULES and AR_CASH_RECEIPTS support receivables scheduling and receipt association. Supporting tables include AR_DEFERRED_LINES, AR_LINE_CONTS, AR_MEMO_LINES, AR_SYSTEM_PARAMETERS, and RA_BATCH_SOURCES. Shared reference data is drawn from GL_CODE_COMBINATIONS, FND_CURRENCIES, HZ_CUST_ACCOUNTS, and HZ_PARTIES, supplying accounting flexfields, currency definitions, and customer identity. It also references ARP_PROCESS_COMMITMENT internally.

Usage Notes

ARP_PROCESS_HEADER is referenced by eleven other packages, including AR_INVOICE_API_PUB, AR_DEPOSIT_API_PUB, AR_INVOICE_TABLE_HANDLER, ARW_CM_COVER, ARP_REVERSE_RECEIPT, ARP_BF_BILL, and ARP_CACHE_UTIL. This dependency pattern confirms that the package is invoked indirectly whenever invoices, deposits, credit memos, or receipt reversals are processed through the standard Receivables application or its public APIs.

Because the package is classified as an internal "OTHER" API, it should not be called directly from custom code. Developers integrating with Receivables should use the supported public APIs such as AR_INVOICE_API_PUB and AR_DEPOSIT_API_PUB, which in turn invoke ARP_PROCESS_HEADER. Direct invocation risks bypassing validation logic and is unsupported by Oracle.