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 JULY 10, 2017

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

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.

 

Note also applies to formats that were seeded in R11i, but not seeded in R12 (obsoleted). 

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms