JBO-27122: SQL Error During Statement Occurs Viewing Activity History In Status Monitor

(Doc ID 1944868.1)

Last updated on OCTOBER 29, 2015

Applies to:

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


On Oracle Applications 12.1.3 version and above, Workflow Administration,
after applying the patch 18597161, the following error occurs viewing the activity history in the Workflow Monitor:

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

There was no error when approved from application notification work list.

The issue can be reproduced at will with the following steps:
1. View the activity history in the Workflow Monitor for the journals approved from Email notification.


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