Search Results events status

The AP_ACCOUNTING_EVENTS_ALL table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical repository for accounting events generated by the Accounts Payable (AP) module. It captures transactional data that is essential for financial reporting, reconciliation, and audit purposes. This table serves as a bridge between AP invoice processing and the General Ledger (GL), ensuring that accounting entries are accurately recorded and available for further financial processing. Below is a detailed summary of its structure, functionality, and significance in Oracle EBS.

1. Purpose and Role

The AP_ACCOUNTING_EVENTS_ALL table stores records of accounting events triggered during AP invoice processing, including invoice creation, validation, payment, and adjustments. Each event corresponds to a specific accounting entry that will be transferred to GL via the Subledger Accounting (SLA) engine. The table acts as a staging area before entries are posted to GL_JE_LINES and other GL tables, ensuring data integrity and traceability.

2. Key Columns and Data Structure

The table contains several important columns, including:

ACCOUNTING_EVENT_ID: Primary key uniquely identifying each accounting event.
EVENT_TYPE_CODE: Specifies the type of event (e.g., 'INVOICE', 'PAYMENT', 'ADJUSTMENT').
EVENT_DATE: The date the accounting event was generated.
ACCOUNTING_DATE: The date used for GL period validation.
SOURCE_ID: References the source transaction (e.g., invoice ID or payment ID).
LEDGER_ID: Links the event to a specific ledger for multi-org environments.
STATUS: Indicates whether the event is 'DRAFT', 'FINAL', or 'PROCESSED'.
CREATION_DATE and CREATED_BY: Audit columns tracking record creation.

3. Integration with Subledger Accounting (SLA)

The AP_ACCOUNTING_EVENTS_ALL table feeds data into SLA, which applies accounting rules defined in XLA_EVENTS and XLA_AE_LINES to generate journal entries. The SLA engine uses the EVENT_ID to map AP transactions to GL accounts, ensuring compliance with accounting standards and organizational policies.

4. Multi-Org Support

The table includes the _ALL suffix, indicating it stores data for multiple operating units. The ORG_ID column distinguishes records by legal entity or business unit, enabling secure access through Oracle's Multi-Org Access Control (MOAC) feature.

5. Common Use Cases

Invoice Accounting: Records debit/credit entries for invoice distributions.
Payment Accounting: Captures payment-related entries, including bank charges.
Adjustments: Tracks changes due to invoice corrections or write-offs.
Audit and Reconciliation: Provides a trail for verifying AP-to-GL balances.

6. Technical Considerations

Indexes on ACCOUNTING_EVENT_ID, SOURCE_ID, and LEDGER_ID optimize query performance.
Purge programs (e.g., AP_ACCOUNTING_EVENTS_PURGE) archive or delete stale records to manage table growth.
Custom reports or extensions often join this table with AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, and GL tables.

7. Conclusion

The AP_ACCOUNTING_EVENTS_ALL table is a cornerstone of Oracle AP's financial integration framework. By centralizing accounting events, it ensures accurate, auditable, and efficient financial data flow between subledgers and the general ledger. Understanding its structure and relationships is essential for troubleshooting, reporting, and customizing AP accounting processes in Oracle EBS 12.1.1 or 12.2.2.

