Search Results oks_reprocessing




Overview
Explore in AI Chat

Overview

The OKS_REPROCESSING table is a Service Contracts (OKS) module object in Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as a staging and audit registry for reprocessing operations executed against service contract orders, order lines, contract headers, and contract lines. When Service Contracts processes contract authoring, order submission, or concurrent program activity, records that fail during initial execution can be flagged for reprocessing; OKS_REPROCESSING captures the offending identifiers, the diagnostic error text, the outcome flag, and the concurrent request that drove the attempt. In effect, the table provides operators with a durable worklist of items that require a retry or manual intervention.

From a Data Vault modeling perspective, the ETRM metadata classifies this object as standalone, meaning it does not act as a dependent child in a classic hub-and-satellite pattern but is better modeled as an independent hub or a degenerate transaction record in its own right. The suggested interpretation is a standalone hub keyed on the reprocessing event, with the reprocessing metadata treated as descriptive attributes.

Key Information Stored

The physical schema documents 19 columns. The most operationally significant are:

Common Use Cases and Queries

Support teams query OKS_REPROCESSING to triage contract orders that failed to complete. Typical patterns include:

  • Listing all outstanding failures: SELECT ORDER_NUMBER, ERROR_TEXT FROM OKS_REPROCESSING WHERE SUCCESS_FLAG = 'N' AND REPROCESS_YN = 'Y';
  • Auditing which concurrent request produced a failure by joining CONC_REQUEST_ID to FND_CONCURRENT_REQUESTS.
  • Grouping errors to identify systemic issues: SELECT SOURCE_FLAG, ERROR_TEXT, COUNT(*) FROM OKS_REPROCESSING GROUP BY SOURCE_FLAG, ERROR_TEXT;
  • Trend reporting by creation date to measure contract processing reliability over time.
  • Tracing a contract order end-to-end by joining ORDER_ID and CONTRACT_ID to OKC headers and lines.

Related Objects