Unable To Search Few Work Orders From Application UI

(Doc ID 2401263.1)

Last updated on MAY 26, 2018

Applies to:

Oracle Fusion Manufacturing Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

Custom report is created using following query to obtain a list of Open Work Orders -

select work_order_number from wie_work_orders_b where wie_work_orders_b.CANCELED_DATE is null AND wie_work_orders_b.closed_date is null

However we are unable to query some of the work orders displayed in the report from the UI. What could be the reason behind this?
 

Solution

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