Search Results okc_qa_process_parms_v




Overview
Explore in AI Chat

Overview

The OKC_QA_PROCESS_PARMS_V view is a reporting and integration layer within the Oracle E-Business Suite (EBS) Contracts Core (OKC) module. It resides in the APPS schema and is documented as a view over the base table OKC_QA_LIST_PROCESS_PARMS, with a corresponding public synonym OKC_QA_PROCESS_PARMS. In the context of both release 12.1.1 and 12.2.2, this view exposes quality assurance (QA) list processing parameters that drive clause and contract term validation logic used by the Contract Terms and Quality Assurance engine. The view enables developers, integrators, and reporting tools to read parameter configuration without directly accessing the underlying transactional table, and it preserves the standard EBS audit columns and descriptive flexfield attributes required for concurrent program and interface consumption.

Underlying Base Objects

According to the documented metadata, the view is defined over the base object OKC_QA_PROCESS_PARMS, exposed through a synonym. The view text is a straightforward projection of that table's columns using the alias QPPB, prefixed with the table's ROWID as ROW_ID. Because the view is a simple passthrough with no joins, filters, or aggregations, the columns, data types, and value semantics are inherited directly from the underlying table. This one-to-one mapping means the view behaves identically in 12.1.1 and 12.2.2, and any differences between those releases reside in the base table rather than the view definition. The view is therefore a stable, low-risk access point for parameter data across both versions.

Key Columns

  • ROW_ID — the base table ROWID, useful for row-level addressing and deduplication.
  • PDP_ID — identifier linking the parameter row to its parent process definition or parameter definition record.
  • QLP_QCL_ID — the quality list / quality clause identifier. This is the column most frequently targeted by the search term qlp_qcl_id, connecting a parameter to a specific QA clause or list entry.
  • QLP_PDF_ID — references the associated PDF (process definition file) context for the QA list.
  • QLP_RUN_SEQUENCE — controls the order in which the parameter is evaluated during QA list execution.
  • PARM_VALUE — the actual value supplied for the parameter at runtime.
  • OBJECT_VERSION_NUMBER — optimistic locking column used by the OA Framework to detect concurrent updates.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield segments supporting client-specific extensions.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit stamps identifying who created or modified each parameter row and when.

Common Use Cases and Queries

Typical use cases include extracting QA parameter configuration for reconciliation, joining parameters to their owning QA clause or list, and troubleshooting clause validation failures. A representative query returning all parameters for a specific QA clause is:

  • SELECT qlp_qcl_id, parm_value, qlp_run_sequence FROM okc_qa_process_parms_v WHERE qlp_qcl_id = :p_qcl_id ORDER BY qlp_run_sequence;
  • SELECT pdp_id, qlp_qcl_id, parm_value FROM okc_qa_process_parms_v WHERE pdp_id = :p_pdp_id; — retrieve parameters for a known process/parameter definition.
  • SELECT qlp_qcl_id, COUNT(*) FROM okc_qa_process_parms_v GROUP BY qlp_qcl_id HAVING COUNT(*) > 1; — detect clauses configured with multiple parameters.
  • SELECT * FROM okc_qa_process_parms_v WHERE last_update_date >= :since_date; — audit recently changed parameter configurations.

Because the view carries no transformation overhead, it is suitable for both ad hoc SQL*Plus queries and OA Framework-based inquiries. Integration developers should query this view rather than the base table to remain aligned with documented ETRM metadata and to benefit from the APPS-level privileges granted on the synonym.