Search Results derive_cash_posted_flag

Overview

AP_SLA_PROCESSING_PKG is an Oracle Payables package in the APPS schema that serves as the integration bridge between Oracle Payables and the Subledger Accounting (SLA) engine. It is a core component of the accounting generation flow in Oracle E-Business Suite 12.1.1 and 12.2.2 that supports the Create Accounting process. When Payables events (invoice validation, payment issuance, payment clearing, prepayment application, or adjustments) are ready to be transformed into subledger journal entries, this package orchestrates the extraction, pre-accounting, accounting, and post-accounting phases. It carries an API classification of OTHER in the ETRM repository, indicating it is an internal package invoked through the SLA accounting program framework rather than a publicly supported extension API. The package maintains a valid status and is referenced only by XLA_AP_ACCT_HOOKS_PKG, reflecting its tight coupling to Payables-specific accounting hook logic.

Key Procedures and Functions

The package exposes six documented procedures and functions that map directly to the stages of the SLA accounting lifecycle:

• PREACCOUNTING — Performs pre-accounting processing on extracted Payables events, preparing data before journal entry derivation begins.
• EXTRACT — Selects and stages Payables transaction data into the SLA event and transaction entity structures so that accounting rules can be applied.
• POSTPROCESSING — Executes cleanup and follow-up logic after the accounting phase, such as updating event statuses and reconciliation flags.
• POSTACCOUNTING — Finalizes the accounting results, including writing back accounting outcomes to Payables and supporting downstream reporting.
• DERIVE_CASH_POSTED_FLAG — Determines whether a transaction has been posted to cash, supporting cash-basis and payment-related accounting logic.
• GET_AMT_ALREADY_ACCOUNTED — Retrieves amounts previously accounted for a given transaction, preventing duplicate accounting and supporting partial accounting scenarios.

Tables Accessed

The package reads and writes several core Payables and SLA tables through APPS synonyms:

• AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_LINES_ALL — Invoice distribution and line detail used for extracting accounting-relevant amounts.
• AP_CHECKS_ALL, AP_PAYMENT_HISTORY_ALL, AP_PAYMENT_HIST_DISTS — Payment and clearing information that drives payment accounting events.
• AP_INVOICE_PAYMENTS_ALL, AP_PREPAY_APP_DISTS, AP_PREPAY_HISTORY_ALL — Links between invoices, payments, and prepayment applications required for accurate journal derivation.
• AP_SELF_ASSESSED_TAX_DIST_ALL — Self-assessed tax distributions that feed tax accounting rules.
• AP_SYSTEM_PARAMETERS_ALL, GL_LEDGERS — System and ledger setup used to determine accounting context and reporting currency.
• XLA_EVENTS, XLA_EVENTS_GT, XLA_TRANSACTION_ENTITIES — SLA event and entity staging tables central to the extract, accounting, and post-accounting cycle.

Usage Notes

AP_SLA_PROCESSING_PKG is not intended to be called directly from custom code. It is invoked internally by the SLA accounting engine, specifically through XLA_AP_ACCT_HOOKS_PKG, when users run the Create Accounting concurrent program or initiate accounting from the Payables Accounting Process. In 12.1.1 and 12.2.2, the package participates in both online and batch accounting modes, including the transfer to General Ledger. Because it is an internal, unsupported package, any customization should be limited to diagnostics such as tracing and troubleshooting accounting failures, or reviewing runtime output. Modifications to its logic are not supported by Oracle and would be overwritten by patching.