Results for “ies_svy_hosting_prof_v”

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

Overview

IES_SVY_HOSTING_PROF_V is a read-only database view owned by the APPS schema within the IES - Scripting product family of Oracle E-Business Suite. It exposes hosting profile configuration data that governs where and how deployed surveys and scripts are published and made accessible to respondents. In EBS release 12.1.1 and 12.2.2, the object is documented as VALID in the ETRM repository, indicating it is a supported, active dictionary object available for query and reporting purposes.

The view serves as a reporting and integration facade over the underlying IES_SVY_HOSTING_PROFILES storage table. It flattens the profile record into a single denormalized rowset that includes audit columns, identity keys, deployment linkage, URL information, and filesystem path details. Because the view is defined with a simple projection and no aggregation, it behaves as a pass-through layer that BI Publisher reports, custom concurrent programs, interfaces, and API callouts can query without needing to understand the physical table layout. Multi-org and security-group awareness is preserved through the SECURITY_GROUP_ID column, allowing the view to participate in standard EBS data security and row-level access patterns.

Underlying Base Objects

The documented definition references a single base object: IES_SVY_HOSTING_PROFILES, which is exposed within the view SQL under the alias HPA. The synonym resolves the underlying table into the APPS schema namespace, so the view and its base table share the same owning schema. The view performs a straight column-to-column mapping with no joins, filters, or set operators, meaning every row and every qualifying column of IES_SVY_HOSTING_PROFILES is represented in the view. The soft-delete indicator F_DELETEDFLAG is carried through unchanged, which allows consumers to exclude logically removed profiles without accessing the base table directly. The one-to-one relationship between the view and its base object means row counts, primary key values, and update semantics are identical, and the view can be treated as a stable interface even if the physical table structure is later modified.

Key Columns

• HOSTING_PROFILE_ID — Primary identifier for the hosting profile; joins to deployment and publishing configuration records.
• SURVEY_DEPLOYMENT_ID — Foreign reference to the survey deployment that this hosting profile supports.
• SERVER_NAME — The host or application server name used to resolve the published survey location; central to environment-specific URL construction.
• SURVEY_URL — Fully formed or template URL through which respondents reach the deployed survey.
• DOCUMENT_ROOT — Filesystem or web root path under which generated survey artifacts are placed.
• SECURITY_GROUP_ID — Security grouping used for row-level access control and multi-org filtering.
• F_DELETEDFLAG — Soft-delete flag; active profiles typically carry a non-deleted value.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and OBJECT_VERSION_NUMBER provide standard EBS auditing and optimistic locking support.

Common Use Cases and Queries

Typical usage includes validating hosting configuration before a survey launch, auditing URL and server assignments across deployments, and feeding interface programs that generate respondent links. Because SERVER_NAME is frequently the search attribute, practitioners commonly filter on it to identify which profiles target a given application tier.

To list active profiles for a specific server:

• SELECT hosting_profile_id, survey_deployment_id, server_name, survey_url, document_root FROM apps.ies_svy_hosting_prof_v WHERE server_name = :p_server_name AND NVL(f_deletedflag,'N') = 'N' ORDER BY survey_deployment_id;

To reconcile profiles against their deployments and audit history:

• SELECT h.hosting_profile_id, h.survey_deployment_id, h.server_name, h.survey_url, h.last_updated_by, h.last_update_date FROM apps.ies_svy_hosting_prof_v h WHERE h.security_group_id = :p_security_group ORDER BY h.last_update_date DESC;

These patterns are representative rather than prescriptive; production queries should respect the participating operating unit or security group and always account for the soft-delete flag to avoid surfacing retired hosting profiles.