Application Throws Error JBO-27122: SQL Error During Statement Preparation (Doc ID 2207021.1)

Last updated on NOVEMBER 29, 2016

Applies to:

Oracle JDeveloper - Version 12.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

A FMW ADF Application is performing an insert into a table. The insert works, but it throws in an error at the same time. The error message is:
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.



When the same query is executed in the Oracle Database 12.1.0.2.0, it worked well.


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