My Oracle Support Banner

CM 9.2: FSX3001 Failing With SQL Error - No Cursor (Doc ID 2540465.1)

Last updated on DECEMBER 13, 2019

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms



ISSUE:
----------
 FSX3001 failing with SQL error - No cursor

ERROR:
------------
File: E:\pt85521b-retail\peopletools\src\pssys\qpm.cppSQL error. Stmt #: 7858 Error Position: 0 Return: 8602 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Executing SQL directly; no cursor.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'CASE'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect synta
Failed SQL stmt: SELECT A.BNK_ID_NBR, A.BANK_ACCOUNT_NUM, A.RECON_CYCLE_NBR, A.RECORD_SEQ_NUMBER, A.RECON_REF_ID, A.RECON_TRANS_CODE, A.RECON_TRAN_AMT, (CONVERT(CHAR(10),A.RECON_BANK_DT,121)), A.RECON_STATUS, A.TRAN_AMT, (CONVERT(CHAR(10),A.TRAN_DT,121)), A.PYMNT_METHOD, A.PYMNT_STATUS, (CONVERT(CHAR(10),G.ASOFDATE,121)), A.BANK_SETID + A.BANK_CD + A.BANK_ACCT_KEY + A.PYMNT_ID, E.IBAN_ID, CASE WHEN A.RECON_STATUS = 'AMB' THEN 'Ambiguous Match' WHEN A.RECON_STATUS = 'ALG' THEN 'Alignment Check' WHEN A.RECON_STATUS = 'AMT' THEN 'Amounts Not Equal' WHEN A.RECON_STATUS = 'CUR' THEN 'Currency Not Defined' WHEN A.RECON_STATUS = 'DAT' THEN 'Tran Date<>Value Date' WHEN A.RECON_STATUS = 'DUP' THEN 'Duplicate Transaction' WHEN A.RECON_STATUS = 'MSC' THEN 'Miscellaneous' WHEN A.RECON_STATUS = 'NAM' THEN 'Payee Names Not Equal' WHEN A.RECON_STATUS = 'OVR' THEN 'Overflow' WHEN A.RECON_STATUS = 'PND' THEN 'Pending Reconciliation' WHEN A.RECON_STATUS = 'STP' THEN 'Stopped Payment' WHEN A.RECON_STATUS = 'TYP' THEN 'Wrong Trans Type' WHEN A.RECON_STATUS = 'UNR' THEN 'Unreconciled Tran' WHEN A.RECON_STATUS = 'VOI' THEN 'Voided Check' WHEN A.RECON_STATUS = 'NTB' THEN 'Not Found in Statement' WHEN A.RECON_STATUS = 'NTF' THEN 'Not Found in System' ELSE 'Unknown' END CASE FROM PS_BNK_RCN_DTL_VW A, PS_BNK_RCN_CYC G, PS_BANK_ACCT_TBL E WHERE ( A.BNK_ID_NBR = :1 AND A.BANK_ACCOUNT_NUM = :2 AND A.RECON_CYCLE_NBR = :3 AND A.BNK_ID_NBR = G.BNK_ID_NBR AND A.BANK_ACCOUNT_NUM = G.BANK_ACCOUNT_NUM AND A.RECON_CYCLE_NBR = G.RECON_CYCLE_NBR AND E.BANK_CD = A.BANK_CD AND E.BANK_ACCT_KEY = A.BANK_ACCT_KEY AND E.SETID = A.BANK_SETID) UNION SELECT C.BNK_ID_NBR, C.BANK_ACCOUNT_NUM, C.RECON_CYCLE_NBR, C.RECORD_SEQ_NUMBER, C.RECON_REF_ID, C.RECON_TRANS_CODE, C.RECON_TRAN_AMT, (CONVERT(CHAR(10),C.RECON_BANK_DT,121)), C.RECON_STATUS, C.TRAN_AMT, (CONVERT(CHAR(10),C.TRAN_DT,121)), C.RECON_SOURCE, ' ', (CONVERT(CHAR(10),H.ASOFDATE,121)), C.BUSINESS_UNIT + C.DEPOSIT_ID, I.IBAN_ID, CASE WHEN C.RECON_STATUS = 'AMB' THEN 'Ambiguous Match' WHEN C.RECON_STATUS = 'ALG' THEN 'Alignment Check' WHEN C.RECON_STATUS = 'AMT' THEN 'Amounts Not Equal' WHEN C.RECON_STATUS = 'CUR' THEN 'Currency Not Defined' WHEN C.RECON_STATUS = 'DAT' THEN 'TranDate<>Value Date' WHEN C.RECON_STATUS = 'DUP' THEN 'Duplicate Transaction' WHEN C.RECON_STATUS = 'MSC' THEN 'Miscellaneous' WHEN C.RECON_STATUS = 'NAM' THEN 'Payee Names Not Equal' WHEN C.RECON_STATUS = 'OVR' THEN 'Overflow' WHEN C.RECON_STATUS = 'PND' THEN 'Pending Reconciliation' WHEN C.RECON_STATUS = 'STP' THEN 'Stopped Payment' WHEN C.RECON_STATUS = 'TYP' THEN 'Wrong Trans Type' WHEN C.RECON_STATUS = 'UNR' THEN 'Unreconciled Tran' WHEN C.RECON_STATUS = 'VOI' THEN 'Voided Check' WHEN C.RECON_STATUS = 'NTB' THEN 'Not Found in Statement' WHEN C.RECON_STATUS = 'NTF' THEN 'Not Found in System' ELSE 'Unknown' END CASE FROM PS_BNK_RCN_DTLR_VW C, PS_BNK_RCN_CYC H, PS_BANK_ACCT_DEFN I, PS_BANK_CD_TBL O WHERE ( C.BNK_ID_NBR = :4 AND C.BANK_ACCOUNT_NUM = :5 AND C.RECON_CYCLE_NBR = :6 AND C.BNK_ID_NBR = H.BNK_ID_NBR AND C.BANK_ACCOUNT_NUM = H.BANK_ACCOUNT_NUM AND C.RECON_CYCLE_NBR = H.RECON_CYCLE_NBR AND C.BANK_ACCOUNT_NUM = I.BANK_ACCOUNT_NUM AND I.SETID = O.SETID AND I.BANK_CD = O.BANK_CD AND O.BNK_ID_NBR = C.BNK_ID_NBR) UNION SELECT B.BNK_ID_NBR, B.BANK_ACCOUNT_NUM, B.RECON_CYCLE_NBR, B.RECORD_SEQ_NUMBER, B.RECON_REF_ID, B.RECON_TRANS_CODE, B.RECON_TRAN_AMT, (CONVERT(CHAR(10),B.RECON_BANK_DT,121)), B.RECON_STATUS, B.TRAN_AMT, (CONVERT(CHAR(10),B.TRAN_DT,121)), B.RECON_SOURCE, ' ', (CONVERT(CHAR(10),D.ASOFDATE,121)), B.BUSINESS_UNIT + B.DEPOSIT_ID, P.IBAN_ID, CASE WHEN B.RECON_STATUS = 'AMB' THEN 'Ambiguous Match' WHEN B.RECON_STATUS = 'ALG' THEN 'Alignment Check' WHEN B.RECON_STATUS = 'AMT' THEN 'Amounts Not Equal' WHEN B.RECON_STATUS = 'CUR' THEN 'Currency Not Defined' WHEN B.RECON_STATUS = 'DAT' THEN 'TranDate<>Value Date' WHEN B.RECON_STATUS = 'DUP' THEN 'Duplicate Transaction' WHEN B.RECON_STATUS = 'MSC' THEN 'Miscellaneous' WHEN B.RECON_STATUS = 'NAM' THEN 'Payee Names Not Equal' WHEN B.RECON_STATUS = 'OVR' THEN 'Overflow' WHEN B.RECON_STATUS = 'PND' THEN 'Pending Reconciliation' WHEN B.RECON_STATUS = 'STP' THEN 'Stopped Payment' WHEN B.RECON_STATUS = 'TYP' THEN 'Wrong Trans Type' WHEN B.RECON_STATUS = 'UNR' THEN 'Unreconciled Tran' WHEN B.RECON_STATUS = 'VOI' THEN 'Voided Check' WHEN B.RECON_STATUS = 'NTB' THEN 'Not Found in Statement' WHEN B.RECON_STATUS = 'NTF' THEN 'Not Found in System' ELSE 'Unknown' END CASE FROM PS_BNK_RCN_DTLB_VW B, PS_BNK_RCN_CYC D, PS_BANK_ACCT_DEFN P, PS_BANK_CD_TBL Q WHERE ( B.BNK_ID_NBR = :7 AND B.BANK_ACCOUNT_NUM = :8 AND B.RECON_CYCLE_NBR = :9 AND B.BNK_ID_NBR = D.BNK_ID_NBR AND B.BANK_ACCOUNT_NUM = D.BANK_ACCOUNT_NUM AND B.RECON_CYCLE_NBR = D.RECON_CYCLE_NBR AND B.BANK_ACCOUNT_NUM = P.BANK_ACCOUNT_NUM AND P.SETID = Q.SETID AND P.BANK_CD = Q.BANK_CD AND Q.BNK_ID_NBR = B.BNK_ID_NBR) UNION SELECT F.BNK_ID_NBR, F.BANK_ACCOUNT_NUM, F.RECON_CYCLE_NBR, F.RECORD_SEQ_NUMBER, F.RECON_REF_ID, F.RECON_TRANS_CODE, F.RECON_TRAN_AMT, (CONVERT(CHAR(10),F.RECON_BANK_DT,121)), F.RECON_STATUS, F.TRAN_AMT, (CONVERT(CHAR(10),F.TRAN_DT,121)), F.RECON_SOURCE, ' ', (CONVERT(CHAR(10),J.ASOFDATE,121)), F.BUSINESS_UNIT + F.DEPOSIT_ID, R.IBAN_ID, CASE WHEN F.RECON_STATUS = 'AMB' THEN 'Ambiguous Match' WHEN F.RECON_STATUS = 'ALG' THEN 'Alignment Check' WHEN F.RECON_STATUS = 'AMT' THEN 'Amounts Not Equal' WHEN F.RECON_STATUS = 'CUR' THEN 'Currency Not Defined' WHEN F.RECON_STATUS = 'DAT' THEN 'TranDate<>Value Date' WHEN F.RECON_STATUS = 'DUP' THEN 'Duplicate Transaction' WHEN F.RECON_STATUS = 'MSC' THEN 'Miscellaneous' WHEN F.RECON_STATUS = 'NAM' THEN 'Payee Names Not Equal' WHEN F.RECON_STATUS = 'OVR' THEN 'Overflow' WHEN F.RECON_STATUS = 'PND' THEN 'Pending Reconciliation' WHEN F.RECON_STATUS = 'STP' THEN 'Stopped Payment' WHEN F.RECON_STATUS = 'TYP' THEN 'Wrong Trans Type' WHEN F.RECON_STATUS = 'UNR' THEN 'Unreconciled Tran' WHEN F.RECON_STATUS = 'VOI' THEN 'Voided Check' WHEN F.RECON_STATUS = 'NTB' THEN 'Not Found in Statement' WHEN F.RECON_STATUS = 'NTF' THEN 'Not Found in System' ELSE 'Unknown' END CASE FROM PS_BNK_RCN_DTLD_VW F, PS_BNK_RCN_CYC J, PS_BANK_ACCT_DEFN R, PS_BANK_CD_TBL S WHERE ( F.BNK_ID_NBR = :10 AND F.BANK_ACCOUNT_NUM = :11 AND F.RECON_CYCLE_NBR = :12 AND F.BNK_ID_NBR = J.BNK_ID_NBR AND F.BANK_ACCOUNT_NUM = J.BANK_ACCOUNT_NUM AND F.RECON_CYCLE_NBR = J.RECON_CYCLE_NBR AND F.BANK_ACCOUNT_NUM = R.BANK_ACCOUNT_NUM AND R.SETID = S.SETID AND R.BANK_CD = S.BANK_CD AND S.BNK_ID_NBR = F.BNK_ID_NBR) UNION SELECT K.BNK_ID_NBR, K.BANK_ACCOUNT_NUM, K.RECON_CYCLE_NBR, K.RECORD_SEQ_NUMBER, K.RECON_REF_ID, K.RECON_TRANS_CODE, K.RECON_TRAN_AMT, (CONVERT(CHAR(10),K.RECON_BANK_DT,121)), K.RECON_STATUS, K.TRAN_AMT, (CONVERT(CHAR(10),K.TRAN_DT,121)), K.RECON_SOURCE, ' ', (CONVERT(CHAR(10),L.ASOFDATE,121)), K.BNK_ID_NBR + K.BANK_ACCOUNT_NUM + K.TRAN_REF_ID + CAST( (CONVERT(CHAR(10),K.TRAN_DT,121)) AS CHAR(10)), T.IBAN_ID, CASE WHEN K.RECON_STATUS = 'AMB' THEN 'Ambiguous Match' WHEN K.RECON_STATUS = 'ALG' THEN 'Alignment Check' WHEN K.RECON_STATUS = 'AMT' THEN 'Amounts Not Equal' WHEN K.RECON_STATUS = 'CUR' THEN 'Currency Not Defined' WHEN K.RECON_STATUS = 'DAT' THEN 'TranDate<>Value Date' WHEN K.RECON_STATUS = 'DUP' THEN 'Duplicate Transaction' WHEN K.RECON_STATUS = 'MSC' THEN 'Miscellaneous' WHEN K.RECON_STATUS = 'NAM' THEN 'Payee Names Not Equal' WHEN K.RECON_STATUS = 'OVR' THEN 'Overflow' WHEN K.RECON_STATUS = 'PND' THEN 'Pending Reconciliation' WHEN K.RECON_STATUS = 'STP' THEN 'Stopped Payment' WHEN K.RECON_STATUS = 'TYP' THEN 'Wrong Trans Type' WHEN K.RECON_STATUS = 'UNR' THEN 'Unreconciled Tran' WHEN K.RECON_STATUS = 'VOI' THEN 'Voided Check' WHEN K.RECON_STATUS = 'NTB' THEN 'Not Found in Statement' WHEN K.RECON_STATUS = 'NTF' THEN 'Not Found in System' ELSE 'Unknown' END CASE FROM PS_BNK_RCN_DTLX_VW K, PS_BNK_RCN_CYC L, PS_BANK_ACCT_DEFN T, PS_BANK_CD_TBL U WHERE ( K.BNK_ID_NBR = :13 AND K.BANK_ACCOUNT_NUM = :14 AND K.RECON_CYCLE_NBR = :15 AND K.BNK_ID_NBR = L.BNK_ID_NBR AND K.BANK_ACCOUNT_NUM = L.BANK_ACCOUNT_NUM AND K.RECON_CYCLE_NBR = L.RECON_CYCLE_NBR AND K.BANK_ACCOUNT_NUM = T.BANK_ACCOUNT_NUM AND T.SETID = U.SETID AND T.BANK_CD = U.BANK_CD AND U.BNK_ID_NBR = K.BNK_ID_NBR) UNION SELECT M.BNK_ID_NBR, M.BANK_ACCOUNT_NUM, M.RECON_CYCLE_NBR, M.RECORD_SEQ_NUMBER, M.TRAN_REF_ID, M.RECON_TRANS_CODE, M.RECON_TRAN_AMT, (CONVERT(CHAR(10),M.RECON_BANK_DT,121)), M.RECON_STATUS, M.TRAN_AMT, (CONVERT(CHAR(10),M.TRAN_DT,121)), M.RECON_SOURCE, ' ', (CONVERT(CHAR(10),N.ASOFDATE,121)), M.BUSINESS_UNIT + M.DEPOSIT_ID + CAST( M.PAYMENT_SEQ_NUM AS CHAR(6)), V.IBAN_ID, CASE WHEN M.RECON_STATUS = 'AMB' THEN 'Ambiguous Match' WHEN M.RECON_STATUS = 'ALG' THEN 'Alignment Check' WHEN M.RECON_STATUS = 'AMT' THEN 'Amounts Not Equal' WHEN M.RECON_STATUS = 'CUR' THEN 'Currency Not Defined' WHEN M.RECON_STATUS = 'DAT' THEN 'TranDate<>Value Date' WHEN M.RECON_STATUS = 'DUP' THEN 'Duplicate Transaction' WHEN M.RECON_STATUS = 'MSC' THEN 'Miscellaneous' WHEN M.RECON_STATUS = 'NAM' THEN 'Payee Names Not Equal' WHEN M.RECON_STATUS = 'OVR' THEN 'Overflow' WHEN M.RECON_STATUS = 'PND' THEN 'Pending Reconciliation' WHEN M.RECON_STATUS = 'STP' THEN 'Stopped Payment' WHEN M.RECON_STATUS = 'TYP' THEN 'Wrong Trans Type' WHEN M.RECON_STATUS = 'UNR' THEN 'Unreconciled Tran' WHEN M.RECON_STATUS = 'VOI' THEN 'Voided Check' WHEN M.RECON_STATUS = 'NTB' THEN 'Not Found in Statement' WHEN M.RECON_STATUS = 'NTF' THEN 'Not Found in System' ELSE 'Unknown' END CASE FROM PS_BNK_RCN_PDTL_VW M, PS_BNK_RCN_CYC N, PS_BANK_ACCT_DEFN V, PS_BANK_CD_TBL W WHERE ( M.BNK_ID_NBR = :16 AND M.BANK_ACCOUNT_NUM = :17 AND M.RECON_CYCLE_NBR = :18 AND M.BNK_ID_NBR = N.BNK_ID_NBR AND M.BANK_ACCOUNT_NUM = N.BANK_ACCOUNT_NUM AND M.RECON_CYCLE_NBR = N.RECON_CYCLE_NBR AND M.BANK_ACCOUNT_NUM = V.BANK_ACCOUNT_NUM AND V.SETID = W.SETID AND V.BANK_CD = W.BANK_CD AND W.BNK_ID_NBR = M.BNK_ID_NBR) ORDER BY 1, 2, 3, 4, 5, 7, 10
2019-03-11-09.54.36.999981 GetNextStateRecord [68] Exception logged: RC=3.
2019-03-11-09.54.36.999981 GetNextStateRecord [68] Exception logged: RC=3.

Error in running query because of SQL Error, Code=8602, Message=[Microsoft][SQL Server Native Client 11.0][SQL Server]Executing SQL directly; no cursor.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'CASE'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect synta (50,380)
2019-03-11-09.54.37.000024 AePcdExecutePeopleCode [191] Exception logged: RC=100.
2019-03-11-09.54.37.000024 GetNextStateRecord [68] Exception logged: RC=3.

Query Engine returns error. (228,118) PSXP_RPTDEFNMANAGER.ReportDefn.OnExecute Name:GenerateXmlFileFromQuery PCPC:115856 Statement:2268

Called from:PSXP_RPTDEFNMANAGER.ReportDefn.OnExecute Name:ProcessReport Statement:1490

Called from:FSX3001.MAIN.GBL.default.1900-01-01.GenRpt.OnExecute Statement:25
2019-03-11-09.54.37.000062 DoStepActions [1956] Exception logged: RC=100.

Process 23792 ABENDED at Step FSX3001.MAIN.GenRpt (PeopleCode) -- RC = 24 (108,524)

STEPS:
-----------
Navigate to Banking -> Reconcile Statements -> Automatic Reconciliation.

Run report for 'Exceptions' and an error is thrown and no report is generated.



Changes

 

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