My Oracle Support Banner

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

Last updated on SEPTEMBER 28, 2018

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:
-------

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

Error:
------

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

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.

 

Changes

 

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