Search Results jtf_brm_wf_attr_values




Overview
Explore in AI Chat

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:

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.