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 Managementshould 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