Search Results jtf_rs_resource_values_pk

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:

• RESOURCE_PARAM_VALUE_ID — The surrogate primary key, backed by the unique index and constraint JTF_RS_RESOURCE_VALUES_PK and the unique index JTF_RS_RESOURCE_VALUES_U1.
• RESOURCE_ID — Foreign key to JTF_RS_RESOURCE_EXTNS, identifying the resource to which these values apply. Part of the business-key candidate unique index JTF_RS_RESOURCE_VALUES_U2.
• RESOURCE_PARAM_ID — Foreign key to JTF_RS_RESOURCE_PARAMS, identifying the parameter definition. Also part of unique index JTF_RS_RESOURCE_VALUES_U2.
• VALUE — The actual stored value for the resource parameter; this is typically the payload that consuming logic reads and interprets.
• VALUE_TYPE — Indicates the type or category of the value stored. Part of the unique index JTF_RS_RESOURCE_VALUES_U2, confirming that for a given resource and parameter combination, only one row per value type is expected.
• OBJECT_VERSION_NUMBER — Supports optimistic locking and concurrency control.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enabling multi-tenant or security-group-based data isolation.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The standard EBS descriptive flexfield storage columns, providing extensibility without schema changes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — The standard EBS audit columns recording who created and last modified each row and when.

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.