Search Results jtf_brm_wf_attr_values_pk

Overview

JTF_BRM_WF_ATTR_VALUES is a transactional configuration table within the JTF (CRM Foundation) product family of Oracle E-Business Suite. Its documented purpose is to store Workflow attribute values for each process defined in the CRM Foundation workflow framework. In the Oracle EBS architecture, this table functions as a metadata store that binds Oracle Workflow activity attributes to specific process definitions maintained in JTF_BRM_PROCESSES, allowing administrators and developers to parameterize workflow-driven business logic without modifying the underlying workflow definitions.

From a heuristic Data Vault modeling perspective, the table is classified as satellite-leaning. This classification reflects its structural role: the object carries descriptive, version-like attributes attached to a parent process entity via a foreign key, which is characteristic of satellite data. It is not a pure hub or link, although its PROCESS_ID foreign key does establish a many-to-one dependency on the parent process record.

Key Information Stored

The table contains 33 documented columns in the ETRM 12.2.2 physical schema. The most significant columns are the following:

• WF_ATTR_VALUE_ID — The surrogate primary key of the table, sourced from the sequence-backed primary key constraint JTF_BRM_WF_ATTR_VALUES_PK. This column also appears in the unique index JTF_BRM_WF_ATTR_VALUES_U1, making it the definitive business-key candidate for row identification.
• PROCESS_ID — Foreign key reference to JTF_BRM_PROCESSES, identifying the CRM Foundation process to which this attribute value belongs.
• WF_ITEM_TYPE — The Oracle Workflow item type associated with the attribute value.
• WF_ACTIVITY_NAME — The specific workflow activity name within the item type.
• WF_ACTIVITY_VERSION — The version of the workflow activity, permitting version-specific configuration.
• WF_ACTIVITY_ATTRIBUTE_NAME — The name of the workflow activity attribute being configured.
• TEXT_VALUE, NUMBER_VALUE, DATE_VALUE — Typed value columns that store the actual attribute setting in character, numeric, or date form respectively.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting multi-tenant or security-group partitioning of the configuration data.
• OBJECT_VERSION_NUMBER — Optimistic locking column used to detect concurrent updates.
• APPLICATION_ID — Identifies the owning Oracle EBS application.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The standard Oracle EBS descriptive flexfield (DFF) columns used for extensibility.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns present on most EBS transactional tables.

Common Use Cases and Queries

Typical usage centers on diagnosing and tuning workflow-driven CRM processes. A common query joins the attribute values back to their parent process to list all configured attributes for a given process name:

• Process configuration audit: SELECT p.process_name, a.wf_item_type, a.wf_activity_name, a.wf_activity_attribute_name, a.text_value, a.number_value FROM jtf_brm_processes p, jtf_brm_wf_attr_values a WHERE p.process_id = a.process_id;
• Activity parameter lookup: Retrieve the value bound to a specific activity attribute: SELECT * FROM jtf_brm_wf_attr_values WHERE wf_item_type = :item_type AND wf_activity_name = :activity AND wf_activity_attribute_name = :attr_name;
• Security-group scoped reporting: Filter rows by SECURITY_GROUP_ID where multi-org or security partitioning is enforced.
• Change tracking: Use LAST_UPDATED_BY and LAST_UPDATE_DATE to report on recent configuration changes for SOX or audit purposes.

Related Objects

• JTF_BRM_PROCESSES — Parent entity; joined on JTF_BRM_WF_ATTR_VALUES.PROCESS_ID = JTF_BRM_PROCESSES.PROCESS_ID. This is the primary documented foreign key relationship.
• FND_SECURITY_GROUPS — Joined on JTF_BRM_WF_ATTR_VALUES.SECURITY_GROUP_ID = FND_SECURITY_GROUPS.SECURITY_GROUP_ID, providing security-group context.
• JTF_BRM_WF_ATTR_VALUES_PK — Primary key constraint on WF_ATTR_VALUE_ID.
• JTF_BRM_WF_ATTR_VALUES_U1 — Unique index on WF_ATTR_VALUE_ID, serving as the documented business-key candidate.
• Oracle Workflow (WF_ITEM_TYPES, WF_ACTIVITIES) — While not a formal FK in the metadata, the WF_ITEM_TYPE, WF_ACTIVITY_NAME, and WF_ACTIVITY_VERSION columns logically reference Oracle Workflow definition tables for resolution of activity metadata.