Search Results jtf_brm_wf_attr_values_n2

Overview

JTF.JTF_BRM_WF_ATTR_VALUES is a seed-data table in the Oracle E-Business Suite JTF (Application Technology / CRM Foundation) schema that stores the workflow process attribute values associated with Business Rule Monitor (BRM) rules. For every Workflow process linked to a Business Rule, this table holds the attribute values that must be supplied to that process. The attributes themselves are defined on the workflow process level, and this table captures the concrete values bound to those attribute definitions. Its physical deployment uses the APPS_TS_SEED tablespace, consistent with its role as configuration and seed metadata rather than high-volume transactional data.

Under the Data Vault classification heuristic mined from the foreign-key structure, this object is satellite-leaning. It depends on parent entities (notably JTF_BRM_PROCESSES via PROCESS_ID), carries its own surrogate key, and stores descriptive attribute payloads. In a formal Data Vault model it is best treated as a satellite attached to the Business Rule Monitor process hub, with PROCESS_ID serving as the link to the parent hub and the value columns acting as descriptive attributes.

Key Information Stored

The table is documented with 33 columns. The most significant columns and their roles are outlined below.

• WF_ATTR_VALUE_ID — The surrogate primary key (JTF_BRM_WF_ATTR_VALUES_PK), a system-generated unique identifier for each workflow attribute value row. It is also the single-column unique index JTF_BRM_WF_ATTR_VALUES_U1. Note that although this index is a business-key candidate by uniqueness, the column is purely a surrogate and carries no business meaning.
• PROCESS_ID — The foreign key identifying the Business Rule Monitor process (JTF_BRM_PROCESSES) for which the attributes are defined. This is the principal join column and is indexed by the non-unique index JTF_BRM_WF_ATTR_VALUES_N1.
• WF_ITEM_TYPE — The Workflow item type for which the attributes are defined; indexed non-uniquely by JTF_BRM_WF_ATTR_VALUES_N2.
• WF_ACTIVITY_NAME and WF_ACTIVITY_VERSION — The Workflow activity and its version for which the attribute is defined.
• WF_ACTIVITY_ATTRIBUTE_NAME — The name of the Workflow activity attribute receiving the value.
• TEXT_VALUE, NUMBER_VALUE, DATE_VALUE — Typed value columns holding the attribute's value as text (VARCHAR2(4000)), number, or date respectively. Exactly one is normally populated depending on the attribute's datatype.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing multi-org / security-group isolation within the shared schema.
• OBJECT_VERSION_NUMBER — The optimistic locking column used by the framework for row-level concurrency control.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO auditing columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield (DFF) segments supporting extensibility.

Common Use Cases and Queries

The table is primarily interrogated during Business Rule Monitor configuration review, workflow troubleshooting, and migration validation. Common scenarios include listing all attribute values for a given Business Rule process, or resolving a workflow item type's configured attributes.

SELECT a.wf_attr_value_id, a.wf_activity_name,
       a.wf_activity_attribute_name,
       a.text_value, a.number_value, a.date_value
FROM   jtf.jtf_brm_wf_attr_values a
WHERE  a.process_id = :process_id;

A second pattern resolves values by workflow item type and activity:

SELECT a.wf_activity_attribute_name,
       NVL(a.text_value, TO_CHAR(a.number_value)) value
FROM   jtf.jtf_brm_wf_attr_values a
WHERE  a.wf_item_type = :item_type
AND    a.wf_activity_name = :activity;

Because attribute payload is spread across three typed columns, reporting queries should coerce the appropriate column based on the resolved attribute datatype. The unique index JTF_BRM_WF_ATTR_VALUES_U1 on WF_ATTR_VALUE_ID guarantees that each value row is addressable by a single stable surrogate.

Related Objects

• JTF.JTF_BRM_PROCESSES — Referenced by PROCESS_ID; the parent process definition for each attribute value.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID; governs security-group visibility.
• JTF.JTF_BRM_WF_ATTR_VALUES_PK — The primary key constraint backing WF_ATTR_VALUE_ID.
• Indexes JTF_BRM_WF_ATTR_VALUES_U1 / _N1 / _N2 — The unique and non-unique access paths on WF_ATTR_VALUE_ID, PROCESS_ID, and WF_ITEM_TYPE respectively.
• WF_ACTIVITIES / WF_ITEM_TYPES — Workflow metadata referenced logically via the WF_ITEM_TYPE, WF_ACTIVITY_NAME, and WF_ACTIVITY_VERSION columns.
• FND_USER — Per the WHO columns, the source of CREATED_BY and LAST_UPDATED_BY.