Search Results ies_questions

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:

QUESTION_ID – Surrogate primary key uniquely identifying each question.
PANEL_ID – Foreign key to IES_PANELS, placing the question on its owning panel.
LOOKUP_ID – Foreign key to IES_LOOKUPS, pointing to the dynamic answer source.
SECURITY_GROUP_ID – Foreign key to FND_SECURITY_GROUPS, controlling row-level access.
NODE_NAME and NODE_UID – Business identifiers for the question node in scripts.
QUESTION_LABEL – The display text shown to end users.
QUESTION_TYPE_ID – Classifies the question (for example, single-select, multi-select, text).
QUESTION_ORDER – Sort order within the panel.
ACTIVE_STATUS – Enables or disables the question without deleting it.
OBJECT_VERSION_NUMBER – Optimistic locking column used by the framework.
ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 – Descriptive flexfield segments for extensibility.
CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS audit columns.

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.

Table: IES_QUESTIONS 12.1.1
owner:IES, object_type:TABLE, fnd_design_data:IES.IES_QUESTIONS, object_name:IES_QUESTIONS, status:VALID, product: IES - Scripting , description: This table contains all questions whose answers will be stored and/or need a dynamic lookup. , implementation_dba_data: IES.IES_QUESTIONS ,
Table: IES_QUESTIONS 12.2.2
owner:IES, object_type:TABLE, fnd_design_data:IES.IES_QUESTIONS, object_name:IES_QUESTIONS, status:VALID, product: IES - Scripting , description: This table contains all questions whose answers will be stored and/or need a dynamic lookup. , implementation_dba_data: IES.IES_QUESTIONS ,
Table: IES_PANELS 12.1.1
owner:IES, object_type:TABLE, fnd_design_data:IES.IES_PANELS, object_name:IES_PANELS, status:VALID, product: IES - Scripting , description: This table contains all panels in a deployed script. , implementation_dba_data: IES.IES_PANELS ,
Table: IES_QUESTION_DATA 12.2.2
owner:IES, object_type:TABLE, fnd_design_data:IES.IES_QUESTION_DATA, object_name:IES_QUESTION_DATA, status:VALID, product: IES - Scripting , description: This table stores all answers collected by Scripting Engine. , implementation_dba_data: IES.IES_QUESTION_DATA ,
Table: IES_QUESTION_DATA 12.1.1
owner:IES, object_type:TABLE, fnd_design_data:IES.IES_QUESTION_DATA, object_name:IES_QUESTION_DATA, status:VALID, product: IES - Scripting , description: This table stores all answers collected by Scripting Engine. , implementation_dba_data: IES.IES_QUESTION_DATA ,
Table: IES_PANELS 12.2.2
owner:IES, object_type:TABLE, fnd_design_data:IES.IES_PANELS, object_name:IES_PANELS, status:VALID, product: IES - Scripting , description: This table contains all panels in a deployed script. , implementation_dba_data: IES.IES_PANELS ,
Table: IES_LOOKUPS 12.1.1
owner:IES, object_type:TABLE, fnd_design_data:IES.IES_LOOKUPS, object_name:IES_LOOKUPS, status:VALID, product: IES - Scripting , description: This table contains all lookups used by questions in a given script. , implementation_dba_data: IES.IES_LOOKUPS ,
Table: IES_LOOKUPS 12.2.2
owner:IES, object_type:TABLE, fnd_design_data:IES.IES_LOOKUPS, object_name:IES_LOOKUPS, status:VALID, product: IES - Scripting , description: This table contains all lookups used by questions in a given script. , implementation_dba_data: IES.IES_LOOKUPS ,