A Warning Message Is Logged When More Than One FA Pending Exists At A Premise (Doc ID 1632809.1)

Last updated on NOVEMBER 04, 2016

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.4.0.1.0 and later
Information in this document applies to any platform.

Goal

When more than one field activity exists at a premise in pending state even though they are of different FA types, a warning message appears in the log.

Steps to replicate:

1) Navigate to a Premise page which has a V structure.
2) Add an FA in pending state on the premise.
3) Add another FA in pending state on the same premise.

The following message appears in the weblogic log,

SYSUSER - 660578-20339-1 2013-12-06 10:53:23,557 [Parent Reader:Thread-47]
WARN (support.cobol.DBLocalCobolSQLProcessBackend) more than one row
returned from select statement with SQL:
  'SELECT FA.FA_ID, FATYPE.EXT_SERV_REQ_FLG FROM CI_SP SP, CI_FA FA,
CI_FA_TYPE FATYPE WHERE SP.PREM_ID = ? AND FA.SP_ID = SP.SP_ID AND
FA.FA_STATUS_FLG = ? AND FATYPE.FA_TYPE_CD = FA.FA_TYPE_CD ORDER BY CRE_DTTM
DESC /* SQL for COBOL program 'CIPCCCAL', SQL name 'S_FACPNDX' */' with bind
parameters:
Parameter 1 (Char)'0783900067'
Parameter 2 (Char)'P '
 with last row return values:
 (String) '0783900983'
 (String) 'C1NO'
 

Solution

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