Search Results jtf_rs_resource_values




Overview
Explore in AI Chat

Overview

JTF_RS_RESOURCE_VALUES is a CRM Foundation (JTF) table within Oracle E-Business Suite that stores attribute or parameter values associated with resources. In the resource management model, a resource represents a person, group, party, or organizational entity that can be assigned to service requests, tasks, and other CRM activities. The JTF_RS_RESOURCE_EXTNS table captures the core resource definition, while the related parameter tables extend that definition with flexible, name-value style metadata. JTF_RS_RESOURCE_VALUES serves as the storage point for the actual parameter values, with RESOURCE_PARAM_VALUE_ID acting as the primary key.

The table is present and valid in both Oracle EBS 12.1.1 and 12.2.2, and the documented physical schema in 12.2.2 contains 28 columns owned by the JTF schema. The ETRM relationship metadata classifies this object heuristically as a link table. As a modeling suggestion, this classification reflects its position as a connector between resource definitions and resource parameter definitions, with each row representing an occurrence of a parameter value for a given resource.

Key Information Stored

The most significant columns documented for this table include:

The business-key candidate unique index JTF_RS_RESOURCE_VALUES_U2 (RESOURCE_ID, RESOURCE_PARAM_ID, VALUE_TYPE) is especially important, as it enforces the uniqueness rules that govern how many values can be stored per resource and parameter combination.

Common Use Cases and Queries

Typical use cases involve retrieving all parameter values for a resource, joining values to their parameter definitions for descriptive reporting, or validating that a resource carries a required parameter. A representative join pattern is:

  • SELECT v.resource_param_value_id, v.resource_id, v.resource_param_id, p.parameter_name, v.value, v.value_type FROM jtf_rs_resource_values v, jtf_rs_resource_params p WHERE v.resource_param_id = p.resource_param_id AND v.resource_id = :resource_id;
  • Reporting by security context: filter on v.security_group_id to respect the active security group when querying across organizations.
  • Extracting flexfield content: select attribute_category and attribute1..attribute15 when the parameter values are used to drive extensible CRM attributes.

Because the table stores values rather than reference data, most custom SQL against it will be read-only reporting or diagnostic in nature; direct DML should generally be performed through the supported JTF resource APIs that write both JTF_RS_RESOURCE_EXTNS and this table consistently.

Related Objects

The following objects are the most significant dependencies of JTF_RS_RESOURCE_VALUES:

  • JTF_RS_RESOURCE_PARAMS — Referenced via JTF_RS_RESOURCE_VALUES.RESOURCE_PARAM_ID; defines each parameter.
  • JTF_RS_RESOURCE_EXTNS — Referenced via JTF_RS_RESOURCE_VALUES.RESOURCE_ID; defines each resource.
  • FND_SECURITY_GROUPS — Referenced via JTF_RS_RESOURCE_VALUES.SECURITY_GROUP_ID; provides security-group isolation.
  • JTF_RS_RESOURCE_VALUES_PK / JTF_RS_RESOURCE_VALUES_U1 / JTF_RS_RESOURCE_VALUES_U2 — The primary key and unique indexes enforcing row identity and business-key uniqueness.
  • The JTF resource management APIs and concurrent programs that read and write resource definitions, which depend on this table for parameter persistence.