Sales Order Conversion

Hi , recently I have done SO conversion, I like to share my knowledge...

This is only Psudeo Code and I hope this is helpfull...

before starting the sales order conversion we have know the some of the basic concepts.

STEP-1:
we have to create the staging tables  for sales order headers and order lines based on your data template.
after that we have to move the data by using the SQL * Loader or Direct TOAD.
once moving the data from flat file to staging tables.

STEP-2:
Creating the package in that we have to create two procedures, one is for validations and one for Loading
please find some of the validations in Sales order conversion.

-->Validate Customer Name
-->alidate Site BILL/SHIP Location
-->Customer Po number
-->Validate Operating unit
-->Validate Price List
-->Validate Order Type
-->validate Payment type
-->validate Organization Code
-->validate Currency on Order
-->validate Freight Terms
-->validate Sales Person Name
-->validate Conversion Type
-->Item Number
-->alidate UOM code


once all validations done in validation procedure same time all id's updated to staging tables after that
running the loading program the data is moving to the interface tables.
once the below interface tables are updated.

INTERFACE TABLES:

oe_headers_iface_all
oe_lines_iface_all

STEP-3

in the 3rd step we have to run the Order Import Program same time child program also running once the
status is completed normal after that checking the base tables in back end and same time we will see the
front end applications also. just we will  pass the sales order number and query.

Base Tables:

Oe_order_headers_all
Oe_order_lines_all.

Thanks a lot ......if we have any quires just give me comment...........