EGL9.1: Error When Unposting Journals With Blank Unpost Date: PSPSQLRT error in Posting: GLPPUNPS-FQ800 UPD FISCAL-YEAR (Doc ID 1479816.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
****Checked for Currency on 4-May-2015****
(Please note, quick test shows issue is not applicable to the 9.2 release. GL_JP runs to success even with blank Unpost Date and Allows Different Unpost Date)

Symptoms

When attempting to unpost Journals, the following error occurs:

 

ERROR
------------------------
SEVERE ERROR IN PGM:(5830,7) PI(195589) Program(GLPPUNPS)
PSPSQLRT error in Posting: GLPPUNPS-FQ800 UPD FISCAL-YEAR.
> 2012-07-26-21.21.57.030000 INFO(5830,2) PI(195589) Program(GLPPPOST)

 

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