My Oracle Support Banner

JBO-27122: SQL Error During Statement Occurs Viewing Activity History In Status Monitor (Doc ID 1944868.1)

Last updated on FEBRUARY 28, 2023

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.

Symptoms

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.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.