EGL9.2: FS_JGEN ABENDED at Step FS_JGEN_JRNL.uDrill.uDrill2 with Unique Constraint Error While Generating Journals For Asset Management Entries

(Doc ID 1635726.1)

Last updated on JULY 24, 2017

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.
*** Checked for Currency on 23 May 2016 ***

Symptoms


Issue:
-------

When attempting to journal generate accounting entries from AM - Adds, Adjustments, Disposed and Depreciation - the following error occurs.

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

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