R12/CE: Upgrade How To Create R12 Payment Documents From 11i Data (Doc ID 1553752.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Cash Management - Version 12.0.0 to 12.2.6 [Release 12 to 12.2]
Information in this document applies to any platform.

Goal

When upgrade is done Custom Format documents are not migrated from 11i to R12:

1).Custom Payment Documents
2). Wire and Telegraphic Transfer Payment documents are not migrated from 11i to R12.1.3 after upgrade.
3). Others

These payment documents (ap_checks_stocks_all) had custom payment formats assigned to them. 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.

How to Create R12 Payment Documents from 11i Data?
 

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