My Oracle Support Banner

EGL9.2: GL Subsystem Reconciliation (GL_RECN) Process Abends At Step GL_RECN_PROC.Populate.iDtlSrc With 'ORA-00001: unique constraint' Error When Using 'Increment' & 'All System Sources' Options (Doc ID 2080762.1)

Last updated on MAY 27, 2020

Applies to:

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


When running GL_RECN with Request type 'Increment' and check on 'All System Sources', process abends at Step GL_RECN_PROC.Populate.iDtlSrc


Steps to Replicate:

1. Run GL_RECN process with 'Create' option for say below parameters:
     Fiscal year: 2015
     Period: 7 (or any other period that has some data )
     BU: Select only one BU
     All system Sources checkbox checked
     Select all chartfields
2. Run the process again for the same parameters with 'Increment' option.





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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.