Lookup Type: POSTING STATUS 12.1.1
product: AP - Payables , meaning: Posting Status , description: Posting status for invoice distributions and payments ,
Lookup Type: EVENT STATUS 12.1.1
product: AP - Payables , meaning: Event Status , description: Statuses of AP Accounting Events ,
Lookup Type: TRANSFER STATUS 12.1.1
product: AP - Payables , meaning: Transfer Status , description: Transfer Status ,
Lookup Type: VOUCHER STATUS 12.1.1
product: AP - Payables , meaning: Voucher Status , description: Lists possible statuses for a voucher number ,
Lookup Type: ALLOCATION STATUS 12.1.1
product: AP - Payables , meaning: Allocation Status , description: Defines the status of the allocation rule ,
Lookup Type: EVENT STATUS 12.2.2
product: AP - Payables , meaning: Event Status , description: Statuses of AP Accounting Events ,
Lookup Type: PURGE STATUS 12.2.2
product: AP - Payables , meaning: Purge Status , description: Status and action choices for purge process ,
Lookup Type: PREPAY STATUS 12.1.1
product: AP - Payables , meaning: Prepay Status , description: Prepayment Status ,
Lookup Type: ALLOCATION STATUS 12.2.2
product: AP - Payables , meaning: Allocation Status , description: Defines the status of the allocation rule ,
Lookup Type: PURGE STATUS 12.1.1
product: AP - Payables , meaning: Purge Status , description: Status and action choices for purge process ,
Lookup Type: AUTOCLEAR STATUS 12.1.1
product: AP - Payables , meaning: Autoclear Status , description: Status of AutoClear Items ,
Lookup Type: POSTING STATUS 12.2.2
product: AP - Payables , meaning: Posting Status , description: Posting status for invoice distributions and payments ,
Lookup Type: TRANSFER STATUS 12.2.2
product: AP - Payables , meaning: Transfer Status , description: Transfer Status ,
Lookup Type: INVOICE STATUS 12.1.1
product: AP - Payables , meaning: Invoice Status , description: Invoice Status ,
Lookup Type: REQUEST STATUS 12.1.1
product: AP - Payables , meaning: Request Status , description: Credit card request status ,
Lookup Type: MODIFY STATUS 12.1.1
product: AP - Payables , meaning: Modify Status , description: Shows the status for a vendor site in modify paybatch form ,
Lookup Type: CLOSING STATUS 12.1.1
product: AP - Payables , meaning: Closing Status , description: Closing Status ,
Lookup Type: REQUEST STATUS 12.2.2
product: AP - Payables , meaning: Request Status , description: Credit card request status ,
Lookup Type: MODIFY STATUS 12.2.2
product: AP - Payables , meaning: Modify Status , description: Shows the status for a vendor site in modify paybatch form ,
Lookup Type: AUTOCLEAR STATUS 12.2.2
product: AP - Payables , meaning: Autoclear Status , description: Status of AutoClear Items ,
Lookup Type: INVOICE STATUS 12.2.2
product: AP - Payables , meaning: Invoice Status , description: Invoice Status ,
Lookup Type: PREPAY STATUS 12.2.2
product: AP - Payables , meaning: Prepay Status , description: Prepayment Status ,
Lookup Type: CLOSING STATUS 12.2.2
product: AP - Payables , meaning: Closing Status , description: Closing Status ,
Lookup Type: VOUCHER STATUS 12.2.2
product: AP - Payables , meaning: Voucher Status , description: Lists possible statuses for a voucher number ,
Lookup Type: EXPENSE REPORT STATUS 12.1.1
product: AP - Payables , meaning: Expense Report Status , description: Expense Report Status ,
Lookup Type: CHECK BATCH STATUS 12.1.1
product: AP - Payables , meaning: Check Batch Status , description: Payment Batch Status ,
Lookup Type: CHECK BATCH STATUS 12.2.2
product: AP - Payables , meaning: Check Batch Status , description: Payment Batch Status ,
Lookup Type: CHECK RANGE STATUS 12.1.1
product: AP - Payables , meaning: Check Range Status , description: Confirms status of a range of checks during checkrun ,
Lookup Type: STOP PAYMENT STATUS 12.1.1
product: AP - Payables , meaning: Stop Payment Status , description: Stop Payment statuses for checks ,
Lookup Type: PCARD TRX STATUS 12.2.2
product: AP - Payables , meaning: Pcard Trx Status , description: Verification and approval status for transaction distributions ,
Lookup Type: EXPENSE REPORT STATUS 12.2.2
product: AP - Payables , meaning: Expense Report Status , description: Expense Report Status ,
Lookup Type: INVOICE HOLD STATUS 12.2.2
product: AP - Payables , meaning: Invoice Hold Status , description: Hold status of an invoice ,
Lookup Type: LINE ENCUMBRANCE STATUS 12.2.2
product: AP - Payables , meaning: Line Encumbrance Status , description: Defines values for encumbrance status for a line ,
Lookup Type: PCARD TRX STATUS 12.1.1
product: AP - Payables , meaning: Pcard Trx Status , description: Verification and approval status for transaction distributions ,
Lookup Type: POSTED PAID STATUS 12.1.1
product: AP - Payables , meaning: Posted Paid Status , description: Translated values for possible paid and posted statuses ,
Lookup Type: INVOICE HOLD STATUS 12.1.1
product: AP - Payables , meaning: Invoice Hold Status , description: Hold status of an invoice ,
Lookup Type: INVOICE PAYMENT STATUS 12.1.1
product: AP - Payables , meaning: Invoice Payment Status , description: Invoice inquiry payment status ,
Lookup Type: LINE ENCUMBRANCE STATUS 12.1.1
product: AP - Payables , meaning: Line Encumbrance Status , description: Defines values for encumbrance status for a line ,
Lookup Type: POSTED PAID STATUS 12.2.2
product: AP - Payables , meaning: Posted Paid Status , description: Translated values for possible paid and posted statuses ,
Lookup Type: CHECK RANGE STATUS 12.2.2
product: AP - Payables , meaning: Check Range Status , description: Confirms status of a range of checks during checkrun ,
Lookup Type: INVOICE PAYMENT STATUS 12.2.2
product: AP - Payables , meaning: Invoice Payment Status , description: Invoice inquiry payment status ,
Lookup Type: STOP PAYMENT STATUS 12.2.2
product: AP - Payables , meaning: Stop Payment Status , description: Stop Payment statuses for checks ,
Lookup Type: CHECK GENERIC BATCH STATUS 12.2.2
product: AP - Payables , meaning: Check Generic Batch Status , description: Different statuses of a payment batch ,
Lookup Type: CHECK GENERIC BATCH STATUS 12.1.1
product: AP - Payables , meaning: Check Generic Batch Status , description: Different statuses of a payment batch ,
Table: AP_ACCOUNTING_EVENTS_ALL 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_ACCOUNTING_EVENTS_ALL, object_name:AP_ACCOUNTING_EVENTS_ALL, status:VALID, product: AP - Payables , description: Accounting events table , implementation_dba_data: AP.AP_ACCOUNTING_EVENTS_ALL ,
Table: AP_ACCOUNTING_EVENTS_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_ACCOUNTING_EVENTS_ALL, object_name:AP_ACCOUNTING_EVENTS_ALL, status:VALID, product: AP - Payables , description: Accounting events table , implementation_dba_data: AP.AP_ACCOUNTING_EVENTS_ALL ,
Table: AP_PAYMENT_HIST_DISTS 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_PAYMENT_HIST_DISTS, object_name:AP_PAYMENT_HIST_DISTS, status:VALID, product: AP - Payables , description: The APHD table is populated during the pre-processing of the accounting extract that occurs when the Payables user launches the accounting process. Payment distributions are associated with payment accounting events referenced in each row , implementation_dba_data: AP.AP_PAYMENT_HIST_DISTS ,
Table: AP_PAYMENT_HIST_DISTS 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_PAYMENT_HIST_DISTS, object_name:AP_PAYMENT_HIST_DISTS, status:VALID, product: AP - Payables , description: The APHD table is populated during the pre-processing of the accounting extract that occurs when the Payables user launches the accounting process. Payment distributions are associated with payment accounting events referenced in each row , implementation_dba_data: AP.AP_PAYMENT_HIST_DISTS ,
Lookup Type: EVENT TYPE 12.1.1
product: AP - Payables , meaning: Event Type , description: Types of AP Accounting Events ,
Lookup Type: EVENT TYPE 12.2.2
product: AP - Payables , meaning: Event Type , description: Types of AP Accounting Events ,