Value (1 000) For Field Sequence Is Too Large. The Maximum Precision Is 3.
Last updated on FEBRUARY 13, 2017
Applies to:Oracle Utilities Meter Data Management - Version 220.127.116.11 and later
Information in this document applies to any platform.
Oracle Utilities Meter Data Management version 18.104.22.168, 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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms