Encountered Service Quantity Not Found In SQ Collection 4, 11240

(Doc ID 2309694.1)

Last updated on SEPTEMBER 22, 2017

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.3.1 to 2.3.1 [Release 2.3]
Information in this document applies to any platform.

Symptoms

On : 2.3.1 version, BI - Billing

ACTUAL BEHAVIOR
---------------
When multiple subsidiary rates are defined on a primary rate schedule, the order in which it is executed is intermittently random.

EXPECTED BEHAVIOR
-----------------------
The sub rate schedule should be retrieved and executed according to its sequence.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Define sub rate schedule Sub Rate A that has SQ Rule that creates an SQI
2. Define another sub rate schedule Sub Rate B that charges the SQI created by the first sub rate
3. Define a primary schedule that references the two sub rates – Sub Rate A sequence 11, Sub Rate B with sequence 12
4. Enable debug trace of SQL and parameters
5. Run rate check
6. Verify that the query S-SUBRS retrieves the sub rates according to sequence defined.
-- In the customer’s scenario, error is encountered because the first sub rate retrieved is SUB-MK instead of SUB-MHRX

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, encountered Service Quantity not found in SQ collection (,,KWHSUM) (4, 11240) when generating a Bill / performing cancel/rebill or even performing a Rate Check .

Cause

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