Batch Job Reporting Error "more than one row returned from select statement with SQL" For Accounts With Multiple Sites
(Doc ID 1500311.1)
Last updated on SEPTEMBER 25, 2022
Applies to:
Oracle Utilities Customer Care and Billing - Version 2.2.0.0.0 to 2.3.1 [Release 2.2 to 2.3]Information in this document applies to any platform.
Symptoms
**Disclaimer:** This KM article may include the following abbreviations:
CCB/CC&B - Oracle Utilities Customer Care and Billing
OUAF/FW - Oracle Utilities Framework
On CC&B, BT - Batch
The batch job (such as LATEPYMT or WPM) hitting the following SQL error where a number of accounts have multiple active premises connected.
The SQL appears to have been written under the assumption that each Account will only have one active premise connected at a time.
ERROR
-----------------------
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. System contains a number of accounts having multiple active premises connected.
2. Submit the batch(Such as LATEPYMT or WPM) from Main Menu-> Batch-> Batch Job submission+ with batch control name.
3. Error occurred as above and batch job failed.
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |