My Oracle Support Banner

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

Last updated on JUNE 03, 2019

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

Issue:
-------

When attempting to journal generate accounting entries from AM - Adds, Adjustments, Disposed and Depreciation - it abends at Step FS_JGEN_JRNL.uDrill.uDrill2.

Error:
------

In Oracle Database:

File: e:\pt85305c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1623 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_DIST_LN) violated Failed SQL stmt: UPDATE PS_DIST_LN_JG_VW SET JOURNAL_ID = :1, JOURNAL_DATE = TO_DATE(:2,'YYYY-MM-DD' ), FISCAL_YEAR = :3, ACCOUNTING_PERIOD = :4, GL_DISTRIB_STATUS = 'D', JOURNAL_LINE = :5,DTTM_STAMP=C AST(SYSTIMESTAMP AS TIMESTAMP) WHERE PROCESS_INSTANCE = 747814 AND GL_DISTRIB_STATUS = 'J' AND PROJ ECT_ID=:6 AND ACCOUNT=:7 AND DEPTID=:8 AND FUND_CODE=:9 AND CURRENCY_CD=:10 AND FOREIGN_CURRENCY=:11

In SQL Server Database:

File: e:\pt85310c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1623  Error Position: 0  Return: 805 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_DIST_LN' with unique index 'PS_DIST_LN'. The duplicate key value is (SDUSD00000 0203351GASB342014-07-31 09:31:23.77306491APADJ2013-12-18 00:00:00.0000 Failed SQL stmt: UPDATE PS_DIST_LN_JG_VW SET JOURNAL_ID = :1, JOURNAL_DATE = :2, FISCAL_YEAR = :3, A CCOUNTING_PERIOD = :4, GL_DISTRIB_STATUS = 'D', JOURNAL_LINE = :5,DTTM_STAMP=GETDATE()  WHERE PROCES S_INSTANCE = 4120578 AND GL_DISTRIB_STATUS = 'J'  AND PROJECT_ID=:6 AND ACCOUNT=:7 AND DEPTID=:8 AND FUND_CODE=:9 AND CLASS_FLD=:10 AND PROGRAM_CODE=:11 AND BUDGET_REF=:12 AND AFFILIATE_INTRA1=:13 AND AFFILIATE_INTRA2=:14 AND CHARTFIELD1=:15 AND CHARTFIELD2=:16 AND CURRENCY_CD=:17 AND FOREIGN_CURREN


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.