Results for “event_status_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AP_ACCOUNTING_EVENTS_ALL is the central accounting events table in the Oracle Payables (AP) module. It records every business transaction within Payables that has an accounting impact — invoice validation, invoice adjustments, payment issuance, payment cancellation, and related events — and serves as the authoritative registry from which subledger accounting entries are generated and transferred to General Ledger. Each row represents one accounting event, capturing both the business context (event type, source transaction) and the processing status of that event through the accounting lifecycle.

In Oracle EBS 12.1.1 and 12.2.2, this table is owned by the AP schema and is populated by the Subledger Accounting (SLA) engine as Payables transactions are created, validated, and accounted. The table is typically referenced during period close, when the Create Accounting process reads unaccounted events, when reconciling the Payables subledger to GL, and when diagnosing why a transaction failed to generate entries. Under a heuristic Data Vault classification mined from its foreign key structure, this object is hub-leaning: it holds the durable business key (ACCOUNTING_EVENT_ID) to which multiple dependent tables attach, making it a natural hub around which satellite and link structures would be modeled.

Key Information Stored

The table contains 19 documented columns. The most operationally significant are listed below.

• ACCOUNTING_EVENT_ID — Surrogate primary key (AP_ACCOUNTING_EVENTS_PK) and the single documented unique index candidate (AP_ACCOUNTING_EVENTS_U1). This identifier is the join key propagated to all dependent Payables tables.
• EVENT_TYPE_CODE — Classifies the accounting event (for example, invoice validation or payment issuance), determining which accounting rules apply.
• EVENT_STATUS_CODE — Indicates where the event stands in the accounting cycle, distinguishing events already processed from those pending accounting.
• ACCOUNTING_DATE — The accounting date assigned to the event, used for period assignment and GL transfer.
• EVENT_NUMBER — The user-facing event sequence number.
• SOURCE_TABLE and SOURCE_ID — Identify the originating Payables transaction and its row, enabling drill-back to the source document.
• ORG_ID — The operating unit that owns the event, essential for multi-org reporting and security.
• CANNOT_ACCOUNT_FLAG — Flags events that the accounting engine could not process, used to isolate problem transactions.
• AX_ACCOUNTED_FLAG — Indicates whether the event has been accounted, supporting period-close queries for unaccounted items.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, PROGRAM_ID, REQUEST_ID — Standard audit and concurrent-program columns tracking who or what created and last modified each event.

Common Use Cases and Queries

Typical scenarios include reconciling Payables to General Ledger, identifying events pending accounting before period close, and tracing a source invoice or payment to its accounting event. A representative query retrieves unaccounted events for a given operating unit and date range:

• SELECT accounting_event_id, event_type_code, accounting_date, event_status_code FROM ap.ap_accounting_events_all WHERE org_id = :p_org_id AND accounting_date BETWEEN :p_start AND :p_end AND ax_accounted_flag = 'N';
• Join to AP_AE_HEADERS_ALL on ACCOUNTING_EVENT_ID to retrieve the corresponding subledger journal headers and entries.
• Filter on CANNOT_ACCOUNT_FLAG = 'Y' to isolate failures requiring correction before the Create Accounting program can be rerun.
• Join to AP_INVOICE_DISTRIBUTIONS_ALL or AP_INVOICE_PAYMENTS_ALL on ACCOUNTING_EVENT_ID to reconcile a source document with its accounting event.

Related Objects

The table is referenced by several dependent Payables objects through the ACCOUNTING_EVENT_ID foreign key column:

• AP_AE_HEADERS_ALL (AP_AE_HEADERS_ALL.ACCOUNTING_EVENT_ID → AP_ACCOUNTING_EVENTS_ALL) — the subledger journal header generated for the event.
• AP_INVOICE_DISTRIBUTIONS_ALL (AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_EVENT_ID) — invoice distribution lines linked to their accounting event.
• AP_INVOICE_PAYMENTS_ALL (AP_INVOICE_PAYMENTS_ALL.ACCOUNTING_EVENT_ID) — payment-to-invoice associations carrying the event reference.
• AP_PAYMENT_HISTORY_ALL (AP_PAYMENT_HISTORY_ALL.ACCOUNTING_EVENT_ID) — payment history records tied to the accounting event.

Through these relationships, AP_ACCOUNTING_EVENTS_ALL acts as the hub that connects source Payables transactions to their downstream subledger accounting entries, supporting both operational troubleshooting and period-close reporting.