Search Results ies_lookups




Overview
Explore in AI Chat

Overview

IES_LOOKUPS is a core configuration table within the IES (Scripting) product of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It resides in the IES schema and is classified as VALID in the ETRM repository. The table stores all lookup definitions used by questions belonging to a given script. In the IES Scripting framework, a script is composed of deployed questions, and each question may present the user with a discrete set of valid responses drawn from an underlying lookup table. IES_LOOKUPS acts as the registry that binds a named lookup to its source data table and to the deployed script in which it is used, allowing the scripting engine to render choice lists dynamically at runtime.

From a heuristic Data Vault modeling perspective, this object is classified as hub-leaning. The surrogate primary key LOOKUP_ID is a stable, non-business identifier that anchors references from multiple dependent tables, which is characteristic of a hub entity. Foreign key columns such as LOOKUP_TABLE_ID and DSCRIPT_ID function as link-style references to parent entities, while descriptive and audit columns behave as satellite attributes. This classification is a modeling suggestion; the physical implementation is a standard EBS transactional table.

Key Information Stored

The table contains 28 documented columns. The most significant are summarized below.

  • LOOKUP_ID — Surrogate primary key defined by constraint IES_LOOKUPS_PK. This is the column referenced by all dependent child tables.
  • LOOKUP_NAME — The business-facing name of the lookup, used to identify it within a script and to present or debug question choice lists. This is the most likely business-key candidate.
  • DSCRIPT_ID — Foreign key to IES_DEPLOYED_SCRIPTS, identifying the deployed script version that owns this lookup.
  • LOOKUP_TABLE_ID — Foreign key to IES_LOOKUP_TABLES, identifying the physical or logical source table from which lookup values are drawn.
  • ACTIVE_STATUS — Flag indicating whether the lookup is currently active and available for question rendering.
  • SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing Oracle EBS multi-org/security-group access control.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — The standard EBS descriptive flexfield (DFF) columns, allowing customer-specific extensibility without schema changes.
  • OBJECT_VERSION_NUMBER — Optimistic locking column used by the OAF/ADF framework to detect concurrent updates.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN capture standard who-columns and are populated automatically by the EBS audit framework.

Common Use Cases and Queries

Typical queries center on resolving which lookups belong to a deployed script, tracing lookups back to their source tables, and auditing answers or questions that reference a lookup.

  • List active lookups for a deployed script: 
    SELECT l.LOOKUP_ID, l.LOOKUP_NAME, l.ACTIVE_STATUS
FROM   IES_LOOKUPS l
WHERE  l.DSCRIPT_ID = :p_dscript_id
AND    l.ACTIVE_STATUS = 'Y';
  • Join lookups to their source tables to determine value origin: 
    SELECT l.LOOKUP_NAME, t.TABLE_NAME
FROM   IES_LOOKUPS l, IES_LOOKUP_TABLES t
WHERE  l.LOOKUP_TABLE_ID = t.LOOKUP_TABLE_ID;
  • Identify questions and answers that depend on a specific lookup: 
    SELECT q.QUESTION_ID, a.ANSWER_ID
FROM   IES_LOOKUPS l, IES_QUESTIONS q, IES_ANSWERS a
WHERE  q.LOOKUP_ID = l.LOOKUP_ID
AND    a.LOOKUP_ID = l.LOOKUP_ID
AND    l.LOOKUP_ID = :p_lookup_id;

Reporting use cases include auditing dangling lookups, verifying security-group segregation, and analyzing DFF attribute usage for customizations.

Related Objects

The following objects are the most significant dependencies based on documented FK relationships.

  • IES_LOOKUP_TABLES — Joined via IES_LOOKUPS.LOOKUP_TABLE_ID; defines the source table supplying lookup values.
  • IES_DEPLOYED_SCRIPTS — Joined via IES_LOOKUPS.DSCRIPT_ID; the deployed script owning the lookup.
  • FND_SECURITY_GROUPS — Joined via IES_LOOKUPS.SECURITY_GROUP_ID; controls security-group access.
  • IES_QUESTIONS — References IES_LOOKUPS.LOOKUP_ID; questions that present the lookup.
  • IES_ANSWERS — References IES_LOOKUPS.LOOKUP_ID; captured answers tied to lookup values.
  • IES_QUESTION_DATA — References IES_LOOKUPS.LOOKUP_ID; question metadata linked to the lookup.
  • 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 , 

  • Table: IES_LOOKUP_TABLES 12.1.1

    owner:IES,  object_type:TABLE,  fnd_design_data:IES.IES_LOOKUP_TABLES,  object_name:IES_LOOKUP_TABLES,  status:VALID,  product: IES - Scripting ,  description: This table contains names of external tables referenced by IES_LOOKUPS table. ,  implementation_dba_data: IES.IES_LOOKUP_TABLES , 

  • Table: IES_LOOKUP_TABLES 12.2.2

    owner:IES,  object_type:TABLE,  fnd_design_data:IES.IES_LOOKUP_TABLES,  object_name:IES_LOOKUP_TABLES,  status:VALID,  product: IES - Scripting ,  description: This table contains names of external tables referenced by IES_LOOKUPS table. ,  implementation_dba_data: IES.IES_LOOKUP_TABLES , 

  • Table: IES_ANSWERS 12.1.1

    owner:IES,  object_type:TABLE,  fnd_design_data:IES.IES_ANSWERS,  object_name:IES_ANSWERS,  status:VALID,  product: IES - Scripting ,  description: This table contains lookup choices. ,  implementation_dba_data: IES.IES_ANSWERS , 

  • Table: IES_ANSWERS 12.2.2

    owner:IES,  object_type:TABLE,  fnd_design_data:IES.IES_ANSWERS,  object_name:IES_ANSWERS,  status:VALID,  product: IES - Scripting ,  description: This table contains lookup choices. ,  implementation_dba_data: IES.IES_ANSWERS , 

  • 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_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_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_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 ,