EGL9.2: GL Subledger Reconciliation (GL_RECN) Process Runs To No Success and Abends at Step GL_RECN_PROC.Populate.iDtlSrc

Last updated on JULY 13, 2017

Applies to:

Symptoms

On FSCM 9.2:

GL Subledger Reconciliation (GL_RECN) process runs to 'No Success' with error below and points to a duplicate that is not shown on the related table:

File: e:\pt85509c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 805 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key r ow in object 'dbo.PS_GLRCN_DTL_SRC' with unique index 'PS_GLRCN_DTL_SRC'. The duplicate key value is (A408120175ACTUALSS4090 NVS). Failed SQL stmt: INSERT INTO PS_GLRCN_DTL_SRC (BUSINESS_UNIT_GL, BUSINESS_UNIT, FISCAL_YEAR, ACCOUNT ING_PERIOD, LEDGER, ACCOUNT, ALTACCT, DEPTID, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM _CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIE LD3, PROJECT_ID, BOOK_CODE, SYSTEM_SOURCE, BASE_CURRENCY, NODISTRIB_AMT_DR, NODISTRIB_AMT_CR, DISTRI B_AMT_DR, DISTRIB_AMT_CR, POSTED_TRAN_DR, POSTED_TRAN_CR, NOPOSTED_TRAN_DR, NOPOSTED_TRAN_CR) SELECT
Process 5036885 ABENDED at Step GL_RECN_PROC.Populate.iDtlSrc (SQL) -- RC = 805

Steps to replicate:
1. Spreadsheet journal with Line using Statistical Account
2. Run Import Now.
3. Run Edit Journal process with Edit and Post selected.
4. Load Reconciliation Data (Navigation: General Ledger > Subsystem Reconciliation > Load Reconciliation Data) (System Source = NVS)
5. Run GL_RECN Process
Process Status = No Success
Message Log: 'ABENDED at Step GL_RECN_PROC.Populate.iDtlSrc (SQL)'

See replication screenshots attached.

Cause