R12: AP: Upgrade: AP_INV_SELECTION_CRITERIA_ALL.PAYMENT_METHOD_CODE (Doc ID 2199271.1)

Last updated on NOVEMBER 21, 2016

Applies to:

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

Goal

On : 12.1.3 version, Setup Related Issues


AP_INV_SELECTION_CRITERIA_ALL.PAYMENT_METHOD_CODE as of 11i doesn't pass to R12.13 and that field becomes null for all records.

For below tables, PAYMENT_METHOD_LOOKUP_CODE and PAYMENT_METHOD_CODE got synched up.
AP_CHECKS_ALL
AP_INVOICES_ALL
AP_PAYMENT_SCHEDULES_ALL

 

This is reproducible in our internal support upgrade test environment.
for example) After the upgrade, AP_INV_SELECTION_CRITERIA_ALL.PAYMENT_METHOD_CODE is null for all records
[Support instance]
------------------------------
SQL> select count(*) from AP_INV_SELECTION_CRITERIA_ALL;
COUNT(*)
----------
191

SQL> select count(*) from AP_INV_SELECTION_CRITERIA_ALL where PAYMENT_METHOD_CODE is null;
COUNT(*)
----------
191
------------------------------

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