My Oracle Support Banner

System Error and "Schema data type 'NUMBER'" Error in Log when Billing Items in C2M (Doc ID 2761793.1)

Last updated on JUNE 04, 2024

Applies to:

Oracle Utilities Customer to Meter Base - Version to [Release 2.7]
Information in this document applies to any platform.


System Error when billing items in C2M

Getting a System Error message when trying to generate a bill segment for an item-based rate in C2M. As a result, we are not able to bill any accounts that have area lights or streetlights service.

The system creates a usage transaction with the right multi-item details, but the usage request is not being linked to the bill segment and is not updated with the multi-item detail from the usage transaction.

   com.splwg.shared.common.LoggedException: Schema data type 'NUMBER' but
trying to retrieve 'STRING' for field 'seq' in schema md

   <itemDetailsList type="list">

     <seq mdField="SEQ_NUM" dataType="number" isPrimeKey="true"/>

     <itemId mdField="ITEM_ID"/>

     <itemType mdField="ITEM_TYPE_CD" isPrimeKey="true"/>

     <itemCount mdField="ITEM_CNT" dataType="number"/>

     <startDateTime mdField="START_DTTM" dataType="dateTime"/>

     <endDateTime mdField="END_DTTM" dataType="dateTime"/>

     <qty mdField="SVC_QTY" dataType="number"/>

     <uom mdField="UOM_CD"/>


The issue can be reproduced at will with the following steps:
1. Create a SP with items and set it up to bill in C2M
2. Create a bill and get error returned.





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.