On Work Requests,'Find Duplicate Wrs Or Wos' Does Not Return Approved Wo'S (Doc ID 748723.1)

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Utilities Work and Asset Management - Version: 1.7.10.1
This problem can occur on any platform.

Symptoms

The “Find Duplicate Work Requests or Work Orders” action does not find duplicate Work Orders
that are in APPROVED status. The View SV_REQUEST_WO_WIZARD's clause WHERE TASK_STATUS IN ('PLANNING','ACTIVE') should be WHERE TASK_STATUS IN ('PLANNING','ACTIVE',‘APPROVED’)

Steps to Reproduce:

Create a Work Request for an Asset.
Create a Work Order against the SAME Asset. Leave it in Planning status.
On the Work Request select the “Find Duplicate Work Requests or Work Orders” action. The Work
Order is displayed.
Change the status of the Work Order to 'Approved,Awaiting Activation'.
On the Work Request select the “Find Duplicate Work Requests or Work Orders” action. The Work
Order is no longer displayed.
Change the status of the Work Order to Active
On The Work Request select the “Find Duplicate Work Requests or Work Orders” action. The Work
Order is once again displayed.


Cause

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