Oracle Workflows in Order Management

The most commonly used Order header flows for outbound lines are:

• Order Flow – Generic
• Order Flow – Generic with Header Level Invoice Interface

The Order header flows for inbound lines are:

• Order Flow – return with Approval
• Order Flow – Return with Submission and Approval
• Order Flow – Return with Approval and Header Invoicing

The most commonly used Order Line flows are:

• Line Flow – Generic
• Line Flow – Generic with Header Level Invoice Interface

The Order Line flows for inbound lines are:

• Line Flow – Return for Credit Only
• Line Flow – Return for Credit Only with Approval
• Line Flow – Return for Credit with Receipt
• Line Flow – Return for Credit with Receipt and Approval

• The Transaction Type determines the header level process used at the header level on an order.
• The Transaction Type window is used to assign the order flow to the order header Transaction type.
• Use the Assign Line Flows button to assign line flows to the order header

• The combination of order type/line type/item type determines the line workflow.
• If you leave Item Type blank, the workflow applies to all item types for the line type (unless they have a specific assignment in this form).
• In Process Name, select the workflow that Oracle Order Management should use for the order type/line type/item type combination.
• If you do not assign a workflow to a configured item type, the configured item does not use a workflow.
• You can perform all standard processing including orders, returns, drop-ship orders, Orders for configured items, and orders for assemble-to-order items using seeded workflows.

Check Order line Workflow Activity Status

SELECT COUNT (1)

INTO ln_completed_lines

FROM wf_item_activity_statuses a,

wf_process_activities b,