Search Results okc_doc_qa_lists




Overview
Explore in AI Chat

Overview

The OKC_DOC_QA_LISTS table is a core data structure within the Oracle E-Business Suite Contracts Core (OKC) module. It functions as a master control table that defines the quality assurance (QA) framework for business documents. Its primary role is to store the definitive list of all QA checks that must be performed for a specific type of business document, such as a contract or an agreement, along with the associated severity level for each check. This table is essential for enforcing business rules and data integrity validations during the document lifecycle, ensuring that contracts comply with configured corporate policies and standards before approval or execution.

Key Information Stored

The table's structure is designed to map QA checks to document types. The primary key consists of two columns, establishing a unique rule. The DOCUMENT_TYPE column identifies the category of business document, such as a sales contract or procurement agreement, as defined in the related OKC_BUS_DOC_TYPES_B table. The QA_CODE column stores the specific identifier for a quality check or validation rule (e.g., a check for missing authorized signatories or conflicting terms). While the provided metadata does not list all columns explicitly, the description confirms the table also stores the severity of each check, which likely determines the consequence of a failed validation (e.g., Warning, Error, or Block).

Common Use Cases and Queries

This table is central to the QA validation engine within Contracts. Common use cases include the batch or real-time assessment of contract completeness and compliance. Administrators may query this table to audit or modify the active validation rules for a document type. A typical reporting query would join to the document types table to get a readable description of the rules.

  • Listing all active QA checks for a specific document type:
    SELECT qa.qa_code FROM okc_doc_qa_lists qa WHERE qa.document_type = 'SALES_ORD';
  • Auditing the full set of validations across all document types:
    SELECT bt.name doc_type_name, qa.qa_code, qa.severity FROM okc_doc_qa_lists qa, okc_bus_doc_types_b bt WHERE qa.document_type = bt.document_type ORDER BY 1, 2;

Related Objects

The table maintains a critical relationship with the business document types master table. As documented in the foreign key metadata, the OKC_DOC_QA_LISTS.DOCUMENT_TYPE column references OKC_BUS_DOC_TYPES_B. This ensures that QA lists are only defined for valid, registered document types within the system. The table is also likely referenced by the validation engine's processing logic and by various contract QA reports to determine which checks to execute and evaluate against a specific contract instance.