Search Results ies_questions




Overview
Explore in AI Chat

Overview

The IES_QUESTIONS table is a core configuration object within the IES (Scripting) module of Oracle E-Business Suite, available in both release 12.1.1 and 12.2.2. It stores the master definition of every question whose responses must be captured and persisted, or whose valid answer set requires a dynamic lookup at runtime. In practical terms, IES_QUESTIONS acts as the question registry that drives dynamic, scripted questionnaires presented to users, ensuring consistent labeling, ordering, and answer sourcing across panels and scripts. The table is owned by the IES schema and is documented as VALID in the ETRM repository, with a total of 32 columns.

From a dimensional modeling perspective, the heuristic Data Vault classification for this object is satellite-leaning. This suggests that IES_QUESTIONS is best modeled as a descriptive satellite attached to a business hub or link (for example, a panel or question-definition hub), rather than as a pure hub or pure link. Analysts building a vault model should treat QUESTION_ID as the driving key of that satellite.

Key Information Stored

The table’s surrogate primary key is QUESTION_ID, enforced by the IES_QUESTIONS_PK constraint. Business-key candidates include NODE_NAME and NODE_UID, which identify the question within its scripting context, and the combination of PANEL_ID with QUESTION_ORDER, which governs presentation sequence. The most significant columns are:

Common Use Cases and Queries

Typical scenarios include rendering a panel’s questions in order, resolving each question’s answer lookup, and reporting on active versus inactive questions. A representative query joins IES_QUESTIONS to IES_LOOKUPS to expose the answer source:

  • SELECT q.question_id, q.question_label, q.question_order, l.lookup_type FROM ies.ies_questions q, ies.ies_lookups l WHERE q.lookup_id = l.lookup_id AND q.panel_id = :panel_id AND q.active_status = 'Y' ORDER BY q.question_order;

Additional patterns include listing questions by security group, auditing changes via the standard WHO columns, and dynamically building runtime lists when LOOKUP_ID is populated. Reporting use cases range from questionnaire inventory and usage audits to identifying questions lacking a dynamic lookup.

Related Objects

The FK metadata identifies the principal dependencies:

  • IES_PANELS – joined via IES_QUESTIONS.PANEL_ID; the parent panel definition.
  • IES_LOOKUPS – joined via IES_QUESTIONS.LOOKUP_ID; supplies dynamic answer values.
  • IES_QUESTION_DATA – references IES_QUESTIONS.QUESTION_ID; stores captured answers.
  • FND_SECURITY_GROUPS – joined via SECURITY_GROUP_ID; enforces access control.

Together these objects form the scripting question-answer framework, with IES_QUESTIONS as the central descriptive entity.