Search Results okc_qa_process_parms




Overview
Explore in AI Chat

Overview

The OKC_QA_PROCESS_PARMS table is a core data structure within the Oracle E-Business Suite Contracts Core (OKC) module, specifically supporting the Quality Assurance (QA) checklist functionality. Its primary role is to store the specific runtime values that must be supplied to process parameters when a QA checklist is executed against a contract. This table acts as a junction, linking QA checklist processes with their required parameter definitions and holding the concrete values for those parameters, thereby enabling the automated and configurable validation of contract data.

Key Information Stored

The table's structure is defined by a composite primary key and stores parameter values for specific QA process runs. The key columns are:

Alongside these key columns, the table typically contains a column (such as a VALUE or PARAM_VALUE) to store the actual data provided for the parameter during the QA run, though the specific column name is not detailed in the provided excerpt.

Common Use Cases and Queries

The primary use case is auditing and reviewing the inputs used during contract quality checks. For instance, an auditor may need to verify what tolerance value was used for a budget compliance check on a specific contract revision. A common query would join this table to checklist and process definition tables to retrieve all parameter values for a given QA run.

Sample Query Pattern:
SELECT qcl.NAME AS checklist_name,
       pdf.NAME AS process_name,
       pdp.PARAMETER_NAME,
       parm.VALUE
FROM okc_qa_process_parms parm,
     okc_qa_chklists_b qcl,
     okc_process_defs_b pdf,
     okc_process_def_parms_b pdp
WHERE parm.qlp_qcl_id = qcl.id
  AND parm.qlp_pdf_id = pdf.id
  AND parm.pdp_id = pdp.id
  AND qcl.id = :checklist_id;

Related Objects

This table is centrally linked to two key master definition tables via foreign key constraints, as documented in the ETRM metadata:

  • OKC_PROCESS_DEF_PARMS_B: The table is referenced via the column OKC_QA_PROCESS_PARMS.PDP_ID. This relationship ensures that every stored parameter value corresponds to a valid, predefined process parameter.
  • OKC_QA_LIST_PROCESSES: The table is referenced via the composite foreign key on columns OKC_QA_PROCESS_PARMS.QLP_QCL_ID, QLP_PDF_ID, and QLP_RUN_SEQUENCE. This links the parameter values to a specific instance of a process being run as part of a QA checklist execution.

These relationships enforce data integrity, ensuring parameter values cannot exist without a corresponding process definition and an active QA process run.