Results for “fnd_profile_values_servresp_v”

14 results




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

Overview

FND_PROFILE_VALUES_SERVRESP_V is a reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes a filtered subset of profile option values recorded in the Application Object Library (FND) profile option infrastructure. Specifically, the view restricts its result set to rows whose LEVEL_ID equals 10007, the level identifier that Oracle EBS uses to designate the "Server Responsibility" (also referred to as Web Host Responsibility or Service Responsibility) level. Profile options can be assigned at several levels—Site, Application, Responsibility, and User—with additional context levels such as Server and Server Responsibility introduced for multi-node deployments. This view isolates the responsibility-context level so that administrators and integrators can query those assignments without manually filtering the much larger FND_PROFILE_OPTION_VALUES table.

Because profile option values at the responsibility level determine how forms, concurrent programs, and self-service pages behave for a given responsibility on a given server, the view is typically consumed for diagnostics, configuration auditing, and migration or cloning validation.

Underlying Base Objects

The view is defined directly over FND_PROFILE_OPTION_VALUES (referenced in the ETRM metadata via the APPS synonym), which stores the actual assigned values across all levels, and it correlates to FND_PROFILE_OPTIONS (also accessed through a synonym) to validate that the profile option is currently active. The view text joins the two objects with an EXISTS subquery on APPLICATION_ID and PROFILE_OPTION_ID, then applies date-range predicates against START_DATE_ACTIVE and END_DATE_ACTIVE in FND_PROFILE_OPTIONS. The date logic uses TRUNC(SYSDATE) adjusted by a fraction of a day (0.000011574, approximately one second) to avoid boundary effects around midnight. A final ORDER BY sorts output by PROFILE_OPTION_ID and APPLICATION_ID.

Key Columns

  • APPLICATION_ID — Identifier of the application owning the profile option; combines with PROFILE_OPTION_ID to uniquely locate the option.
  • PROFILE_OPTION_ID — Surrogate key of the profile option definition.
  • PROFILE_OPTION_VALUE — The value assigned to the profile option at the Server Responsibility level.
  • LEVEL_VALUE — The context value at the current level, typically the responsibility identifier.
  • LEVEL_VALUE_APPLICATION_ID — Application context associated with the level value, used in hierarchical level matching.
  • LEVEL_VALUE2 — The secondary context value, which for Server Responsibility rows generally carries the server or host identifier. This is the column most often searched by administrators investigating server-scoped assignments.

Common Use Cases and Queries

Typical uses include auditing which responsibilities carry a specific profile setting on a particular server, comparing configurations between environments, and troubleshooting behavior differences reported by users on different nodes. The following query returns all Server Responsibility assignments for a given profile option:

SELECT application_id,
       profile_option_id,
       level_value,
       level_value_application_id,
       level_value2,
       profile_option_value
FROM   apps.fnd_profile_values_servresp_v
WHERE  profile_option_id = :p_profile_option_id
ORDER  BY level_value, level_value2;

A second common pattern lists all such assignments containing a specific server value in LEVEL_VALUE2:

SELECT profile_option_id,
       level_value,
       profile_option_value
FROM   apps.fnd_profile_values_servresp_v
WHERE  level_value2 = :p_server_name;

Because the view applies the active-date filter internally, consumers do not need to repeat the START_DATE_ACTIVE and END_DATE_ACTIVE logic, which reduces the risk of returning expired or future-dated profile option definitions.