Search Results ies_panels

Overview

IES_PANELS is a table in the IES (Intelligent Enterprise Scripting / Oracle Scripting) schema within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the panel definitions that make up a deployed Oracle Scripting script. In the Oracle Scripting architecture, a script is the top-level container presented to an agent or end user during a guided interaction; each script is composed of one or more panels, where a panel represents a discrete screen or logical grouping of content. IES_PANELS therefore acts as the structural bridge between a deployed script and the individual questions and data fields rendered within it.

From a Data Vault modeling perspective, the FK structure mined from this table suggests a hub-leaning classification. IES_PANELS is referenced by both IES_PANEL_DATA and IES_QUESTIONS through PANEL_ID, and a hub-like candidate exists in PANEL_UID. This designation is a heuristic modeling suggestion rather than a physical fact, and should be treated as guidance when building downstream integration or warehouse layers.

Key Information Stored

The table contains 29 documented columns, of which the most operationally significant are:

PANEL_ID — Surrogate primary key, backed by IES_PANELS_PK. This is the immutable technical identifier used by child tables.
PANEL_NAME — Human-readable name of the panel, used for developer and administrative identification.
PANEL_UID — A stable identifier for the panel across deployment contexts; a strong business-key candidate for cross-system reconciliation.
PANEL_LABEL — The display label rendered to the user at runtime.
DSCRIPT_ID — Foreign key to IES_DEPLOYED_SCRIPTS, tying the panel to its parent deployed script.
ACTIVE_STATUS — Flag indicating whether the panel is active within the deployment.
SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, controlling multi-tenant visibility and access.
OBJECT_VERSION_NUMBER — Optimistic locking column used by Oracle EBS concurrent access control.
CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS who-columns providing audit trail.
ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield (DFF) columns available for customer-specific extension.

Common Use Cases and Queries

IES_PANELS is primarily queried to reconstruct script structure, diagnose rendering issues, or report on script content. A typical pattern lists all panels for a given deployed script:

SELECT p.PANEL_ID, p.PANEL_NAME, p.PANEL_LABEL, p.ACTIVE_STATUS FROM IES.IES_PANELS p WHERE p.DSCRIPT_ID = :script_id ORDER BY p.PANEL_ID;
Joining to questions to enumerate panel content: SELECT p.PANEL_NAME, q.QUESTION_ID FROM IES.IES_PANELS p, IES.IES_QUESTIONS q WHERE q.PANEL_ID = p.PANEL_ID AND p.DSCRIPT_ID = :script_id;
Auditing changes via the who-columns: SELECT PANEL_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM IES.IES_PANELS WHERE LAST_UPDATE_DATE > SYSDATE - 30;

Common reporting scenarios include script inventory reports, panel reuse analysis, and impact analysis prior to modifying or deleting a deployed script.

Related Objects

IES_DEPLOYED_SCRIPTS — Parent object; joined on IES_PANELS.DSCRIPT_ID = IES_DEPLOYED_SCRIPTS.DSCRIPT_ID.
IES_PANEL_DATA — Child object holding runtime panel data; references IES_PANELS.PANEL_ID.
IES_QUESTIONS — Child object holding questions associated with each panel; references IES_PANELS.PANEL_ID.
FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID for security and multi-tenant control.

These relationships establish IES_PANELS as a central structural node in the Oracle Scripting data model, linking deployed scripts to their constituent interactive elements.

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_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_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_DEPLOYED_SCRIPTS 12.1.1
owner:IES, object_type:TABLE, fnd_design_data:IES.IES_DEPLOYED_SCRIPTS, object_name:IES_DEPLOYED_SCRIPTS, status:VALID, product: IES - Scripting , description: This table holds all deployed scripts and related information. , implementation_dba_data: IES.IES_DEPLOYED_SCRIPTS ,
Table: IES_DEPLOYED_SCRIPTS 12.2.2
owner:IES, object_type:TABLE, fnd_design_data:IES.IES_DEPLOYED_SCRIPTS, object_name:IES_DEPLOYED_SCRIPTS, status:VALID, product: IES - Scripting , description: This table holds all deployed scripts and related information. , implementation_dba_data: IES.IES_DEPLOYED_SCRIPTS ,
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_PANEL_DATA 12.1.1
owner:IES, object_type:TABLE, fnd_design_data:IES.IES_PANEL_DATA, object_name:IES_PANEL_DATA, status:VALID, product: IES - Scripting , description: This table stores footprinting information during an interaction. , implementation_dba_data: IES.IES_PANEL_DATA ,
Table: IES_PANEL_DATA 12.2.2
owner:IES, object_type:TABLE, fnd_design_data:IES.IES_PANEL_DATA, object_name:IES_PANEL_DATA, status:VALID, product: IES - Scripting , description: This table stores footprinting information during an interaction. , implementation_dba_data: IES.IES_PANEL_DATA ,