PO, INV, OM INTERFACE/CONVERSION FLOW:

Purchase Order Conversion:

Import Standard Purchase Order

1. According to the data file create control file
2. then registered the control file and run the concurrent program which will load the data to temporary table.
3. wrote a package to validate the data before migrating the data to base tables.
4. Validations done are:

HEADERS

1.  supplier
2. supplier site
3. buyer
4. operating unit
5. payment terms
6. bill-to-location
7. ship-to-location
8. FOB, freight terms

LINES:

1. line type
2. item
3. ship-to-org
4. ship-to-location_id     
5. requestor 
6. delivery-to-location

After the migration need to check the duplicate records in interface tables and base tables.

Interface Tables:

po_headers_interface

po_lines_interface

po_distribution_interface 

po_interface_errors

ORDER MANAGEMENT (OM):

Order Import Interface

Order Import enables you to import Sales Orders into Oracle Applications 

Validations:

1. order_date (header level)
2. delivery_lead_time (line level)
3. earliest_acceptable_date
4. freight_terms
5. sales_rep_id
6. sold_to_org_id

API:

OE_ORDER_PUB.GET_ORDER and PROCESS_ORDER

Interface Tables:

OE_HEADERS_IFACE_ALL

OE_LINES_IFACE_ALL

Inventory (INV):

Item Import

Validation:

1. Item type
2. segment1
3. item status
4. template_id
5. uom
6. attributes
7. organization_id

MTL_SYSTEM_ITEMS_INTERFACE

MTL_ITEM_CATEGORIES_INTERFACE

MTL_ITEM_REVISIONS_INTERFACE

MTL_INTERFACE_ERRORS

MTL_SYSTEM_ITEMS_INTERFACE:

PROCESS_FLAG = 1 (1= Pending, 2= Assign Complete,3= Assign/Validation Failed, 4= Validation succeeded; Import failed, 5 = Import in Process,7 = Import succeeded)

These are the few validation I had mentioned in this document but in real time need to validate many more.......