Order Import Interface

Order Import Interface (Sales Order Conversion)

 

          Interface tables:

·         OE_HEADERS_IFACE_ALL        

·         OE_LINES_IFACE_ALL                               

·         OE_ACTIONS_IFACE_ALL                           

·         OE_ORDER_SOURCES                      

·         OE_CUSTOMER_INFO_IFACE_ALL       

·         OE_PRICE_ADJS_IFACE_ALL    

·         OE_PRICE_ATTS_IFACE_ALL

         

          Base tables:  

·         OE_ORDER_HEADERS_ALL         

·         OE_ORDER_LINES_ALL

          Pricing tables          

·         QP_PRICING_ATTRIBUTES

 

          During import of orders, shipping tables are not populated.

 

If importing customers together with the order, OE_ORDER_CUST_IFACE_ALL

Base Tables: HZ_PARTIES    HZ_LOCATIONS

 

Orders can be categorized based on their status:

                   1. Entered orders              

2. Booked orders               

3. Closed orders

                  

Concurrent Program: Order Import

 

Validations:

·         Check for sold_to_org_id. If does not exist, create new customer by calling create_new_cust_info API.

·         Check for sales_rep_id. Should exist for a booked order.

·         Ordered_date should exist. -------- header level

·         Delivery_lead_time should exist. ----------- line level

·         Earliest_acceptable_date should exist.

·         Freight_terms should exist

 

Order Import API    OE_ORDER_PUB.GET_ORDER, PROCESS_ORDER

 

          Concurrent programs will in turn call APIs.

          2 APIs are called during order import process.

·         OE_CNCL_ORDER_IMPORT_PVT (cancelled orders)                    

·         ORDER_IMPORT_PRIVATE

          Procedure: import_order()