R12: AP/OIE: After EBS Upgrade We Observe Duplicate Credit Card And Credit Card Transactions Are Unmapped. (Doc ID 3070850.1)

Last updated on FEBRUARY 12, 2025

Applies to:

Symptoms

Post EBS Upgrade, for many entities the credit card transactions are unmapped.

Duplicate cards records have been created in table AP_CARDS_ALL; same card number but different card_ids.

As a result, for those employees, we are seeing duplicate credit cards in iExpense -Home OAF Page; same card with old and new card id. 

Some transactions are linked to the new card ID and have already been expensed, invoiced and paid.

Steps to reproduce:

1. After EBS and RDBMS upgrade, log into Oracle Applications using a Payables responsibility.
2. Run the Credit Card Transactions Validation and Loader program concurrent and successfully load Credit Card Transactions flat file sent by the Credit Card company.
3. Create expense reports using some of the new credit card transactions loaded.
4. Review the new credit Cards loaded and notice some duplicates; same Card Number, different Card_ID (in DB Table).

Also, customer tested the fix given in MOS document R12: OIE: Credit Card Transactions Not Displaying in IExpense, and this is not fetching/fixing all the expected incorrect data.

.

Changes

Upgraded to Release 12.2.x

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.