In MFS Multiplatform (Build 12.1.3.11.0) Not Able To Upload Counters That Have No History

(Doc ID 1935958.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Mobile Field Service - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Multiplatform iOS General

ACTUAL BEHAVIOR
---------------
Testing new counter functionality on MFS Multiplatform release 12.1.3.11.0, and find that downloading\uploading counter information is not consistent

EXPECTED BEHAVIOR
-----------------------
Expect consistent counter behavior.

ERROR
----------
select payload from CSM_HTML5_PARSED_DATA where session_id=2875 and sequence=1
result will be a clob and fetch the xml inside....

  <NET_READING>NaN</NET_READING>
  <LIFE_TO_DATE_READING>NaN</LIFE_TO_DATE_READING>

select * from CSM_HTML5_PARSED_DATA order by creation_date desc;
   Status: PARSE_ERROR

STEPS
-----------------------
The issue can be reproduced with the following steps:
Test case 1.
Have three tasks that have counter history. Was able to view counter history and update new reading for one task.
For the other two tasks, the counter icon was not enable on the mobile app.

Test case 2.
Task has no history, Counter icon appears on mobile app,
User add new counter reading and sync.
Receive a parsing error. Query the CSM_HTML5_PARSED_DATA table, in comments field it reads ORA-01722: invalid number”

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