My Oracle Support Banner

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

[CobolThread 23] ERROR (com.splwg.base.support.cobol.DBLocalCobolSQLProcessBackend) more than one row returned from select statement with SQL:
'SELECT DISTINCT PREM.PREM_ID FROM CI_SA SA, CI_SA_SP SASP, CI_SP SP,
CI_PREM PREM WHERE SA.ACCT_ID = ? AND SA.SA_STATUS_FLG IN (? , ?) AND
SA.SA_ID = SASP.SA_ID AND SASP.SP_ID = SP.SP_ID AND SP.PREM_ID =
PREM.PREM_ID' with bind parameters:
Parameter 1 (Char)'0238630000'
Parameter 2 (Char)'20'
Parameter 3 (Char)'30'
 with last row return values:
 (String) '7533223444'

 
 
 
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

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
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.