You are browsing the archive for order management.

OM Transaction Types Setup


Form Application: Oracle Order Management
Form Name:  OEXDTTYP
Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/ont/12.0.0/forms/US/OEXDTTYP.fmx

Transaction types are used to differentiate different types of sales orders. It will have sales order header and line level workflows that control the steps in a sales order cycle. Apart from this transaction types also contain the additional information that will default to sales orders. Transaction types are operating Unit specific.

Transaction Types Setup - Oracle Order Management
Order Management Transaction Types control the different steps in a life cycle of sales order. Oracle Transactions types are mapped to Oracle workflow that controls the process steps. Transactions types are assigned to Sales Orders when entered.
For detailed tutorial on how to setup OM Transaction Types visit at


Navigation: Login to Oracle Apps -> Select Order Management responsibility -> Setup

  • Navigate to  Transaction Types -> Define
  • Query any transaction type to modify or enter transaction type to setup
    • Enter the Transaction type Header details
    •     Enter the Transaction type Name
    •     Enter the Transaction type description
    •     Sales document type
    •     Order Category
    •     Transaction Type Code
    •     Fulfillment Flow
    •     Negotiation Flow
    •     Effective Dates
    •     Default transaction phase
  • Click on ‘Approvals’ to attach Approval List
  • Enter ‘Main’ tab details
    •     Agreement type
    •     Agreement required
    •     Purchase order required
    •     Default return line type
    •     Default order line type
    •     Enforce list price
    •     Price list
    •     Minimum margin percent
    •     Credit check rules for ordering, Packing, Picking/Purchase release and Shipping
  • Enter ‘Shipping’ tab details
    •     Warehouse
    •     Shipment priority
    •     FOB
    •     Demand Class
    •     Inspection required
    •     Line Set
    •     Freight Terms
    •     Shipping Source type
    •     Scheduling level
    •     Auto schedule
    •     Fulfillment set
  • Enter ‘Finance’ tab details
    •     Invoicing Rule
    •     Accounting Rule
    •     Invoice Source
    •     Non Delivery Invoice source
    •     Credit method for invoices with rules, split term invoices
    •     Receivables transaction type
    •     Cost Of Goods Sold Account
    •     Conversion Type
    •     Tax Event
    •     Currency
  • Click on ‘Assign Line Flows’
    • Enter line type, item type, workflow process name, start date and end date

Save the changes

Book Sales Order


Form Application: Order Management
Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/ont/12.0.0/forms/US/OEXOEORD.fmx

When sales order is created it will be ‘ENTERED’ status, allowing sales rep to complete all the necessary order details, once sales order is ready you can BOOK the sales order. While you can still do the changes to sales even after BOOKING, but booking confirms that sales order is good condition for fulfillment. BOOKING sales order can also do credit check, scheduling the sales order and even reserving the sales order if it is within the reservation time fence.

Book Sales Order - Oracle Order Management
Booking a sales order is done to confirm sales order is valid and ready for manufacturing and pickup. Booking a sales order can also do credit check.

For more details on how to book sales order in oracle order management visit us at


Navigation: Login to Oracle Apps -> Select Order Management responsibility -> Order Organizer

  • Enter the sales order in the order organizer
  • Click FIND to query the sales order
  • Verify the details
  • Click on BOOK ORDER button to book the sales order
  • Click OK when confirmation message ‘Order has been booked’ appears.
  • Verify that order status changed to BOOKED

Order Management R12 Enhancements

Oracle Order Management is one of the critical and most popular module for oracle e-business suite, its functionality is being enhanced in every release very significantly.
In R12 there are lot if important features added to Oracle OM.

  • Credit Card Encryption: Credit Card information is encrypted during order entry and is directly stored in central payments. The data entry for credit card fields are also masked.
  • Credit card security code: Apartment from credit card number, now credit card security code field is added for online transactions.
  • Customer Acceptance: In previous versions revenue recognition is happens in Oracle when the goods are shipped. Many customers expect revenue recognition when goods are received by customers. Customer Acceptance feature facilitates this functionality. A new action in order cycle workflow enables Customer/fulfillment acceptance.
  • Workflow Retry Exceptions: A new concurrent program introduced that will allow you to resubmit the workflow records that are in error condition.
  • Inventory Merge: Oracle Order Management enhanced to support the merging of discrete inventory & process inventory modules.
  • Mass Scheduling: Mass Scheduling concurrent program can now handle lines that failed manual exceptions.
  • Multi-Organization Access Control: In previous versions each OM responsibility is tied to an operating unit and you have to switch responsibility to enter sales orders in new operating unit. Now with MOAC feature you don’t need to switch the responsibilities. A new profile option ‘MO: Security Profile’ is introduced that will allow you to control access to one responsibility by multiple operating unit.