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.

Symptoms

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

ERROR
-----------------------
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.


STEPS
-----------------------
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


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