My Oracle Support Banner

Value (1 000) For Field Sequence Is Too Large. The Maximum Precision Is 3. (Doc ID 2230699.1)

Last updated on SEPTEMBER 26, 2022

Applies to:

Oracle Utilities Meter Data Management - Version to [Release 2.1]
Information in this document applies to any platform.


Oracle Utilities Meter Data Management version, the Value (1 000) for field Sequence is too large. The maximum precision is 3.

There is a restriction in number of rows of D1_USAGE_SCALAR_DTL table. An error is generated when trying to calculate a big industrial customer and the system can`t save the usage transaction. For example, if 4 values are generated per Measuring Component and we have one per SP and 334+ SPs on a single bill, we would run into this issue.


Value (1 000) for field Sequence is too large. The maximum precision is 3.

The issue can be reproduced at will with the following steps:
1. Create a US with lots of SPs in this case 335
2. Create Usage Rules such that 4 values are generated to Usage Scalar Details for each SP.
3. Attempt to calculate a Usage Transaction - because over 999 Usage Scalar Detail lines are generated, the UT will fail with above error



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.