Credit Card For Closed Orders Not Upgraded From 11i To R12 - How Will Refund Work? (Doc ID 2038001.1)

Last updated on SEPTEMBER 16, 2015

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Credit card data for closed orders not upgraded from 11i to R12 - How will refund work?

Problem Description
---------------------------------------------------
Credit Card Data from Order is not existing in oe_payments table.

As part of upgrade Oracle upgraded data to oe_payments table for only open orders. If the order open_flag is Y then those orders are in Oe_payments table, otherwise the data is not moved to oe_payments table.

An concurrent program Migrate Payment Data for Closed Orders to Oracle Payment exists to create the payment records for closed orders
This process the orders for which ordered date is greater than "IBY: Credit Card Data Migration Cutoff Date"

Counts taken when running the request show records are being processed , but it is taking a very long time to complete as there are many records to be processed.  Even reducing the number of records to be processed by using the IBY: Credit Card Data Migration Cutoff Date" is still leaving a large number of records to be processed.  So need to see if the performance of the Migrate Payment Data for Closed Orders to Oracle Payment process can be improved.

Cause

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