Oracle Order Management Item Orderability rule in R12

There is a new interface provided by oracle to define rules to restrict certain kind of items to be ordered based on certain rules / criteria.

Example:

Customer A may purchase all items except for repair items and promotional items.

Alternatively, Customer B buys only repair parts but is restricted from buying promotional items.

How to generate a debug file in Order Management

A. To generate a debug file from the Sales Orders form:

1. Set the following profile options:
   OM: Debug Level - set to 5
   OM: Debug Log Directory - any directory that can be written to by the database
   

To check, run the following SQL statement:

Code:

select value from v$parameter where name = 'utl_file_dir'

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

Interfaces and Conversions in Oracle Applications

I have consolidated all the interfaces and conversions in oracle applications.