My Oracle Support Banner

EGL 9.2 Simple Journal in DB2 is throwing Error "Duplicate key value -- not allowed" when Using Book Code (Doc ID 2576349.1)

Last updated on AUGUST 15, 2019

Applies to:

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


Simple journal tile not working when the Book Codes are the same.

“Duplicate key value -- not allowed.

You have entered a key value for a scroll item that is a duplicate of another scroll item. The record definition indicates that the record does not allow duplicate entries.  Either correct the key for the duplicate entry or contact your system administrator to change the record definition.” 

Steps to Replicate:
1. Set the Simple Journal Types
2. Set the simple journal template. Upon clicking configure button new tabs will open.
3. Perform the configuration
4. Click on the Simple Journal Tile.
5. Provide the Journal Type and the Journal template
6. Enter the header and line details.
7. Give the Chartfield criteria. Enter the Book codes for both the lines.
8. Click on Save.

Please see replication steps here.


 Turn on Book Code in Installation Options


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.