EGL: The Journal Entry Lines Page Issues Error Window For Unique Constraint(805), When Creating A Suspense Line During Journal Edit. (Doc ID 1668700.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

CUSTOMER ENVIRONMENT
=========================
Application release 9.2 after upgrade from 9.
Image 5 previously did same testing on image 2 and did not get error
Tools 8.53


ISSUE
========
The online Journal edit is getting a unique constraint pop up message when creating suspense line

ERROR
f=======
From trace:

 Rollback

Stmt=SELECT MAX(MESSAGE_SEQ) FROM PS_MESSAGE_LOG WHERE PROCESS_INSTANCE = :1
Bind-1 type=8 length=4 value=157240
 Disconnect
 Open Cursor Handle=0000000002034910
Stmt=SELECT MESSAGE_SEQ FROM PS_MESSAGE_LOG WHERE PROCESS_INSTANCE =:1 AND MESSAGE_SEQ = :2 FOR UPDATE OF PROCESS_INSTANCE
 Bind-1 type=8 length=4 value=157240
 Bind-2 type=8 length=4 value=1
Stmt=SELECT MAX(MESSAGE_SEQ) FROM PS_MESSAGE_LOG WHERE PROCESS_INSTANCE=:1
 Bind-1 type=8 length=4 value=157240
Stmt=INSERT INTO PS_MESSAGE_LOG (PROCESS_INSTANCE, MESSAGE_SEQ, JOBID, PROGRAM_NAME, MESSAGE_SET_NBR, MESSAGE_NBR, MESSAGE_SEVERITY, DTTM_STAMP_SEC) VALUES(:1, :2, :3, :4, :5, :6, :7, CAST(SYSTIMESTAMP AS TIMESTAMP))
 Bind-1 type=8 length=4 value=157240
 Bind-2 type=8 length=4 value=2
 Bind-3 type=2 length=10 value=APP ENGINE
 Bind-4 type=2 length=8 value=PutCFBal
 Bind-5 type=8 length=4 value=65
 Bind-6 type=8 length=4 value=30
 Bind-7 type=8 length=4 value=30
Stmt=INSERT INTO PS_MESSAGE_LOGPARM (PROCESS_INSTANCE, MESSAGE_SEQ, PARM_SEQ, MESSAGE_PARM) VALUES(:1, :2, :3, :4)
 Bind-1 type=8 length=4 value=157240
 Bind-2 type=8 length=4 value=2
 Bind-3 type=8 length=4 value=1
 Bind-4 type=2 length=6 value=157240
 Bind-1 type=8 length=4 value=157240
 Bind-2 type=8 length=4 value=2
 Bind-3 type=8 length=4 value=2
 Bind-4 type=2 length=8 value=GL_JEHDR
 Bind-1 type=8 length=4 value=157240
 Bind-2 type=8 length=4 value=2
 Bind-3 type=8 length=4 value=3
 Bind-4 type=2 length=8 value=PutCFBal
 Bind-1 type=8 length=4 value=157240
 Bind-2 type=8 length=4 value=2
 Bind-3 type=8 length=4 value=4
 Bind-4 type=2 length=8 value=InsNonTL
 Bind-1 type=8 length=4 value=157240
 Bind-2 type=8 length=4 value=2
 Bind-3 type=8 length=4 value=5
 Bind-4 type=2 length=3 value=SQL
 Bind-1 type=8 length=4 value=157240
 Bind-2 type=8 length=4 value=2
 Bind-3 type=8 length=4 value=6
 Bind-4 type=2 length=3 value=805



EXPECTED RESULTS
==================
Journals should run through edit successfully creating suspense activity if required.



ACTUAL RESULTS
===============
When running edit from online, an error window pops up warning of a unique constraint. Unique constraint does not occur if run from batch.


BUSINESS IMPACT
================
Can not successfully process all editing via on line page and need it for go live.

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