Results for “number_default”

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

Overview

WF_ACTIVITY_ATTRIBUTES is a core configuration table owned by the APPLSYS schema within the FND - Application Object Library product of Oracle E-Business Suite. As its description states, the table "Defines attributes for activities" — it stores the descriptive and behavioral metadata that governs how individual workflow activities behave at runtime. Every activity defined in the Oracle Workflow engine may carry one or more typed attributes (such as format masks, default values, subtypes, and protection levels) that control how that activity is presented, invoked, and customized within a business process. WF_ACTIVITY_ATTRIBUTES is therefore fundamental to the Workflow configuration layer and is referenced heavily by the Workflow Builder and the runtime Workflow Engine when resolving activity definitions. Users interested in "wf_activity_attributes" are typically troubleshooting workflow behavior, reverse-engineering a seeded activity, or building custom attribute defaults.

From a Data Vault modeling perspective, the FK structure suggests this object is satellite-leaning: its primary key combines the parent business keys (ACTIVITY_ITEM_TYPE, ACTIVITY_NAME, ACTIVITY_VERSION) with a descriptive NAME discriminator, and it carries descriptive attributes (TYPE, VALUE_TYPE, FORMAT, defaults, etc.) rather than acting as a standalone hub or pure link.

Key Information Stored

WF_ACTIVITY_ATTRIBUTES contains 16 documented columns. The most significant are:

• ACTIVITY_ITEM_TYPE, ACTIVITY_NAME, ACTIVITY_VERSION — the composite foreign key identifying the parent activity in WF_ACTIVITIES. Together they anchor every attribute row to a specific activity version.
• NAME — the attribute's name; combined with the three activity columns, it forms the business-key candidate in the primary key WF_ACTIVITY_ATTRIBUTES_PK, alongside ZD_EDITION_NAME.
• SEQUENCE — ordering of the attribute within the activity definition.
• TYPE — the attribute classification (e.g., default value, format, or runtime parameter type).
• VALUE_TYPE — the data type of the attribute value (text, number, date, boolean).
• SUBTYPE — additional classification used to distinguish attribute variants.
• PROTECT_LEVEL and CUSTOM_LEVEL — protection and customization levels, controlling who may modify the attribute (for example, protecting Oracle-seeded values from customer edits).
• FORMAT — display or formatting mask applied to the attribute value.
• TEXT_DEFAULT, NUMBER_DEFAULT, DATE_DEFAULT — type-specific default values applied when the attribute is not otherwise supplied.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enabling row-level security partitioning across the EBS data model.

The primary key is WF_ACTIVITY_ATTRIBUTES_PK; note that the physical unique index includes ZD_EDITION_NAME, which supports the editioning feature introduced in EBS 12.2.

Common Use Cases and Queries

Typical scenarios include auditing the attribute configuration of a seeded or custom workflow activity, investigating why an activity behaves unexpectedly (wrong default or format), and reporting on customization levels to identify customer-modified attributes prior to an upgrade. A sample query retrieving attributes for a specific item type:

• SELECT a.NAME, a.TYPE, a.VALUE_TYPE, a.CUSTOM_LEVEL FROM WF_ACTIVITY_ATTRIBUTES a WHERE a.ACTIVITY_ITEM_TYPE = :item_type AND a.ACTIVITY_NAME = :activity;
• Join to WF_ACTIVITIES on ACTIVITY_ITEM_TYPE, ACTIVITY_NAME and ACTIVITY_VERSION to display the parent activity display name alongside its attributes.
• Join to FND_SECURITY_GROUPS via SECURITY_GROUP_ID to resolve the owning security group where row-level security is enforced.
• Join to WF_ACTIVITY_ATTRIBUTES_TL on the composite activity key and NAME to obtain translated attribute display text.

Related Objects

The following objects are the most significant dependencies based on the documented FK relationships:

• WF_ACTIVITIES — the parent activity table; joined on ACTIVITY_ITEM_TYPE, ACTIVITY_NAME, and ACTIVITY_VERSION.
• WF_ACTIVITY_ATTRIBUTES_TL — the translation table, referencing WF_ACTIVITY_ATTRIBUTES on the composite activity key plus NAME.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for security partitioning.
• WF_ITEM_ATTRIBUTES — the runtime instance-level counterpart storing attribute values for executing workflow items.
• WF_ACTIVITIES_TL — translations for the parent activity definitions.