Usage Transactions for Multi-item Service Points Error and Rollback if the Item Count Contains a Decimal (Doc ID 2478425.1)

Last updated on AUGUST 03, 2022

Applies to:

Symptoms

On : 2.1.0.3 version, Usage

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. The SP allows a user to save the fractional item counts on the SP. However any UT created from a Usage Subscription with these SPs fails to retrieve the bill determinants. See error message below when an SP has an item count of 2.5

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

Unexpected error during request processing. (Server Message)
Category: 11001
Number: 1850
Call Sequence:
Program Name: ServiceBeanSessionHelper$1$1
Text: Input request field Item Count has an invalid value. Invalid numeric value 2.5.
Description:
Table: null
Field: null


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Create SP with Multi-Item entry with Item Count with a decimal, such as 2.5 or 1.75

Link the SP to a Usage Subscription using a Usage Group with Usage Rule "Get Item Counts and Consumption"

Create a Usage Transaction for the new Usage Subscription

Get the error when the UT attempts to calculate - the UT will not be saved

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use fractional numbers for multi-items.  This is required for splitting multi-items between multiple parties.  For example if there is a traffic light and 7 street lights at an intersection bordering two towns, each town might be responsible for .5 of the traffic light and 3.5 of the street lights.  This is a standard concept in multi-item billing.

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.