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 22.214.171.124.0 to 2.3.1 [Release 2.2 to 2.3]
Information in this document applies to any platform.
**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.
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.
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