My Oracle Support Banner

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

Last updated on MARCH 25, 2019

Applies to:

Oracle Utilities Work and Asset Management - Version 1.7.10.1 and later
Information in this document applies to any platform.
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.


Changes

 

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
Changes
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.