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

Last updated on SEPTEMBER 12, 2022

Applies to:

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.

Cause

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