EEX 9.2: Credit Card Upload (EX_DATA_LOAD) Flagging Corporate Card Transaction With Invalid Transaction Currency Error (Doc ID 2920585.1)

Last updated on JANUARY 16, 2023

Applies to:

Symptoms

The Credit Card Upload process (EX_DATA_LOAD AE Program) flags with Invalid Transaction Currency error the MasterCard transactions loaded from an electronic flat file if they use Original Currency Code 949 (New Turkish Lira).

This is happening even when the Currency Code TRY (New Turkish Lira) is properly defined as a Currency Code, as well as mapped in the Currency Code to Credit Card Data Source set up page.

REPLICATION STEPS:

     1.- Define a new Currency Code of TRY (New Turkish Lira) in the PeopleSoft system (Navigation Path: Set Up Financials/Supply Chain > Common Definitions > Currency > Set up Currency Code)
     2.- Ensure to map the new Currency Code TRY against Currency Abbreviation Code 949 under Data Source MasterCard CDFv2 (Navigation Path: Set Up Financials/Supply Chain > Product Related > Expenses > Mapping > Map Currency Code to Corp Card)
     3.- Receive from the Bank a MasterCard CDFv2 flat file containing Credit Card Transactions from Employees on a trip to Turkey, where Currency Code 949 is being used at the line details, and place it in the correct shared folder for further processing
     4.- Launch the Credit Card Upload process for MasterCard CDFv2 Data Source, and point to the MasterCard received file name placed in the shared folder (Navigation Path: Travel and Expenses > Corporate Credit Cards > Load External Data Sources)
     5.- Confirm that at the MasterCard Transaction Errors page, the credit card item is listed and flagged with error (Navigation Path: Travel and Expenses > Corporate Credit Cards > Credit Card Transaction Errors > MasterCard Errors)

ERROR MESSAGE:

MasterCard Credit Card Transactions that have been expensed in Turkey, using New Turkish Lira Currency Code TRY (949), cannot be loaded effectively into My Wallet, which means they cannot be defaulted into an Expense Report, approved, nor further processed to reimburse the Credit card Supplier. This means potential delayed payments, with late penalty fees in the horizon.

The Credit Card Upload process (EX_DATA_LOAD AE Program) should be able to process that Currency Abbreviation Code 949 present in the MasterCard Credit Card file is to be matched against new Currency Code TRY, and validate the transaction successfully, by placing it into the appropriate Employee's My Wallet for future processing.

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.