Search Results okc_aqerrors




Overview
Explore in AI Chat

Overview

The OKC_AQERRORS table resides in the OKC schema (Contracts Core) and serves as the error repository for the Advanced Queuing (AQ) infrastructure that carries contract action messages within Oracle E-Business Suite. When Oracle Contracts enqueues action messages to the Actions AQ, one or more subscriber processes dequeue and process those messages. Any failure encountered during dequeue or processing is persisted in this table, preserving the error context so that administrators and integration developers can diagnose and remediate failed contract action deliveries without losing the original queue payload.

In Data Vault terms, the metadata's heuristic classification places this table as hub-leaning. A hub typically holds a distinct business key with minimal descriptive attributes; here the ID column functions as the durable identity anchor for each error record, while a limited set of descriptive columns hang off it. This classification is a modeling suggestion: consumers building a Data Vault or dimensional layer around OKC should treat ID as the hub key and consider whether the descriptive attributes (queue name, message ID, timestamps, retry count) are better represented as a satellite.

The table is present and VALID in both EBS 12.1.1 and 12.2.2, with a documented physical schema of 13 columns in the 12.2.2 ETRM reference.

Key Information Stored

The central identifier is ID, enforced through the primary key constraint OKC_AQERRORS_PK and uniquely indexed by OKC_AQERRORS_U1. This surrogate key distinguishes each captured AQ error occurrence and is referenced by downstream stack-trace records.

  • ID — Surrogate primary key and the surviving business-key candidate (unique index OKC_AQERRORS_U1).
  • SOURCE_NAME — Identifies the originating process or component that reported the error.
  • DATETIME — The timestamp at which the error condition was recorded.
  • Q_NAME — The name of the Advanced Queue involved, typically the Actions queue.
  • MSGID — The AQ message identifier of the message that failed, essential for correlating with the queue's own history.
  • RETRY_COUNT — The number of delivery or processing attempts made before the error was logged.
  • QUEUE_CONTENTS — The preserved message payload, allowing the failed action to be replayed or inspected.
  • CREATED_BY, CREATION_DATE — Standard WHO-column audit attributes capturing record creation.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO-column audit attributes capturing the most recent modification.
  • SECURITY_GROUP_ID — Multi-org/security partitioning column, with a documented foreign key to FND_SECURITY_GROUPS.

Common Use Cases and Queries

The primary operational scenario is troubleshooting failed contract action subscriptions. Administrators query this table to determine which messages failed, how often they were retried, and what payload was being processed at the time of failure. A typical pattern joins the error header to its stack entries:

SELECT e.id, e.source_name, e.q_name, e.msgid, e.retry_count, s.*
FROM okc.okc_aqerrors e, okc.okc_aqmsgstacks s
WHERE e.id = s.aqe_id
ORDER BY e.datetime DESC;

Reporting use cases include error-frequency trending by queue or source, identification of messages that exceeded a retry threshold, and auditing of security-group-scoped failures. Filtering by SECURITY_GROUP_ID supports multi-org deployments where contract activity is segregated by operating unit.

Related Objects

  • OKC_AQMSGSTACKS — Child table referencing OKC_AQERRORS via AQE_ID, holding the detailed stack trace for each logged error.
  • FND_SECURITY_GROUPS — Referenced through OKC_AQERRORS.SECURITY_GROUP_ID, providing the security partitioning context.
  • OKC_AQERRORS_PK / OKC_AQERRORS_U1 — Primary key constraint and unique index on ID, governing identity and lookup performance.
  • Oracle Advanced Queuing dictionary views (for example QUEUE_TABLE views) — used alongside MSGID and Q_NAME to reconcile queue-level message history with captured errors.