Oracle Apps Order Management - Defining Order Management Transaction Types

Overview

In prior releases of Oracle Order Entry, Order Types were used for defaulting information on orders, establishing processing controls such as invoicing, and most importantly, determining the Order Cycle that an order would have. Order Cycles, in turn, controlled the processing flow of an order.

With the release of Oracle Order Management 11i, Order Cycles have been replaced by Oracle Order Management Workflow definitions, and Order Types have been replaced by Order Management Transaction Types. Order Management provides seeded Workflow process definitions for both orders and lines, and Order Management also enables you to define both order header and Order Line transaction types.

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