EGL: Journal Posting Process Abended at Step GL_JP_UNPOST.PROCESS.INSOITM (Doc ID 1958549.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to run Journal Post, the following error occurs.

ERROR
-----------------------
File: e:\pt85309d-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_OPEN_ITEM_GL' with unique index 'PS_OPEN_ITEM_GL'. The duplicate key value is (PLC, CASH062514, Jun 25 2014 12:00AM, 1, 1, ACTUALS, LIF9403406, 0).
Failed SQL stmt: INSERT INTO PS_OPEN_ITEM_GL (BUSINESS_UNIT, JOURNAL_ID, JOURNAL_DATE, UNPOST_SEQ, JOURNAL_LINE, LEDGER, ACCOUNT, ALTACCT, DEPTID, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, BOOK_CODE, GL_ADJUST_TYPE, DATE_CODE, BUDGET_PERIOD, SCENARIO, CURRENCY_CD, BUSINESS_UNIT_PC, PROJECT_ID, ACTIVITY_ID, RESOURCE_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, ANALYSIS_TYPE, MONETARY_AMOUNT, MOVEMENT_FLAG, LINE_DESCR, FOREIGN_CURRENCY, FOREIGN_AMOUNT, OPEN_ITEM_KEY, OPENITEM_RECON_NBR, OPEN_ITEM_STATUS, OPEN_DT, CLOSED_DT, DOC_SEQ_NBR, PROCESS_INSTANCE) SELECT BUSINESS_UNIT, JOURNAL_ID, JOURNAL_DATE, UNPOST_SEQ, JOURNAL_LINE, LEDGER, ACCOUNT, ALTACCT, DEPTID, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, BOOK_CODE, GL_ADJUST_TYPE, ' ', BUDGET_PERIOD, SCENARIO, CURRENCY_CD, BUSINESS_UNIT_PC, PROJECT_ID, ACTIVITY_ID, RESOURCE_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, ANALYSIS_TYPE, MONETARY_AMOUNT, MOVEMENT_FLAG, LINE_DESCR, FOREIGN_CURRENCY, FOREIGN_AMOUNT, OPEN_ITEM_KEY, 0, 'N', OPEN_DT, CLOSED_DT, DOC_SEQ_NBR, PROCESS_INSTANCE FROM PS_GL_OI_TMP WHERE PROCESS_INSTANCE = 1060264

Process 1060264 ABENDED at Step GL_JP_UNPOST.Process.InsOItm (SQL) -- RC = 805 (108,524)



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Journals entered online without open item line
2. Request Journal Post

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