EEX 9.1+: Credit Card Load Process (EX_DATA_LOAD) is Pulling Incorrect Transaction Number For Master Card (MCV3 file format) Transactions. (Doc ID 2062315.1)

Last updated on DECEMBER 08, 2016

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Credit Card Load Process (EX_DATA_LOAD) is pulling incorrect Transaction number for Master Card (MCV3 file format) transactions.

Steps:
---------
1) Navigate to Travel and Expenses > Corporate Credit Cards > Load External Data Sources
2) Give run control parameter to load Master Card V3 file.
3) Run the process.
4) The TRANS_NBR field on EX_TRANS table is not getting populated correctly. It is using the parent field which is FinancialTransactionEntityProcessorTransactionId instead of ProcessorTransactionId.

Actual Result:
---------------------
The TRANS_NBR field on EX_TRANS table is not getting populated correctly. It is using the parent field which is FinancialTransactionEntityProcessorTransactionId instead of ProcessorTransactionId.

Expected Result:
---------------------------
The TRANS_NBR field on EX_TRANS table must be populated with ProcessorTransactionId.

Please see attached replication steps document for details.

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