Query Work Order OAF Form Errors Out
(Doc ID 2699471.1)
Last updated on AUGUST 18, 2020
Applies to:Oracle Enterprise Asset Management - Version 12.2.6 and later
Information in this document applies to any platform.
When attempting to perform a simple search via OAF, the following error occurs.
You have encountered an unexpected error....
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT *
FROM (SELECT wdj.WIP_ENTITY_ID,
decode(wdj.FIRM_PLANNED_FLAG,1,'Yes','No') as firm_planned_flag,
decode(wdj.notification_required,'Y','Yes','No') as notification_required,
The issue can be reproduced at will with the following steps:
1. Responsibility: Maintenance super user.
2. Navigation: Home->Work Orders->All.
3. Click on the ton with no filter.
4. The aforementioned error occurs.
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