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 |