My Oracle Support Banner

EGL9.2: GL Subsystem Reconciliation - Load Reconciliation(GL_RECN) Process Abends at Step GL_RECN_PROC.Populate.iDtlSrc With Cannot insert duplicate key r ow in object 'dbo.PS_GLRCN_DTL_SRC' with unique index 'PS_GLRCN_DTL_SRC' Error (Doc ID 2277066.1)

Last updated on FEBRUARY 05, 2019

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue:
-------

GL Subledger Reconciliation (GL_RECN) process abends at step GL_RECN_PROC.Populate.iDtlSrc

Error:
------

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

Note: For Oracle database error message is:  

ORA-00001: unique constraint (SYSADM.PS_GLRCN_DTL_SRC) violated


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

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.