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.