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