EGL 9.2 : GLRN_CREATE Abends With Unique Constraint Error at GLRN_SET.InsURDet.InsURDet) (SQL)

(Doc ID 1966526.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

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


When attempting to run reconciliation process (GLRN_CREATE) the following error occurs -

(GLRN_SET.InsURDet.InsURDet) (SQL) -- RC = 805

Ora-00001 Unique Constraint

The issue can be reproduced at will with the following steps:
1.Create 2 (Test 1 and Test 2) Chartfield Value Set with account and business unit as its chartfields. Ensure the account value is duplicate i.e. Account X should be used in Test 1 and Test 2 Chartfield Value Set.
2. Associate those chartfield value sets to Reconciliation Rule.
3. Create a reconciliation set and click on “Create Reconciliations” button.
4. Run the reconciliation process.


Notice the process goes to No Success with Unique Contraint Error.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms