Search Results get_casc_pay_sum
Overview
AP_ACCOUNTING_PAY_PKG is the core payables accounting engine within Oracle E-Business Suite that builds the accounting distributions and Subledger Accounting (SLA) events for payment transactions. As part of the APPS schema in Oracle EBS 12.1.1 and 12.2.2, it operates on the payables side of the accounting flow, converting payments against invoices, prepayments, and related historical distributions into the data that ultimately feeds SLA and the General Ledger. The package is therefore central to the correct subledger accounting of the payment lifecycle rather than the invoice creation or liability side.
The package also serves as the foundation that other accounting packages call into. It is referenced by several sibling packages — AP_ACCTG_PAY_DIST_PKG, AP_ACCTG_PAY_ROUND_PKG, AP_ACCTG_PREPAY_DIST_PKG (the object referenced in the user's search), and AP_SLA_PROCESSING_PKG — meaning it provides shared accounting logic consumed across payment, prepayment, rounding, and SLA processing. Its status is VALID, and ETRM documents it as an API of classification OTHER.
Key Procedures and Functions
The documented interface exposes nineteen procedures and functions:
- DO_PAY_ACCOUNTING — the primary driver that performs accounting for a payment, generating the distributions and events required for SLA.
- DELETE_HIST_DISTS — removes historical distribution records, used during recalculation or reprocessing.
- PRORATE_HISTORICAL_DISTS — allocates historical distributions across the relevant accounting amounts.
- IS_UPGRADE_PRORATION_EXISTS — determines whether upgrade proration data is present.
- IS_FINAL_PAYMENT and IS_FINAL_EVENT — determine whether the payment being processed is the final one, or the final accounting event.
- GET_BASE_AMOUNT — returns the base (functional currency) amount for the accounting calculation.
- Summation functions: GET_PAY_SUM, GET_PAY_BASE_SUM, GET_PREPAY_SUM, GET_PREPAY_BASE_SUM.
- Cascade summation functions: GET_CASC_PAY_SUM, GET_CASC_INV_DIST_SUM, GET_CASC_BANK_CURR_SUM, GET_CASC_PREPAY_SUM, GET_CASC_TAX_DIFF_SUM, GET_CASC_DISCOUNT_SUM, GET_CASC_INV_DIST_DISC_SUM, GET_CASC_BANK_CURR_DISC_SUM.
These functions aggregate payment, prepayment, invoice distribution, tax difference, discount, and bank-currency amounts to support the distribution build. No parameter lists are published in the metadata.
Tables Accessed
The package reads and writes the following APPS synonyms: AP_INVOICES, AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS, AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_PAYMENTS_ALL, AP_CHECKS_ALL, AP_PAYMENT_HISTORY, AP_PAYMENT_HISTORY_ALL, AP_PAYMENT_HIST_DISTS, AP_PREPAY_APP_DISTS, AP_PREPAY_HISTORY_ALL, AP_SYSTEM_PARAMETERS, AP_SYSTEM_PARAMETERS_ALL, and FINANCIALS_SYSTEM_PARAMS_ALL. The XLA_EVENTS_GT global temporary table is used to stage SLA events generated for the accounting entries. Invoice and distribution tables supply the source amounts, payment history and check tables supply the payment context, prepay tables support prepayment application accounting, and the system parameter tables resolve functional currency and ledger setup.
Usage Notes
AP_ACCOUNTING_PAY_PKG is not intended as a public, standalone API. It is invoked internally by the Payables accounting process and by the SLA processing path, and is called by AP_ACCTG_PAY_DIST_PKG, AP_ACCTG_PREPAY_DIST_PKG, AP_ACCTG_PAY_ROUND_PKG, and AP_SLA_PROCESSING_PKG. Typical triggers include payment accounting runs, prepayment application accounting, and subledger transfer to GL. Custom code should not call this package directly; instead it should use supported SLA or Payables APIs, since changes to this internal package may be overwritten by Oracle patches.