Batch Job Reporting Error "more than one row returned from select statement with SQL" For Accounts With Multiple Sites
Last updated on NOVEMBER 18, 2014
Applies to:Oracle Utilities Customer Care and Billing - Version 2.2.0 to 2.3.1 [Release 2.2 to 2.3]
Information in this document applies to any platform.
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.
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