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 04, 2023

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.

Symptoms

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

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.