My Oracle Support Banner

Performance Issue When Using WO Advanced Search With Include Asset Children=Yes After Applying Patch 14017681 (Doc ID 1596820.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


Performance Issue when using Work Order Advanced Search with condition of "Include Asset Children"=Yes after applying RUP#14017681 in Production

Maintenance Super User > Work Orders > Advanced Search > Choose any criteria (eg Asset Number=DXC) AND choose "Include Asset Children"=Yes > Go
The query will run for 5 minutes and time out

This functionality last working correctly before applying RUP#14017681.

There are no personalization and/or customization in place.

Have applied Patch 16232651:R12.EAM.B but it did not resolve the issue


Applied patch 14017681


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.