12.2 E-Business Suite Applications Framework Page Export Function Fails Due To Error 'oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation'

(Doc ID 2360257.1)

Last updated on FEBRUARY 16, 2018

Applies to:

Oracle Applications Framework - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

 E-Business Suite 12.2 Applications Framework, OA Framework related issues

 

 

 

 When users click on the 'Export' button for a set of rows / columns in an appplications page the following error is received:

'Error Page Exception Details. oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.'

 

For example the following steps to export payment batches will generate the error:

Navigate to Compensation Manager -> Tasks -> Maintain Payment Batches
1. Click on Go
2. Click on any Paysheets (last column)
3. Click on Export button

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation.

Changes

 

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