R12:AP/IBY:11i Payment Documents Do not Exist in R12--How to create the payment documents from 11i data
Last updated on JULY 10, 2017
Applies to:Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.
Payment documents that existed in 11i (in table AP_CHECK_STOCKS_ALL) do not exist after the R12 upgrade ( table affected: CE_PAYMENT_DOCUMENTS).
There are two reasons.
1) These payment documents (ap_checks_stocks_all) had custom payment formats assigned to them in 11i. During the upgrade, custom payment formats were not upgraded to IBY_FORMATS_B. So when the CE upgrade script cebuinst.sql was run to create ce_payment_documents from ap_check_stocks_all, only those payment documents that had formats that existed in IBY_FORMATS_B were upgraded. Hence these payment documents do not exist in R12 CE_PAYMENT_DOCUMENTS table.
The document below provides solution for this issue.
2) The other reason is upgrade did not bring in payment documents related to payment method WIRE or ELECTRONIC. This is fixed in bug 12794944.
To fix this for future upgrade, apply Patch:13695167:R12.CE.B.
For existing upgraded instance, log a SR for datafix.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms