Results for “okc_qa_list_processes”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The OKC_QA_LIST_PROCESSES table is a core configuration object within the Oracle E-Business Suite Contracts Core (OKC) module. It records the association between a quality assurance check list and the individual process definitions that participate in that check list. In practical terms, each row answers the question: "Which process, executed in what sequence, is used by which QA check list?" This makes the table the operational glue between the definition of a QA check list and the reusable process definitions that drive contract quality validation.
Because the table carries the surrogate-join columns QCL_ID and PDF_ID along with the ordinal RUN_SEQUENCE, it functions primarily as an association entity that binds two business entities together across the quality-assurance workflow. Under the heuristic Data Vault classification mined from the foreign-key structure, the table is satellite-leaning: it hangs off the check-list and process-definition hubs, capturing context such as severity and active status rather than representing an independent business concept. This classification is a modeling suggestion, not a documented constraint.
Key Information Stored
The table contains 30 documented columns. The most operationally significant are:
- QCL_ID — foreign key to OKC_QA_CHECK_LISTS_B; identifies the QA check list to which this process assignment belongs.
- PDF_ID — foreign key to OKC_PROCESS_DEFS_B; identifies the process definition being invoked.
- RUN_SEQUENCE — ordinal position that controls the order in which the process executes within the check list.
- SEVERITY — the severity assigned to the process outcome, which drives whether a failed QA check blocks contract progression.
- ACTIVE_YN — flag indicating whether this process assignment is currently enabled.
- OBJECT_VERSION_NUMBER — optimistic-locking column used by the framework to detect concurrent updates.
- SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS; enforces multi-tenant data isolation.
- ACCESS_LEVEL — controls record-level access restrictions.
- ZD_EDITION_NAME — editioning column supporting the Edition-Based Redefinition (EBR) model introduced in 12.2.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the DFF (Descriptive Flexfield) segment set for customer-specific extensions.
The surrogate primary key OKC_QA_LIST_PROCESSES_PK is composed of (QCL_ID, PDF_ID, RUN_SEQUENCE). The unique index OKC_QA_LIST_PROCESSES_U1 (QCL_ID, PDF_ID, RUN_SEQUENCE, ZD_EDITION_NAME) is the business-key candidate that additionally includes the edition discriminator.
Common Use Cases and Queries
Typical usage includes resolving the ordered list of processes for a given check list, confirming that a process is not double-assigned, and reporting which check lists depend on a shared process definition.
- Ordered process retrieval for a check list:
SELECT qlp.RUN_SEQUENCE, qlp.PDF_ID, qlp.SEVERITY, qlp.ACTIVE_YN FROM OKC.OKC_QA_LIST_PROCESSES qlp WHERE qlp.QCL_ID = :p_qcl_id ORDER BY qlp.RUN_SEQUENCE;
- Reverse lookup — which check lists consume a given process:
SELECT QCL_ID, RUN_SEQUENCE, ACTIVE_YN FROM OKC.OKC_QA_LIST_PROCESSES WHERE PDF_ID = :p_pdf_id;
- Active-only processing pipeline for a specific contract's QA evaluation, joined to OKC_PROCESS_DEFS_B for descriptive metadata.
- Data-quality audits to find check lists with no active process, or processes sequenced with duplicate ordinals.
Related Objects
- OKC_QA_CHECK_LISTS_B — parent check-list header; joined on QCL_ID.
- OKC_PROCESS_DEFS_B — process definition master; joined on PDF_ID.
- OKC_QA_PROCESS_PARMS — child parameter table referencing this row via (QLP_QCL_ID, QLP_PDF_ID, QLP_RUN_SEQUENCE); supplies run-time parameters for each process invocation.
- FND_SECURITY_GROUPS — security-group master referenced by SECURITY_GROUP_ID.
- OKC_QA_CHECK_LISTS_TL — translated check-list names, useful for reporting-friendly joins with QCL_ID.
- OKC_PROCESS_DEFS_TL — translated process-definition names, joined via PDF_ID.
Together these objects form the QA-check-list configuration stack: the check-list header, the ordered process assignments in OKC_QA_LIST_PROCESSES, and the process parameter rows in OKC_QA_PROCESS_PARMS that complete the definition.
-
The usage of a process def in a particular QA check list.
-
The usage of a process def in a particular QA check list.
-
View for table OKC_QA_LIST_PROCESSES
APPS.OKC_QA_LIST_PROCESSES_V·↳ OKC_QA_LIST_PROCESSES·Explore OKC module →
-
View for table OKC_QA_LIST_PROCESSES
APPS.OKC_QA_LIST_PROCESSES_V·↳ OKC_QA_LIST_PROCESSES·Explore OKC module →
-
APPS.OKL_VP_QACHECK_RESULTS_UV·↳ OKC_PROCESS_DEFS_B·↳ OKC_PROCESS_DEFS_TL·↳ OKC_QA_CHECK_LISTS_TL·Explore OKL module →
-
APPS.OKL_VP_QACHECK_RESULTS_UV·↳ OKC_PROCESS_DEFS_B·↳ OKC_PROCESS_DEFS_TL·↳ OKC_QA_CHECK_LISTS_TL·Explore OKL module →
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 DBA Data 12.2.2