Oracle R12 Order Management – Order Import

Oracle R12 Order Management – Order Import

Order Import:

Order Import is an open interface that can import new, change and completed sales orders or returns from other third party applications such as a legacy system. It can also import cancelled, closed and booked orders. 

Concurrent Program: Order Import

Order Import is a tool in Oracle Apps to quickly create new, change and completed Sales Orders or Returns from the below
1. Legacy Systems

2. EDI Gateway transactions

3. Other EBS applications like purchasing, contracts etc.

4. Other front end applications (web based, 3^rd party)

5. Order Import Interface consists of Open Interface tables.

Order Import features include validation and defaulting, processing constraint checks, applying and releasing of order holds, scheduling of shipments, then ultimately inserting, updating or deleting the Orders in the base Order Management tables. Order Management checks all the data during the import process to ensure its validity within Order Management. Valid transactions are then converted into Orders with Lines, Reservations, Price Adjustments, and Sales Credits in the base Order Management tables.

Order Import enables to import the Sales Orders into Oracle Applications instead of manual entry.

Order Import Pre-requisites Setups:

1. Order Management setup

2. Customer creation with bill to and ship to address

3. Price list setup

4. Item creation

5. Define order import source

6. Payment terms setup

7. Currency & conversion rate setup

Order Import Interface Tables:

oe_headers_iface_all

oe_lines_iface_all

oe_price_adjs_iface_all

oe_price_atts_iface_all

oe_customer_info_iface_all

oe_credits_iface_all

oe_lotserials_iface_all

oe_reservtns_iface_all

oe_actions_iface_all

Order Import Features:
1. Contains status of imported orders and workflow

2. Used for Order Cancellation

3. Used for updating the existing orders

4. To Import the closed orders

5. To add customers

6. To Import Price Adjustments

7. To Import Returns

8. To check Payment term comparison (with customer terms)

9. Credit Checking, holds and releases

10. Notes and Attachments

11. Data Validation

12. Defaulting rules

13. Checks the Processing constraints rules

14. Checks the Customer item number