My Oracle Support Banner

EGL9.2: When Attempting to Reconcile an Open Item Entry, Receive SQL Error in GL_OI_RECON_WRK.PB_RECON_SEL.SavePostChange. (Doc ID 1937195.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

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


When attempting to reconcile an Open Item entry the following error occurs.

SQL error in Exec. (2,280) GL_OI_RECON_WRK.PB_RECON_SEL.SavePostChange PCPC:3247 Statement:55
During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.

The issue can be reproduced at will with the following steps:
1. Go to General Ledger => Open Items => Maintenance page
2. Select the item
3. Click in the reconcile button


To view full details, 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 a vibrant support community of peers and Oracle experts.