This content has been marked as final. Show 1 reply
You said you are writing a program to get the mismatched records right, is it a report? If so it is easier to run the report query and see the output and verify random records with front end screens.
You don't have any transactions for the PO's in your test instance?
If you still want to load records one way could be to insert records into interface tables (AP_INVOICES_INTERFACE,AP_INVOICE_LINES_INTERFACE,PO_HEADERS_INTERFACE,PO_LINES_INTERFACE,PO_DISTRIBUTIONS_INTERFACE,RCV_HEADERS_INTERFACE,RCV_LOTS_INTERFACE,RCV_TRANSACTIONS_INTERFACE etc) and run oracle import programs to get the data. This is quite big task to do as you have to do in order and debug the interface errors.