Search Results okc_xprt_question_orders




Overview
Explore in AI Chat

Overview

The OKC_XPRT_QUESTION_ORDERS table is a core data entity within the Oracle E-Business Suite Contracts Core (OKC) module, specifically for versions 12.1.1 and 12.2.2. It functions as an intersection or association table, establishing a many-to-many relationship between contract expert templates and the questions defined within them. Its primary role is to store the precise sequence in which questions must be presented to a user during the contract authoring or review process at runtime. By maintaining this order, it ensures the logical flow and integrity of the guided interview process powered by the Contract Expert feature, which automates the creation of contract terms based on user responses.

Key Information Stored

The table's central purpose is to link a template to its constituent questions while recording their display order. The documented primary key column, QUESTION_ORDER_ID, uniquely identifies each record in this intersection. While the full column list is not detailed in the provided metadata, the table's description implies the existence of at least two critical foreign key columns: one referencing the parent template (likely from a table like OKC_XPRT_TEMPLATES) and another referencing the specific question (likely from a table like OKC_XPRT_QUESTIONS). A dedicated column, such as DISPLAY_SEQUENCE or ORDER_NUMBER, would store the integer value dictating the question's position within the template's sequence. This structure allows a single question to be reused in multiple templates, each with a potentially different order.

Common Use Cases and Queries

The primary use case is the runtime generation of the Contract Expert questionnaire. When a user initiates an expert session, the application queries this table to fetch all questions for the selected template, ordered by the stored sequence. Administrators configuring templates also interact with this entity indirectly through the Oracle application interface. Common reporting queries include listing all questions for a specific template or identifying where a particular question is used. A sample SQL pattern to retrieve the ordered question list for a template would be:

  • SELECT q.question_text, qo.display_sequence
  • FROM okc_xprt_question_orders qo,
  • okc_xprt_questions q
  • WHERE qo.template_id = :p_template_id
  • AND qo.question_id = q.question_id
  • ORDER BY qo.display_sequence;

Related Objects

As an intersection entity, OKC_XPRT_QUESTION_ORDERS has defined foreign key relationships with the core template and question master tables. It is a child table to both. The documented primary key constraint, OKC_XPRT_QUESTION_ORDERS_PK, is defined on the QUESTION_ORDER_ID column. The table is directly referenced by the Contract Expert runtime engine and any custom reports or integrations that need to understand the template-question relationship. Key parent tables it joins to include:

  • OKC_XPRT_TEMPLATES: Contains the master definition of Contract Expert templates. Joined via a foreign key column like TEMPLATE_ID.
  • OKC_XPRT_QUESTIONS: Contains the master list of all possible questions. Joined via a foreign key column like QUESTION_ID.