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 NOVEMBER 13, 2023

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.

Symptoms

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

 

Changes

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

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.