Search Results ies_deployed_scripts




Overview
Explore in AI Chat

Overview

The IES_DEPLOYED_SCRIPTS table, owned by the IES schema, is a core transactional and configuration table within the Oracle E-Business Suite IES - Scripting module. It stores the master registry of every script deployed in a given EBS instance, together with the metadata required to render, execute, version, and relate those scripts. Each script is uniquely identified by DSCRIPT_ID, and the table serves as the central hub from which panels, lookups, transactions, survey definitions, and JAR file associations are derived.

From a data-warehouse modeling perspective, the mined foreign-key topology classifies IES_DEPLOYED_SCRIPTS heuristically as a hub. This is a modeling suggestion rather than a documented Oracle designation: the table holds a stable surrogate key (DSCRIPT_ID) and is referenced by a large fan-out of dependent tables, which is characteristic of a hub entity in a Data Vault design. A companion satellite would normally be created for the descriptive attributes such as DESCRIPTION and ACTIVE_STATUS.

Key Information Stored

The physical schema documents 40 columns. The most operationally significant are:

The unique indexes documented are function-based LOB indexes (SYS_IL0000083914C…) rather than business keys, so DSCRIPT_ID remains the only true business-key candidate.

Common Use Cases and Queries

Typical use cases include auditing deployed scripts, reporting script inventory by application or function, and tracing which survey or transaction consumed a given script.

SELECT d.DSCRIPT_ID,
       d.DSCRIPT_NAME,
       d.ACTIVE_STATUS,
       d.APPLICATION_ID,
       a.APPLICATION_SHORT_NAME
FROM   IES.IES_DEPLOYED_SCRIPTS d,
       FND_APPLICATION a
WHERE  d.APPLICATION_ID = a.APPLICATION_ID
AND    d.F_DELETEDFLAG = 'N'
AND    d.ACTIVE_STATUS = 'Y'
ORDER  BY d.DSCRIPT_NAME;

A second common pattern counts dependent panels and lookups per script to detect orphaned or unreferenced deployments.

SELECT d.DSCRIPT_ID, d.DSCRIPT_NAME, COUNT(p.PANEL_ID) AS panel_count
FROM   IES.IES_DEPLOYED_SCRIPTS d,
       IES.IES_PANELS p
WHERE  d.DSCRIPT_ID = p.DSCRIPT_ID (+)
GROUP  BY d.DSCRIPT_ID, d.DSCRIPT_NAME;

Related Objects

The table participates in an extensive foreign-key network. The most significant related objects are: