Search Results ies_svy_resources




Overview
Explore in AI Chat

Overview

IES_SVY_RESOURCES is a table owned by the IES schema within the Oracle E-Business Suite Scripting module (IES - Scripting). It stores logical and physical resource definitions that are consumed by surveys authored and executed through the Scripting framework, most commonly associated with Oracle's iSurvey and related survey-definition tooling. Each row represents a resource — a text string, image, file attachment, or other asset — that can be referenced by one or more surveys. The table is physically present and VALID in both EBS 12.1.1 and 12.2.2, with a documented 31-column structure in the 12.2.2 ETRM schema.

Under the heuristic Data Vault classification derived from its foreign-key structure, this object is modeled as a standalone table (neither hub, link, nor satellite). It references external dimensions but is not itself a shared hub of business keys across the IES model. Its role is best understood as a resource repository that supplies multilingual, security-scoped content to the survey definition tables.

Key Information Stored

The table's surrogate primary key is SURVEY_RESOURCE_ID, enforced by the constraint ISR_PK. A unique index, IES_SVY_RESOURCES_N1, also exists on SURVEY_RESOURCE_ID, making it the primary business-key candidate for lookups and joins.

Common Use Cases and Queries

The primary use case is resolving the resource content and names referenced by a survey. A typical query joins survey definitions to their resources:

  • Enumerate all resources attached to surveys: SELECT s.SURVEY_ID, r.SURVEY_RESOURCE_ID, r.LOGICAL_NAME, r.RESOURCE_TYPE FROM IES.IES_SVY_SURVEYS_ALL s, IES.IES_SVY_RESOURCES r WHERE s.SURVEY_RESOURCE_ID = r.SURVEY_RESOURCE_ID;
  • Filter active resources: add AND r.F_DELETEDFLAG = 'N'.
  • Retrieve by name: SELECT * FROM IES.IES_SVY_RESOURCES WHERE LOGICAL_NAME = :name;
  • Reporting on security partitioning: group by SECURITY_GROUP_ID to audit visibility.
  • Multilingual audits: join to CSS_DEF_LANGUAGES_B on LANGUAGE_ID to report available translations.

Reporting is typically read-only; maintenance is performed through IES survey administration UI rather than direct DML, since FILE_CONTENT and audit columns are managed by the framework.

Related Objects

  • IES_SVY_SURVEYS_ALL — references IES_SVY_RESOURCES via SURVEY_RESOURCE_ID; the principal dependent table.
  • CSS_DEF_LANGUAGES_B — referenced through LANGUAGE_ID; supplies language definitions.
  • FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID; provides row-level security context.
  • IES_SVY_SURVEYS_TL — translated survey metadata, related through survey definitions.
  • FND_LOOKUPS — often used to decode RESOURCE_TYPE values.

These relationships confirm the table's position as a leaf resource store feeding survey definitions rather than a shared hub.