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:

Symptoms

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.


ERROR
-----------------------
   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"/>

   </itemDetailsList>


STEPS
-----------------------
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.


 

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.