Search Results delete_invoice_event




Overview
Explore in AI Chat

Overview

APPS.AP_ACCOUNTING_EVENTS_PKG is a server-side PL/SQL package in the Oracle E-Business Suite Payables (AP) module that manages the creation, status maintenance, and period-sweeping of accounting events within the Subledger Accounting (SLA) framework. Accounting events represent the business transactions for which Payables must generate accounting entries, and this package acts as the principal mechanism by which AP records events for invoices, payments, payment batches, and withholding tax distributions before the Create Accounting process consumes them.

The package is classified as a standard API in ETRM, and is referenced by sixteen other packages within the EBS code base, confirming its role as an internal integration point rather than a standalone end-user utility. Its procedures are primarily invoked programmatically during invoice validation, payment confirmation, and payment batch processing, where they ensure that the correct event records exist against which journal entries are ultimately produced.

Key Procedures and Functions

  • CREATE_EVENTS — Creates accounting event records for a specified event type and document, deriving the accounting date and returning the generated accounting event identifier.
  • DELETE_INVOICE_EVENT — Removes an accounting event associated with an invoice, supporting reversal or correction scenarios.
  • UPDATE_INVOICE_EVENTS_STATUS — Updates the status of accounting events tied to a given invoice, typically after validation or accounting completion.
  • UPDATE_PAYMENT_EVENTS_STATUS — Updates accounting event status for a specific payment identified by check identifier.
  • UPDATE_PMT_BATCH_EVENT_STATUS — Updates event status at the payment batch level for project-related payment batches.
  • CREATE_PAYMENT_BATCH_EVENTS — Creates accounting events for all payments within a completed payment batch, scoped by ledger and operating unit.
  • UPDATE_AWT_INT_DISTS — Updates withholding tax (AWT) intermediate distributions associated with an accounting event, reconciling distribution lines to the event for accurate tax accounting. This is the procedure most frequently targeted by searches for update_awt_int_dists.
  • BATCH_UPDATE_PAYMENT_INFO — Applies payment information updates across a payment batch.
  • MULTI_ORG_EVENTS_SWEEP — Sweeps accounting events from one accounting period to another for a given ledger; called by the APXTRSWP concurrent report.
  • SINGLE_ORG_EVENTS_SWEEP — Performs the equivalent period sweep for a single operating unit.
  • SET_PREPAY_EVENT_NOACTION — Marks prepayment-related accounting events as requiring no further accounting action.

Tables Accessed

The package reads and writes Payables transaction tables through APPS synonyms. Invoice-side operations reference AP_INVOICES, AP_INVOICES_ALL, AP_INVOICE_LINES, AP_INVOICE_DISTRIBUTIONS, and AP_INVOICE_DISTRIBUTIONS_ALL, which supply the distribution lines against which events are created. Payment-side operations reference AP_CHECKS, AP_CHECKS_ALL, AP_PAYMENT_HISTORY, AP_PAYMENT_HISTORY_ALL, and AP_PAYMENT_HISTORY_S, supporting payment event creation and batch updates. AP_INVOICE_PAYMENTS and AP_INVOICE_PAYMENTS_ALL link invoices to their payments, while AP_HOLDS and AP_HOLD_CODES support validation-state determination. AP_PREPAY_APP_DISTS is used in prepayment event processing. The AWT distribution update logic operates against withholding tax distribution data reconciled to the event.

Usage Notes

AP_ACCOUNTING_EVENTS_PKG is an internal, non-UI API. It is not exposed through a standard Payables form for direct user invocation but is called by Payables forms such as the Payments workbench, by concurrent programs including the payment batch confirm process and the accounting-date sweep report APXTRSWP, and by SLA event processing routines. Custom code should invoke documented procedures only when replicating standard event creation or status transitions, and should preserve the documented calling sequence parameter to aid diagnostics. Because the package is referenced by numerous other modules, modifications to its behavior can affect invoice validation, payment accounting, and withholding tax journal generation simultaneously.