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


*/