Search Results get_inv_ps




Overview
Explore in AI Chat

Overview

ARP_PROCESS_DET_PKG is a core Accounts Receivable processing package in Oracle E-Business Suite (12.1.1 / 12.2.2). It handles the detailed accounting distribution processing that occurs when receipts, applications, adjustments, and credit transactions are created or updated. The package is the engine that computes and validates distribution lines, proration of amounts, tax treatment, and discount breakups before records are committed to the subledger accounting and general ledger interface. It is a heavily reused utility: the ETRM documents that it is referenced by five other packages, including ARP_PROCESS_APPLICATION, ARP_DET_DIST_PKG, ARP_PS_PKG, and ARP_PS_UTIL, indicating that it sits beneath higher-level receipt and application processing flows. Business users encounter its effects indirectly—correct distributions, prorated amounts, and adjusted discounts on receipt applications—rather than invoking it directly.

Key Procedures and Functions

The ETRM metadata documents eleven procedures and functions within this package body. Their documented purposes are summarized below; no parameter signatures are asserted here because the metadata does not provide them.

  • INITIALIZATION — Establishes the package state and working context for a processing run, preparing internal structures and cached values before subsequent calls.
  • APPLICATION_EXECUTE — Drives the execution of an application event, coordinating the detailed processing steps required to record and distribute the application.
  • FINAL_COMMIT — Performs the final commit of work processed by the package, persisting distributions and related rows.
  • GET_LATEST_AMOUNT_REMAINING — Returns the most current remaining (unapplied) balance for a processed transaction, used to maintain accurate balances during processing.
  • GET_LATEST_AMOUNT_APPLIED — Returns the latest amount applied against a transaction or line.
  • GET_APP_RA_AMOUNTS — Retrieves application and receivable-application amounts used to derive distributions.
  • BASE_FOR_PRORATION — Supplies the base amount used when prorating a distribution across lines or tax components.
  • ELEMENT_FOR_PRORATION — Supplies an individual element (line or component) participating in the proration calculation.
  • VERIF_INT_ADJ_LINE_TAX — Validates the interaction between adjustment lines and tax during distribution processing.
  • VERIF_INT_APP_LINE_TAX — Validates the interaction between application lines and tax during distribution processing.
  • BREAKUP_DISCOUNTS — Splits and allocates discount amounts across the relevant distribution lines.

Tables Accessed

The package reads and writes a broad set of Receivables tables through APPS synonyms. The most relevant to the user's search term, AR_RECEIVABLE_APPLICATIONS_S, is the application detail table that this package accesses during application execution, alongside AR_RECEIVABLE_APPLICATIONS and AR_RECEIVABLE_APPLICATIONS_ALL. Distribution output is written to AR_DISTRIBUTIONS_ALL, the subledger distribution table. Receipt-related context is gathered from AR_CASH_RECEIPTS and AR_CASH_RECEIPT_HISTORY, while receivable balances come from AR_PAYMENT_SCHEDULES and transaction data from RA_CUSTOMER_TRX and RA_CUSTOMER_TRX_LINES(_ALL). Tax and line-level distribution information is read from RA_CUST_TRX_LINE_GL_DIST, and adjustments from AR_ADJUSTMENTS. Receipt method and bank account defaults are drawn from AR_RECEIPT_METHODS, AR_RECEIPT_METHOD_ACCOUNTS, AR_RECEIVABLES_TRX, CE_BANK_ACCOUNTS, CE_BANK_ACCT_USES, and CE_BANK_BRANCHES_V. The package also uses global temporary tables (AR_AE_ALLOC_REC_GT, AR_LINE_APP_DETAIL_GT, AR_LINE_DIST_INTERFACE_GT, AR_RECEIVABLE_APPS_GT, RA_AR_GT, RA_CUSTOMER_TRX_LINES_GT) to stage intermediate results during processing, and FND/GL tables such as FND_CURRENCIES, FND_MESSAGE, GL_SETS_OF_BOOKS, and AR_SYSTEM_PARAMETERS for setup and messaging.

Usage Notes

ARP_PROCESS_DET_PKG is an internal infrastructure package rather than a public API. It is invoked by higher-level Receivables processing packages—ARP_PROCESS_APPLICATION for application flows, ARP_DET_DIST_PKG for distribution logic, and the ARP_PS_PKG/ARP_PS_UTIL balance utilities. Its typical entry points are receipts workbench activities, Automatic Receipts, AutoLockbox, adjustments, and credit memo applications, all of which ultimately trigger detailed distribution calculation. Because the ETRM classifies it as OTHER (not a public API) and it is referenced by five other packages but references no external callers, custom code should avoid calling it directly. Instead, developers extending Receivables should use the supported public APIs (such as AR_RECEIPT_API_PUB) and allow this package to handle distribution detail as part of the standard processing flow.