EEX 9.2: EX_DATA_LOAD AE Program Erroneously Flags MasterCard CDFv3 Transactions As Duplicate Through Step EX_LOAD_MCV3.StgErrD.DupCheck (Doc ID 2914489.1)

Last updated on JANUARY 29, 2023

Applies to:

Symptoms

The Credit Card Upload process (EX_DATA_LOAD AE Program) is incorrectly flagging as duplicates MasterCard Transactions that although may have the same Merchant Name (MC_MERCH_NAME), Transaction Amount (MC_TRANS_AMNT), and even Transaction ID (Fields TRANS_NBR, and MC_PROCESS_TRANSID), do still have different Transaction Date, Sequence Number (SEQ_NBR), and MasterCard Process Date (MC_PROCESS_DT).

This seems to take place because the delivered codeline within the below listed Application Designer object is not looking at all possible Fields that would make a given transaction unique, and still valid.

    - Application Engine Program, Section, Step, and SQL: EX_LOAD_MCV3.StgErrD.DupCheck

The problem takes place if the system finds that the Credit Card Transaction trying to be loaded has a potential duplicate stored in the MasterCard Error Staging Table, coming from a previous run. If the errored transaction is cleared before the second flat file is uploaded, then the system uses different validation steps, (with more field criteria), which allows the transaction to be processed successfully into My Wallet because no duplicate is detected then.

REPLICATION STEPS:

    1.- The Employee is on a project, and uses the Corporate Card to pay for lunch on July 25th 2022, for Amount 100 USD, and Merchant ABC
    2.- The Bank sends the MasterCard CDFv3 electronic flat file to the company
    3.- The company uploads the received flat file into the PeopleSoft system     (Navigation Path: Travel and Expenses > Corporate Credit Cards > Load External Data Sources)
    4.- The transaction goes into the Error Staging Tables due to the fact that the Corporate Card Account Number is not yet assigned to an Employee Expenses Profile
    5.- The Employee uses the Corporate Card once again to pay for lunch on July 30th 2022, for Amount 100 USD, and Merchant ABC (Same restaurant, same menu, different date)
    6.- The Bank sends the MasterCard CDFv3 electronic flat file to the company
    7.- The company uploads the second received flat file into the PeopleSoft system     (Navigation Path: Travel and Expenses > Corporate Credit Cards > Load External Data Sources)
    8.- This time though, while the process ends in Success, there is a Duplicate Exists message

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps PDF Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

ERROR MESSAGE:

Changes

Cause

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