My Oracle Support Banner

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)

Symptoms

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.

REPLICATION STEPS:

    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.

ERROR MESSAGE:

    " File: E:\PT859P03X_2108260150-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1811  Error Position: 0  Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'A'.

      [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.

NOTE: In the images/screenshots/examples mentioned and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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.