Oracle Workflows in Order Management

Oracle Workflows in Order Management

• Oracle Order Management uses Oracle Workflow to control the sequence of events that occur in the processing of orders, quotes, sales agreements, returns, order lines, and return lines.
• Oracle Workflow manages activities, executes functions, sends notifications, maintains completed activity history, detect errors, and initiates error processes.
• Oracle Order Management seeded workflows and their associated activities are contained in oexwford.wft file.

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,

oe_order_lines_all c

WHERE a.process_activity = b.instance_id

AND b.process_item_type = 'OEOL'

AND b.activity_name = <‘Activity_Name’>

AND activity_status = 'COMPLETE'

AND item_key = TO_CHAR (c.line_id)

AND c.header_id = pin_order_header_id