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.

Order Management Setups - Transaction Type Definition

·         Transaction Types / Order types are used to associate workflows for various phases of sales document processing.

·         Transaction Types can be used to create various order types like Standard Order, Return etc., and associate them to various sales document types like Quotes, Sales Agreement etc.

·         Transaction Types have to defined for each operating unit.

Order type details are stored in the following table:

         select * from apps.oe_transaction_types_tl

         where transaction_type_id=oe_order_headers_all.order_type_id