My Oracle Support Banner

MDM UTs Error And Rollback For Multi-item Based Billing Item Counts Over 99,999 (Doc ID 2505796.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Utilities Meter Data Management - Version 2.1.0.3 and later
Information in this document applies to any platform.

Symptoms

On : 2.1.0.3 version, Usage

MDM UTs error and rollback for multi-item based billing item counts over 99,999

When billing a customer via a multi-item SP for specific items using the "Get Item Counts and Consumption" usage rule, the Usage Transaction errors if you have a fractional item count or an item count over 5 digits. The SP allows a user to save the fractional and 6+ digit item counts on the SP. However any UT created from a Usage Subscription with these SPs fails to retrieve the bill determinants. See error messages below when an SP has an item count of 2.5 and 100,000, respectively.


Unexpected error during request processing. (Server Message)
Category: 11001
Number: 108
Call Sequence:
Program Name: ServiceBeanSessionHelper$1$1
Text: Value (100,000) for field Item Count is too large. The maximum precision is 5.
Description: A value was being set that exceeded the maximum allowable field precision.
Table: D1_USAGE_PERIOD_ITEM_DET
Field: ITEM_COUNT


ERROR
-----------------------

Value (100,000) for field Item Count is too large. The maximum precision is 5.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Create SP with line Multi-Items using Count of over 100,000
2) Create Usage Transaction for this SP
3) Get Error: Value (100,022) for field Item Count is too large. The maximum precision is 5.



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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