My Oracle Support Banner

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.

Symptoms

When attempting to perform a simple search via OAF, the following error occurs.

ERROR

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,
  wdj.DESCRIPTION,
  wdj.STATUS_TYPE,
  decode(wdj.FIRM_PLANNED_FLAG,1,'Yes','No') as firm_planned_flag,
  decode(wdj.notification_required,'Y','Yes','No') as notification_required,
  wdj.SCHEDULED_START_DATE,
  wdj.SCHEDULED_COMPLETION_DATE,


STEPS

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.

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.