R12:AP/IBY:11i Payment Documents Do not Exist in R12--How to create the payment documents from 11i data (Doc ID 549024.1)

Last updated on DECEMBER 10, 2024

Applies to:

Goal

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.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.