Results for “oke_hold_statuses_b”

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

Overview

WF_ITEM_TYPES is a core Oracle Workflow definition table residing in the APPLSYS schema and associated with the FND – Application Object Library product. It stores the master registry of Workflow item types, which are the top-level categories that group related items, attributes, activities, messages, and routing rules into a coherent business process. Every Workflow-enabled transaction in Oracle E-Business Suite — whether an order hold, a service request, a repair order, or an approval — is anchored to an item type defined in this table. The table is therefore foundational to the Oracle Workflow engine and to the many application modules that embed workflow functionality.

From a dimensional modeling perspective, the FK topology mined from the schema classifies WF_ITEM_TYPES as a hub: it holds a stable, non-volatile key (the item type name) that is referenced by numerous dependent tables, without itself being a transactional or link entity. This suggests treating WF_ITEM_TYPES as a reference hub when building a Workflow data vault, with surrounding satellite tables capturing descriptive and status attributes.

Key Information Stored

The table contains 17 documented columns. The most significant include:

• NAME – The business identifier of the item type; the first component of the primary key WF_ITEM_TYPES_PK.
• ZD_EDITION_NAME – The editioning column introduced in EBS 12.2; the second component of the unique index WF_ITEM_TYPES_PK.
• PROTECT_LEVEL and CUSTOM_LEVEL – Control whether the definition may be modified or customized by customers versus being locked by Oracle.
• WF_SELECTOR – The selector function used for dynamic item type routing.
• READ_ROLE, WRITE_ROLE, EXECUTE_ROLE – Role-based access controls governing who can read, modify, or execute the item type.
• PERSISTENCE_TYPE and PERSISTENCE_DAYS – Determine how long completed workflow items are retained before purging.
• SECURITY_GROUP_ID – Foreign key to FND_SECURITY_GROUPS, scoping the item type to a security group.
• NUM_ACTIVE, NUM_ERROR, NUM_DEFER, NUM_SUSPEND, NUM_COMPLETE, NUM_PURGEABLE – Runtime counters summarizing the population of workflow items in each state.

The surrogate key is WF_ITEM_TYPES_PK, composed of NAME and ZD_EDITION_NAME; NAME alone serves as the primary business-key candidate.

Common Use Cases and Queries

Typical usage includes auditing workflow item type definitions, identifying high-error or suspended item types, and verifying customization protections before patching. A representative query lists item types with their runtime counts:

• SELECT name, persistence_type, num_active, num_error, num_suspend FROM wf_item_types ORDER BY num_error DESC;
• Joining to status tables to trace active items: SELECT i.item_type, i.item_key, i.begin_date FROM wf_items i, wf_item_types t WHERE i.item_type = t.name AND t.num_active > 0;
• Verifying protection and customization levels prior to upgrade: SELECT name, protect_level, custom_level FROM wf_item_types WHERE custom_level > 0;

Related Objects

WF_ITEM_TYPES is referenced by many dependent tables through the ITEM_TYPE or equivalent column:

• WF_ITEMS.ITEM_TYPE – individual workflow item instances.
• WF_ACTIVITIES.ITEM_TYPE – activity definitions within each item type.
• WF_ITEM_ATTRIBUTES.ITEM_TYPE – attribute definitions.
• WF_MESSAGES.TYPE and WF_ROUTING_RULES.MESSAGE_TYPE – notification and routing configuration.
• WF_LOOKUP_TYPES_TL.ITEM_TYPE – translatable lookup definitions.
• OE_HOLD_DEFINITIONS.ITEM_TYPE – order management hold workflows.
• OKE_CHG_LOGS.WF_ITEM_TYPE, OKE_CHG_STATUSES_B.WF_ITEM_TYPE, OKE_HOLD_STATUSES_B.WF_ITEM_TYPE – project contract change and hold statuses.
• CSD_REPAIR_TYPES_B.WORKFLOW_ITEM_TYPE and CSS_DEF_PROB_CATEGORIES_B.WORKFLOW – service and depot repair workflows.
• JTF_UM_APPROVALS_B.WF_ITEM_TYPE – user management approvals.

The table itself references FND_SECURITY_GROUPS via SECURITY_GROUP_ID.