Results for “ies_svy_resources_n1”

10 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IES.IES_SVY_RESOURCES table is a component of the Oracle E-Business Suite survey and assessment framework delivered under the IES schema. It stores the catalog of resource definitions used as header pages, error pages, and final (completion) pages within a survey. When an administrator creates or configures a survey, the lookup lists presented for Header, Error, and Final Page selection are populated from the rows in this table, making it the authoritative registry for survey presentation assets.

Because the table is populated from a canonical file or page definition and is referenced by downstream survey instances, its modeling posture is best characterized as a hub in Data Vault terms: the SURVEY_RESOURCE_ID is a durable, unique business key against which other objects (notably IES_SVY_SURVEYS_ALL) attach as links. Descriptive attributes such as LOGICAL_NAME, PHYSICAL_NAME, and DESCRIPTION behave as satellite-style payload on that hub. The table is classified in the provided metadata as a standalone entity from an FK-participation heuristic, though it does hold an outbound reference to the language and security-group reference tables.

Key Information Stored

The table contains 31 documented columns. The most operationally significant are:

  • SURVEY_RESOURCE_ID (NUMBER) — the surrogate primary key (constraint ISR_PK) and the sole business-key candidate, enforced by the unique index IES_SVY_RESOURCES_N1 on the same column. This index is the object most commonly searched when troubleshooting the survey resource lookup.
  • LOGICAL_NAME (VARCHAR2, 80) — the logical identifier for the resource, displayed in the Header/Error/Final Page lookup lists.
  • PHYSICAL_NAME (VARCHAR2, 1000) — the actual file name of the resource, for example myheader.jsp.
  • DESCRIPTION (VARCHAR2, 240) — free-text description of the resource.
  • LANGUAGE_ID (NUMBER) — the language the resource is defined for, resolving to FND_LANGUAGES.
  • RESOURCE_TYPE (NUMBER) — distinguishes whether the row is a header, error, or final page resource.
  • FILE_CONTENT (LOB) — the payload of the resource, referenced by the unique LOB segment SYS_IL0000133770C00030$$.
  • OBJECT_VERSION_NUMBER (NUMBER) — required for HTML/Web-based interfaces to enforce optimistic concurrency.
  • F_DELETEDFLAG (VARCHAR2) — soft-delete indicator maintained by the AOL/Applications Object Manager.
  • SECURITY_GROUP_ID (NUMBER, 15) — supports hosted and multi-tenant deployments via FND_SECURITY_GROUPS.
  • The standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and ATTRIBUTE_CATEGORY / ATTRIBUTE1–15 descriptive flexfield columns are also present, providing auditing and DFF extensibility respectively.

Common Use Cases and Queries

Typical use cases center on interrogating which resources exist, which file backs a given logical name, and whether soft-deleted or language-specific variants are present. Queries should generally filter on F_DELETEDFLAG = 'N' to exclude logically removed rows.

  • List active resources by type: SELECT survey_resource_id, logical_name, physical_name FROM ies.ies_svy_resources WHERE f_deletedflag = 'N' ORDER BY logical_name;
  • Resolve the file name for a survey's header page: join from the survey instance to this table on SURVEY_RESOURCE_ID.
  • Audit language coverage: group by LANGUAGE_ID to confirm each resource has the intended translations.
  • Diagnose lookup gaps: if a Header/Error/Final Page value is missing from the survey setup screen, verify the row's F_DELETEDFLAG and LANGUAGE_ID.
  • Reporting: extract LOGICAL_NAME, PHYSICAL_NAME, DESCRIPTION, and creation metadata for documentation or migration inventories.

Related Objects

The most significant related objects, per the documented FK relationships, are:

  • IES_SVY_SURVEYS_ALL — the primary referencing table; its SURVEY_RESOURCE_ID column points to IES_SVY_RESOURCES.SURVEY_RESOURCE_ID, establishing the header/error/final page assignment.
  • CSS_DEF_LANGUAGES_B — referenced by IES_SVY_RESOURCES.LANGUAGE_ID, the source of language definitions.
  • FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for hosted-environment isolation.
  • IES_SVY_RESOURCES_N1 — the unique index on SURVEY_RESOURCE_ID, central to key-based access and the object named in the user's search.
  • SYS_IL0000133770C00030$$ — the LOB index supporting the FILE_CONTENT column.