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 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.

Symptoms

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.

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