Results for “attribute_value”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

WF_ATTRIBUTE_CACHE is a table owned by the APPLSYS schema and defined within the FND — Application Object Library product module. As described in the ETRM metadata, the table stores attribute name and attribute value pairs for entities. It functions as a persistence layer for the Oracle Workflow engine, allowing attribute values associated with workflow entities to be cached and retrieved efficiently rather than recomputed on each access. The table is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the ETRM metadata classifies this object heuristically as standalone. Under a Data Vault interpretation, the natural entity identifiers (ENTITY_TYPE and ENTITY_KEY_VALUE) combined with ATTRIBUTE_NAME could be treated as a hub-like business key construct, while ATTRIBUTE_VALUE and the audit columns behave as descriptive satellite attributes. Because the table carries no foreign keys to a parent entity table other than SECURITY_GROUP_ID, this classification remains a modeling suggestion rather than a strict architectural declaration. The three-part primary key WF_ATTRIBUTE_CACHE_PK (ENTITY_TYPE, ENTITY_KEY_VALUE, ATTRIBUTE_NAME) confirms that each entity may hold at most one value per attribute name.

Key Information Stored

The table contains seven documented columns. The most significant are as follows:

• ENTITY_TYPE — Identifies the type of workflow entity (for example, an item type) to which the cached attribute belongs. Part of the primary key and of the unique index WF_ATTRIBUTE_CACHE_U1.
• ENTITY_KEY_VALUE — The specific entity instance identifier within the given entity type. Also part of the primary key and unique index.
• ATTRIBUTE_NAME — The name of the workflow attribute being cached. Completes the composite primary key and unique index.
• ATTRIBUTE_VALUE — The stored value corresponding to the attribute name for the identified entity.
• SECURITY_GROUP_ID — Foreign key referencing FND_SECURITY_GROUPS, supporting multi-organization or security-group partitioning of cached data.
• LAST_UPDATE_DATE — Timestamp of the most recent modification, used for auditing and cache invalidation logic.
• CHANGE_NUMBER — A change-tracking identifier used by the Workflow engine to detect updates to cached records.

The surrogate primary key is WF_ATTRIBUTE_CACHE_PK, while WF_ATTRIBUTE_CACHE_U1 (ENTITY_TYPE, ENTITY_KEY_VALUE, ATTRIBUTE_NAME) serves as the documented business-key candidate on the unique index. The two definitions are functionally aligned, with the primary key additionally enforcing the uniqueness guarantee.

Common Use Cases and Queries

Typical usage centers on diagnosing workflow behavior, verifying that attributes resolve correctly for a given entity, and auditing stale cached values. A common retrieval pattern filters on the composite key:

• SELECT ATTRIBUTE_VALUE FROM WF_ATTRIBUTE_CACHE WHERE ENTITY_TYPE = :type AND ENTITY_KEY_VALUE = :key AND ATTRIBUTE_NAME = :name;
• Listing all cached attributes for an entity: SELECT ATTRIBUTE_NAME, ATTRIBUTE_VALUE FROM WF_ATTRIBUTE_CACHE WHERE ENTITY_TYPE = :type AND ENTITY_KEY_VALUE = :key;
• Detecting recently modified cache entries: SELECT * FROM WF_ATTRIBUTE_CACHE WHERE LAST_UPDATE_DATE > SYSDATE - 1;
• Reporting by security group: SELECT SECURITY_GROUP_ID, COUNT(*) FROM WF_ATTRIBUTE_CACHE GROUP BY SECURITY_GROUP_ID;

These queries support troubleshooting notifications, checking item-type attribute resolution, and reconciling cache contents against source definitions. Reporting on cache volume by entity type also assists capacity planning.

Related Objects

• FND_SECURITY_GROUPS — Referenced by the WF_ATTRIBUTE_CACHE.SECURITY_GROUP_ID foreign key; join on SECURITY_GROUP_ID.
• WF_ITEM_TYPES — Supplies the entity type context used in ENTITY_TYPE.
• WF_ITEM_ATTRIBUTES — Defines the attribute names cached in ATTRIBUTE_NAME.
• WF_ITEMS — Provides the entity instances matched by ENTITY_KEY_VALUE.
• WF_ITEM_ATTRIBUTE_VALUES — Source of transmitted values that WF_ATTRIBUTE_CACHE caches.
• WF_LOOKUP_TYPES and WF_LOOKUP_CODES — Support attribute metadata associated with cached workflows.

Together these objects form the workflow attribute ecosystem that WF_ATTRIBUTE_CACHE persists at runtime.