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
1. Legacy Systems
2. EDI Gateway transactions
3. Other EBS applications like purchasing, contracts etc.
4. Other front end applications (web based, 3rd
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
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
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
Nice work...Keep it up bro
ReplyDeleteThanks for sharing your experience with us. Its really helpful to every body who is planning to move their vehicles to other states.
ReplyDeleteOrder Management System