EEX 9.2: EX_DATA_LOAD AE Program Abends at Step EX_LOAD_MCV3.MapFlds.MapETAdj in MSSQL Database Due to Wrong SQL Syntax
(Doc ID 2854806.1)
Last updated on MARCH 23, 2022
Applies to:PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Microsoft Windows x64 (64-bit)
The Expenses Credit Card Upload process (EX_DATA_LOAD AE Program) is abending for MasterCard CDF3 format files at Step EX_LOAD_MCV3.MapFlds.MapETAdj, when using a MicroSoft SQL Server Database Platform.
The SQL Statement delivered in this Step does not agree with the syntax expected to be handled in an MSSQL Database.
1.- Place a MasterCard CDF3 flat file containing Credit Card transaction data into the needed Folder from Process Scheduler
2.- Log into the FSCM Online Application as an Expenses User
3.- Navigate to: Travel and Expenses > Corporate Credit Cards > Load External Data Sources
4.- Create a new Run Control ID with the below settings:
a) Set ID Card Issuer = SHARE
b) Card Issuer = MC
c) Data Source = MasterCard CDF3
d) Load External Data = Y
e) File Name = Place the Folder navigation, and name of the MasterCard electronic flat file
5.- Click on RUN button
6.- Select the EX_DATA_LOAD AE Program
7.- Click on OK button
8.- Navigate to: PeopleTools > Process Scheduler > Process Monitor
9.- Find the Process Instance for the EX_DATA_LOAD AE Program, and confirm that it went to No Success with an Error 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.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ','.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'WHERE'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'AND'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 42000) 8180
Failed SQL stmt: UPDATE PS_EX_MC3_ST_TA04 A SET A.EXPENSE_TYPE = ( SELECT COALESCE(MIN(B.EXPENSE_TYPE),'MISCELL') FROM PS_EX_MC3_59_TA14 SOURCE ,PS_EX_CCET_MAP_TBL B ,PS_EX_MC3_E_TA14 C WHERE SOURCE.PROCESS_INSTANCE = 123456 AND SOURCE.CRDMEM_ACCT_NBR = A.CRDMEM_ACCT_NBR AND SOURCE.PROCESS_INSTANCE = C.PROCESS_INSTANCE AND SOURCE.CRDMEM_ACCT_NBR = C.CRDMEM_ACCT_NBR AND B.SETID = C.SETID AND B.DATA_SOURCE_EX = 'MCX' AND B.CC_TO_ET_GRP = 'ADJ' AND SOURCE.MC_TRANS_DT = A.MC_TRANS_DT AND A.PROCESS_INSTANCE = SOURCE.PROCESS_INSTANCE AND A.MC_PROCESS_TRANSID = SOURCE.MC_PROCESS_TRANSID AND A.TRANS_NBR = SOURCE.TRANS_NBR AND A.SEQ_NBR = SOURCE.SEQ_NBR), DESCR254 = ( SELECT MIN(D.DESCR254) FROM PS_EX_MC3_59_TA14 D WHERE D.PROCESS_INSTANCE = 123456 AND D.CRDMEM_ACCT_NBR = A.CRDMEM_ACCT_NBR AND D.MC_TRANS_DT = A.MC_TRANS_DT AND A.PROCESS_INSTANCE = D.PROCESS_INSTANCE AND A.MC_PROCESS_TRANSID = D.MC_PROCESS_TRANSID AND A.TRANS_NBR = D.TRANS_NBR AND A.SEQ_NBR = D.SEQ_NBR) WHERE EXISTS ( SELECT 'X' FROM PS_EX_MC3_59_TA14 E WHERE E.PROCESS_INSTANCE = 123456 AND E.CRDMEM_ACCT_NBR = A.CRDMEM_ACCT_NBR AND E.MC_TRANS_DT = A.MC_TRANS_DT AND A.PROCESS_INSTANCE = E.PROCESS_INSTANCE AND A.MC_PROCESS_TRANSID = E.MC_PROCESS_TRANSID AND A.TRANS_NBR = E.TRANS_NBR AND A.SEQ_NBR = E.SEQ_NBR) AND (A.MC_MERCH_TYPE = ' ' OR A.MC_MERCH_TYPE IS NULL) AND (A.EXPENSE_TYPE = ' ' OR A.EXPENSE_TYPE IS NULL) AND A.PROCESS_INSTANCE = 123456
Process 123456 ABENDED at Step EX_LOAD_MCV3.MapFlds.MapETAdj (SQL) -- RC = 8601 (108,524)
Credit card Transactions from MasterCard cannot be successfully loaded into the My Wallet Record, and as such, Employees cannot default the transactions into Expense Reports. This delays approvals, and eventually the reimbursement to the Credit Card Supplier, potentially causing delay penalty fees.
The Load External Data process (EX_DATA_LOAD AE Program) should be able to properly handle MasterCard CDF files regardless of the Database Platform being used in the system.
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