ECM: Automatic Reconciliation abends at Step FSPRECON.900-SQL.900-ST05 (Doc ID 1413012.1)

Last updated on JULY 03, 2017

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version: 9.1 and later   [Release: 9 and later ]
Information in this document applies to any platform.

Symptoms

When attempting to FSPRECON, the process abends at at Step FSPRECON.900-SQL.900-ST05">FSPRECON.900-SQL.900-ST05 with an error.

ERROR
File: e:\pt85113b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1617 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert the value NULL into column 'RECON_RUN_ID', table 'FINUPG1.dbo.PS_PAYMENT_TBL'; column does not allow nulls. UPDATE fails.
[Microsoft][SQL Server Native Client 10.0][SQL Server]The statem
Failed SQL stmt:UPDATE PS_BNK_RCN_DISBRSE SET RECON_STATUS = 'REC' , RECONCILE_OPRID = 'AUTO' , RECON_TYPE = 'A' , RECON_CYCLE_NBR = 3665 , PYMNT_RECONCILE_DT = '2012-02-10' , RECON_RUN_ID = ( SELECT RECORD_SEQ_NUMBER FROM PS_BNK_DISBRVL_T1 WHERE PROCESS_INSTANCE = 675235 AND BANK_SETID = PS_BNK_RCN_DISBRSE.BANK_SETID AND BANK_CD = PS_BNK_RCN_DISBRSE.BANK_CD AND BANK_ACCT_KEY = PS_BNK_RCN_DISBRSE.BANK_ACCT_KEY AND PYMNT_ID = PS_BNK_RCN_DISBRSE.PYMNT_ID AND RECON_STATUS = 'REC' AND PYMNT_STATUS <>'V') , STTLMNT_DT_ACTUAL = ( SELECT STTLMNT_DT_ACTUAL FROM PS_BNK_DISBRVL_T1 WHERE PROCESS_INSTANCE = 675235 AND BANK_SETID = PS_BNK_RCN_DISBRSE.BANK_SETID AND BANK_CD = PS_BNK_RCN_DISBRSE.BANK_CD AND BANK_ACCT_KEY = PS_BNK_RCN_DISBRSE.BANK_ACCT_KEY AND PYMNT_ID = PS_BNK_RCN_DISBRSE.PYMNT_ID AND RECON_STATUS = 'REC' AND PYMNT_STATUS <>'V')

Process 675235 ABENDED at Step FSPRECON.900-SQL.900-ST05 (SQL) -- RC = 8601 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s


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