Results for “logical_name”

4 results




Overview
Explore in AI Chat

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

Overview

The view APPS.IES_SVY_RESOURCES_V is a documented database object within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environment, owned by the APPS schema and registered with a status of VALID in the ETRM repository. It belongs to the IES product family, identified as IES – Scripting, which supports the survey and scripting infrastructure used across Oracle applications. The view exposes survey resource definitions maintained by the Scripting module, presenting a simplified and stable interface for reporting and integration consumers without requiring direct access to the underlying base object. Because it is defined as a view rather than a table, it introduces no independent storage and inherits all constraints, indexes, and data integrity rules from its constituent base object. Applications, concurrent programs, and external integrations query this view to resolve the relationship between a survey resource's logical identity and its physical implementation.

Underlying Base Objects

According to the documented view metadata for Release 12.2.2, IES_SVY_RESOURCES_V is defined over a single referenced base object: the synonym IES_SVY_RESOURCES. The view text is expressed as a projection from IES_SVY_RESOURCES ISR, meaning the alias ISR denotes the underlying synonym that ultimately resolves to the physical survey resources table maintained by the Scripting module. Because only one base object is referenced, the view does not perform joins, unions, or aggregations; it functions as a direct column-level projection. This design has two practical consequences. First, row cardinality and row ordering reflect the base object exactly. Second, any change applied to the underlying table — inserts, updates, or logical deletions through the F_DELETEDFLAG column — is immediately visible through the view without refresh or materialization. There is no denormalization or transformation layer between the synonym and the view output.

Key Columns

The view exposes the following documented columns, each carrying standard EBS multi-language and audit semantics:

  • SURVEY_RESOURCE_ID — Primary identifier for a survey resource record; the primary key of the base object.
  • OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Application Framework (OAF) and other clients to detect concurrent modification.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard "Who" audit columns populated by EBS audit conventions.
  • LANGUAGE_ID — Foreign key to the language dimension, supporting multi-lingual (MLS) content storage.
  • LOGICAL_NAME — The application-level name by which a survey resource is identified in code and configuration; this is the attribute most frequently searched by implementers.
  • PHYSICAL_NAME — The physical or technical name corresponding to the logical name, typically used for file or object resolution at runtime.
  • F_DELETEDFLAG — Logical delete indicator; rows are retained physically while flagged as removed.
  • SECURITY_GROUP_ID — Multi-tenant / security grouping column used in hosted or partitioned deployments.
  • DESCRIPTION — Free-form descriptive text associated with the resource.

The relationship between LOGICAL_NAME and PHYSICAL_NAME is central to the view's purpose: it bridges human-readable identifiers with the concrete names required for execution.

Common Use Cases and Queries

The view supports lookup, validation, and diagnostic reporting. Typical usage includes resolving a logical resource name to its physical counterpart, listing active (non-deleted) survey resources, and auditing configuration changes by creation or update date.

To retrieve all active survey resources:

  • SELECT SURVEY_RESOURCE_ID, LOGICAL_NAME, PHYSICAL_NAME, DESCRIPTION FROM APPS.IES_SVY_RESOURCES_V WHERE F_DELETEDFLAG = 'N';

To resolve a specific logical name to its physical name:

  • SELECT LOGICAL_NAME, PHYSICAL_NAME FROM APPS.IES_SVY_RESOURCES_V WHERE LOGICAL_NAME = :p_logical_name AND F_DELETEDFLAG = 'N';

To audit recent configuration changes:

  • SELECT SURVEY_RESOURCE_ID, LOGICAL_NAME, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM APPS.IES_SVY_RESOURCES_V WHERE LAST_UPDATE_DATE >= SYSDATE - 30 ORDER BY LAST_UPDATE_DATE DESC;

Because the view is a direct projection of IES_SVY_RESOURCES, queries are lightweight. Access should be granted through the APPS schema or via a custom synonym, and callers should respect the logical delete flag in all reporting predicates.