Search Results jtf_rs_resource_params_pk

Overview

JTF_RS_RESOURCE_PARAMS is a CRM Foundation (JTF) table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the definition of resource parameters used by the Resource Manager infrastructure. It functions as the metadata catalogue that describes the attributes, groupings, and lookups that can be associated with resources maintained in JTF_RS_RESOURCE_VALUES. The primary key is RESOURCE_PARAM_ID, and the table is owned by the JTF schema with a status of VALID.

From a Data Vault modeling perspective, the mined foreign-key structure suggests a hub-leaning classification: RESOURCE_PARAM_ID behaves as a durable business key representing an individual parameter definition, while the descriptive and auditing attributes (NAME, TYPE, LENGTH, DOMAIN_LOOKUP_TYPE, PARAM_TYPE, and the ATTRIBUTE1–15 flex columns) are satellite-like in nature. This classification is a heuristic suggestion derived from the FK topology rather than a mandated physical design.

Key Information Stored

The table contains 31 documented columns. The most significant are:

• RESOURCE_PARAM_ID — surrogate primary key, enforced by JTF_RS_RESOURCE_PARAMS_PK and also part of unique index U1.
• NAME — business name of the parameter; participates in unique index U2 alongside APPLICATION_ID and PARAM_TYPE.
• PARAM_TYPE — the parameter category; a business-key candidate in U2.
• APPLICATION_ID — owning application context; a business-key candidate in U2.
• TYPE and LENGTH — data type and size metadata for the parameter value.
• DOMAIN_LOOKUP_TYPE — lookup type used to validate or render the parameter.
• OBJECT_VERSION_NUMBER — optimistic locking column used by OAF/ADF-based pages.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting multi-org and data-security filtering.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield columns for customer extensions.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.
• ZD_EDITION_NAME — editioning column used for Online Patching (AD_ZD) in 12.2.x.

The surrogate key RESOURCE_PARAM_ID is distinct from the business-key candidates exposed through unique indexes JTF_RS_RESOURCE_PARAMS_U1 (RESOURCE_PARAM_ID, ZD_EDITION_NAME) and JTF_RS_RESOURCE_PARAMS_U2 (APPLICATION_ID, PARAM_TYPE, NAME, ZD_EDITION_NAME).

Common Use Cases and Queries

Typical scenarios include enumerating parameter definitions for a given application or parameter type, resolving parameter names to IDs for joins with JTF_RS_RESOURCE_VALUES, and reporting on lookup-driven parameters used in resource setup and qualification flows.

• Enumerate parameters for an application: SELECT resource_param_id, name, param_type FROM jtf_rs_resource_params WHERE application_id = :app_id;
• Resolve by business key: SELECT resource_param_id FROM jtf_rs_resource_params WHERE application_id = :app AND param_type = :type AND name = :name;
• Join parameter definitions to assigned values: SELECT p.name, v.value FROM jtf_rs_resource_params p, jtf_rs_resource_values v WHERE p.resource_param_id = v.resource_param_id;
• Inspect flexfield extensions: query ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 for customer-specific configuration.
• Filter by security context using SECURITY_GROUP_ID when reporting across organizations.

Because the table is metadata rather than transactional, volumes are typically low and queries are used primarily for validation, configuration reporting, and troubleshooting resource setup issues.

Related Objects

• JTF_RS_RESOURCE_VALUES — principal child table; JTF_RS_RESOURCE_VALUES.RESOURCE_PARAM_ID references JTF_RS_RESOURCE_PARAMS, linking parameter definitions to the resource values actually assigned.
• FND_SECURITY_GROUPS — referenced by JTF_RS_RESOURCE_PARAMS.SECURITY_GROUP_ID for data-security grouping.
• FND_APPLICATION — logical reference for APPLICATION_ID, identifying the owning application of each parameter.
• FND_LOOKUP_TYPES / FND_LOOKUP_VALUES — source of the lookup referenced by DOMAIN_LOOKUP_TYPE.
• JTF_RS_RESOURCE_PARAMS_PK, _U1, _U2 — primary and unique indexes enforcing identity and uniqueness.

These relationships should be exercised with the documented join columns to preserve integrity when extending or reporting on resource parameter configuration.