My Oracle Support Banner

Last Service Reading Is Corrupted If PM WO Is Completed Second Time (it Was Uncompleted) (Doc ID 1493634.1)

Last updated on MARCH 01, 2019

Applies to:

Oracle Installed Base - Version 12.1.2 and later
Information in this document applies to any platform.


When re-completing PM WO with the same values and dates entered at the initial completion the Last Service Reading value is corrupted which makes PM Schedule definition for this Asset Number to return following error:

FRM-50016: Legal characters are 0-9 - + E.
ORA-01403: no data found.
An Unexpected Error ORA-6502 has occured.
An alert has been sent to the system administrator.
ORA-01403: no data found.

Steps to Reproduce ###
1. Maintenance Super User responsibility
2. Find some PM Work Order with mandatory meter and open Detail of WO (click the WO Number link)
3. Complete WO - click the "Complete Work Order" button, fill in for example 0 value (New Reading) and press Apply button.
4. Uncomplete WO - Click the "Uncomplete Work Order" button and then click Apply button (meter reading was disabled)
5. Complete WO again - click the "Complete Work Order" button, fill same New Reading Value and Dates like in step 3.
6. New Reading value hasn't been saved in csi_counter_readings, because application found that for this meter with the same timestamp has been already saved the same value (but your code doesn't recognized, that this value has been disabled + logic of procedure CSI_COUNTER_READINGS_PVT.Capture_Counter_Reading() is not correct - the code is finished with exception) -> values for life to date and others are not calculated an defined -> update of table eam_pm_last_service is done with incorrect data -> PM Schedule form is corrupted.

Business Impact:
User cannot check/update PM Schedules if some PM WO caused this issue.




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.