My Oracle Support Banner

EGL9.2: Journal Generator (FS_JGEN) Process Fails at Step FS_JGEN_JRNL.uDrill.uDrill2 With 'ORA-00001: unique constraint' or 'Cannot insert duplicate key row' Error For Asset Management Entries (Doc ID 1635726.1)

Last updated on MAY 27, 2020

Applies to:

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


When attempting to journal generate accounting entries from AM - Adds, Adjustments, Disposed and Depreciation - abended at Step FS_JGEN_JRNL.uDrill.uDrill2 with below errors:

Oracle Database:

Steps to Replicate:

1. Make sure to have necessary data for Journal Generator to process.
2. Run the journal generator for Asset Management accounting entries




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.