Results for “ies_svy_hosting_profiles”

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

Overview

The IES.IES_SVY_HOSTING_PROFILES table is a core configuration object within the Oracle E-Business Suite IES – Scripting module (also referenced in some releases as iSurvey or Scripting). It stores the hosting profile definitions that govern how a published survey or script deployment is exposed to respondents, including the location of hosted content, server addressing, and the document root under which survey artifacts reside. Each record links a hosting profile to a specific survey deployment, thereby allowing a single deployment to be served from one or more hosting configurations. The table resides in the IES schema and is marked VALID in the ETRM 12.2.2 data model documentation, containing 30 documented columns.

From a Data Vault modeling perspective, the ETRM metadata classifies this table as satellite-leaning. This is a heuristic suggestion: the table's descriptive attributes (URL, server name, document root, hosting type) attach context to a parent business entity rather than representing an independent hub or a pure many-to-many link. Modeling it as a satellite keyed to the survey deployment is a reasonable normalization approach.

Key Information Stored

The table is keyed by the surrogate primary key HOSTING_PROFILE_ID (constraint IES_SVY_HOSTING_PROFILES_PK). This identifier is system-generated and carries no intrinsic business meaning. The most consequential columns include:

• SURVEY_DEPLOYMENT_ID – Foreign key to IES_SVY_DEPLYMENTS_ALL; the business linkage tying the hosting profile to a deployment.
• HOSTING_TYPE – Classifies the hosting mode (e.g., internal server, external URL, hosted service).
• SURVEY_URL – The externally resolvable address at which the deployed survey is presented to respondents.
• SERVER_NAME – The application or web server that serves the hosted content.
• DOCUMENT_ROOT – The filesystem or web context root from which survey documents are dispensed.
• SECURITY_GROUP_ID – Foreign key to FND_SECURITY_GROUPS, enabling multi-tenant/row-level data filtering.
• OBJECT_VERSION_NUMBER – Optimistic locking column supporting concurrent updates via the OAF framework.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS WHO columns providing audit provenance.
• F_DELETEDFLAG – Soft-delete indicator preserved for historical integrity.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 – The DFF (Descriptive Flexfield) segment set for client-specific extension.

The primary business-key candidate is the pairing of SURVEY_DEPLOYMENT_ID with SERVER_NAME or SURVEY_URL, though the metadata documents only the surrogate PK as a unique index.

Common Use Cases and Queries

Typical use cases include auditing which URL respondents were directed to for a given deployment, reconciling hosting configuration across environments, and reporting on deployment coverage. A representative query joining the hosting profile to its deployment parent:

• SELECT hp.HOSTING_PROFILE_ID, hp.SURVEY_URL, hp.SERVER_NAME, hp.HOSTING_TYPE FROM IES.IES_SVY_HOSTING_PROFILES hp WHERE hp.SURVEY_DEPLOYMENT_ID = :deployment_id AND NVL(hp.F_DELETEDFLAG,'N') = 'N';
• Security-filtered reporting via FND_SECURITY_GROUPS join on SECURITY_GROUP_ID.
• Change-history monitoring using LAST_UPDATE_DATE and LAST_UPDATED_BY for SOX/audit trails.

Related Objects

The most significant related objects, derived from documented foreign-key relationships, are:

• IES_SVY_DEPLYMENTS_ALL – Parent deployment table; joined on SURVEY_DEPLOYMENT_ID.
• FND_SECURITY_GROUPS – Security group master; joined on SECURITY_GROUP_ID.
• IES_SVY_HOSTING_PROFILES_PK – The primary key constraint enforcing uniqueness of HOSTING_PROFILE_ID.

Additional dependencies are implicit through the IES Scripting deployment and publication workflow, which consumes these profiles when rendering hosted surveys.