R12: AP : Resolution for Duplicate Credit Card Entries Post-Upgrade
(Doc ID 3002238.1)
Last updated on MARCH 01, 2024
Applies to:
Oracle Internet Expenses - Version 12.1 to 12.2.13 [Release 12.1 to 12.2]Information in this document applies to any platform.
Symptoms
After a system upgrade, users may encounter an issue where the "MasterCard CDF3 Transaction Loader and Validation Program" (APXMCCDF3) or the "Visa VCF 4 Transaction Loader and Validation Program" (APXVVCF4) creates duplicate credit card entries for existing cards in the Accounts Payable (AP) and Oracle Payments (IBY) tables, specifically in AP_CARDS_ALL and IBY_CREDITCARD. The observed problems include:
- Users may experience an issue where the dropdown menu for credit card records displays an incorrect record that shares the same last four digits with the correct record. This can cause confusion and potentially lead to the selection of incorrect credit card information for transactions.
- The following SQL query has been identified as a means to pinpoint the issue by highlighting discrepancies between 'good' and 'bad' card IDs, where 'bad' card IDs refer to duplicate or erroneous entries that need to be addressed:
Changes
The upgrade process may inadvertently lead to the creation of duplicate credit card records
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |