My Oracle Support Banner

EEX9.1:MasterCard EX_DATA_LOAD Process Is Failing With Error Message Invalid Parameter 1 For Function EvalDateConv (Doc ID 2453350.1)

Last updated on OCTOBER 18, 2021

Applies to:

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

Symptoms

Issue:
EX_DATA_LOAD Process is failing with the error message Invalid parameter 1 for function EvalDateConv (180,116) EX_PUB_MCV3.GetFile.GBL.default.1900-01-01.GetData.OnExecute PCPC:31375 Statement:463

Replication Steps:

1) Add expense type – Corporate card for MasterCard CDFv3. (Setup Fin>Product Related>Expenses>Mapping>Expense Type_Corporate Card)

2) Add merchant category group (Setup Fin>Product Related>Expenses>Mapping>Merchant CategoryGroup)

3) Check currency code setting for MasterCard CDFv3. (Setup Fin>Product Related>Expenses>Mapping>Currency Code)

4) Add Corporate Card to Employee Profile

5) Load Master Card CDF3 and set file name (Travel and Expenses>Corporate Credit Cards>Load External Data Souces)

Actual Result: When credit card bank file has blank value for the number of days field for hotel MC3 Maintenance file then the file does not load.

Encounter error EX_DATA_LOAD Process is failing with the error message Invalid parameter 1 for function EvalDateConv (180,116) EX_PUB_MCV3.GetFile.GBL.default.1900-01-01.GetData.OnExecute PCPC:31375 Statement:463

Expected Result: To load the credit card file without error.

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
Cause
Solution
References


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