Wifp_meter_reading_interface batch log error: Error in . ORA-0000: normal, successful completion (Doc ID 1490284.1)

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Utilities Work and Asset Management - Version 1.9.0 and later
Information in this document applies to any platform.

Symptoms

After the upgrade to Version 1.9, the log for the batch job wifp_meter_reading_interface procedure no longer logs how many asset records in the sa_runtime_log table were just updated or number of errors created. Now the log always reads:

ERROR
-----------------------
'Error in . ORA-0000: normal, successful completion' -- every day.

The records are processing correctly, but the success failure count is not recorded


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Populate a record in the interface the table WAIF_METER_READING with valid data
2. Run the batch job wifp_meter_reading_interface
3. Confirm that the record was inserted in the Runtime Entry module (SA_RUNTIME_LOG)
4. Check the batch log- instead of showing a success count of 1 record, shows Error in . ORA-0000: normal, successful completion' --


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