·
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.
Refer the blog post for Complete OM setups
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
