Search Results physical_name

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.

• SURVEY_RESOURCE_ID — surrogate primary key and join key to dependent survey tables.
• LOGICAL_NAME and PHYSICAL_NAME — the application-facing identifier of the resource and the underlying file or object name used for retrieval.
• RESOURCE_TYPE — discriminates the kind of resource stored (for example, text versus file-backed content).
• FILE_CONTENT — binary or large-object storage of the resource payload when the resource is file-based.
• LANGUAGE_ID — foreign key to CSS_DEF_LANGUAGES_B, enabling translated or locale-specific resource variants.
• DESCRIPTION — free-text description of the resource's purpose.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, controlling row-level visibility across operating units or security contexts.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF/BC4J framework.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns tracking record provenance.
• F_DELETEDFLAG — soft-delete indicator preserving historical rows.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard EBS DFF (descriptive flexfield) block for customer-specific extensions.

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.