EGL:Journal Edit Process Abends at Step IU_PROCESSOR.U400_KLS.PrcTL with Unique Constraint Error For An InterUnit Journal With Multibook Ledger Group (Doc ID 2163701.1)

Last updated on OCTOBER 31, 2016

Applies to:

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

Symptoms

On : 9.1 bundle #38 (or below), or 9.2 PUM 19 (or below)

Journal Edit process is failing with Unique Constraint error at Step IU_PROCESSOR.U400_KLS.PrcTL.
The error occurs only with specific journals, entered by user using GL Journal Entry page.

ERROR
-----------------------
Process 1023121 ABENDED at Step IU_PROCESSOR.U400_KLS.PrcTL (Action SQL) -- RC = 805
 SQL Error: ORA-00001: unique constraint (SYSADM.PSHJRNL_LN) violated


STEPS TO REPLICATE THE ISSUE
------------------------------------
1) Create a Ledger Group with 3 Ledgers in it, 1 primary, 2 translation ledgers.
2) Create 2 new BUs with above new Ledger Group linked in ledgers for a unit.
3) Create a multibook, interunit journal with 5 lines in BU 1 with the new
multibook Ledger Group, with first 2 lines to BU 1, next 3 lines to BU 2, with
.line 1 amount 10.00, line 2 amount -10.00
.line 3 is blank
.line 4 is 5.00, line 5 is -6.00
4) Go to translation ledger lines. On lines with blank amount, leave Rate Type
and Exchange Rate blank. Then in the Base Amount field, enter in -0.04 in
first blank field and 0.01 in the next.
5) Return to primary ledger lines and click Save.
6) Then run the online journal edit process.

Cause

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