My Oracle Support Banner

Error While Trying To Complete Work Order In Oracle EAM. (Doc ID 2524963.1)

Last updated on FEBRUARY 10, 2021

Applies to:

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


When attempting to complete a Work Order, the following error occurs.


1. ORA-01422: exact fetch returns more than requested number of rows in Package EAM_Meter_Pub Procedure update_meter
2. Cannot complete work order (NNNNN) as error has occurred while disabling counter hierarchy


The issue can be reproduced at will with the following steps:
Error while trying to complete Work Order – NNNNN
1. Path – EAM Self Service Workbench > Click Home > Choose Organization = FTT from LOV and click Go
2. Click on Work Orders Tab > Enter Work Order Number = NNNNN and Click Go
3. Select Work Order radio button > Choose Complete Work Order from LOV > Populate the source meter values (from LOV) and click Apply.




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.