My Oracle Support Banner

EGL9.2: Journal Posting Process Abended at Step GL_JP_PROC.MainLoop.UPD_STTS With "Incorrect syntax near 'A'" Error (Doc ID 2718920.1)

Last updated on OCTOBER 13, 2020

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Microsoft SQLServer - Version 2005 to 2017
Information in this document applies to any platform.



Journal Posting (GL_JP) Process abended at Step GL_JP_PROC.MainLoop.UPD_STTS with the following error


Steps to Replicate:

1. In PIA navigate to Navigate to General Ledger > Journals > Create/Update Journal entry. Enter a journal
2. Edit the journal and post it.
3. Check message log for the GL_JP process as scheduled in Process Monitor



 Issue is encountered either after upgrading to 9.2 PI 37 or applying enhancement feature bugs related to Journal Source security.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.