Search Results okc_qa_list_processes




Overview
Explore in AI Chat

Overview

The OKC_QA_LIST_PROCESSES table is a core data object within the Oracle E-Business Suite Contracts Core (OKC) module, specifically supporting the Quality Assurance (QA) functionality. It serves as a junction or mapping table that defines the usage and execution order of a specific process definition within a particular QA checklist. This table is fundamental to the automated contract review workflow, enabling administrators to configure a sequence of validation or approval processes that must be executed as part of a checklist during contract authoring or management. Its role is to establish and maintain the many-to-many relationship between QA checklists and process definitions, thereby orchestrating complex, multi-step QA procedures.

Key Information Stored

The table's structure is designed to link a checklist to a process and dictate its execution sequence. The primary key is a composite of three columns, ensuring a unique relationship for each process within a checklist. The critical columns are:

  • QCL_ID: The foreign key to the QA Checklist (OKC_QA_CHECK_LISTS_B). This identifies the specific checklist to which the process is assigned.
  • PDF_ID: The foreign key to the Process Definition (OKC_PROCESS_DEFS_B). This identifies the specific process or workflow to be executed.
  • RUN_SEQUENCE: An integer that dictates the order in which this process is executed relative to other processes within the same checklist (QCL_ID). Lower numbers indicate earlier execution.

Common Use Cases and Queries

A primary use case is auditing and reporting on the configuration of QA checklists. System administrators or functional consultants may need to verify which processes are assigned to a checklist and their order. A common diagnostic query retrieves the full process sequence for a given checklist, joining to the descriptive tables for clarity.

Sample Query:
SELECT qlp.qcl_id,
qlp.pdf_id,
qlp.run_sequence,
qcl.name checklist_name,
pdf.name process_name
FROM okc_qa_list_processes qlp,
okc_qa_check_lists_b qcl,
okc_process_defs_b pdf
WHERE qlp.qcl_id = qcl.id
AND qlp.pdf_id = pdf.id
AND qlp.qcl_id = :checklist_id
ORDER BY qlp.run_sequence;

Another critical scenario involves troubleshooting a QA checklist that is failing; developers would examine this table to confirm the process definitions are correctly linked and sequenced before investigating the process logic or parameters.

Related Objects

OKC_QA_LIST_PROCESSES is centrally connected within the QA and process definition sub-schema. The documented foreign key relationships are:

  • Parent Table: OKC_QA_CHECK_LISTS_B via column QCL_ID. This is the master table for QA checklist definitions.
  • Parent Table: OKC_PROCESS_DEFS_B via column PDF_ID. This is the master table for process definitions.
  • Child Table: OKC_QA_PROCESS_PARMS. This table stores parameters for a specific process within a checklist. It references OKC_QA_LIST_PROCESSES using a composite foreign key on (QLP_QCL_ID, QLP_PDF_ID, QLP_RUN_SEQUENCE), which maps to this table's primary key columns (QCL_ID, PDF_ID, RUN_SEQUENCE).

These relationships form a hierarchical data model where a checklist (OKC_QA_CHECK_LISTS_B) contains one or more processes (via OKC_QA_LIST_PROCESSES), and each process-instance can have multiple parameters (OKC_QA_PROCESS_PARMS).