A Warning Message Is Logged When More Than One FA Pending Exists At A Premise
Last updated on NOVEMBER 04, 2016
Applies to:Oracle Utilities Customer Care and Billing - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
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
Parameter 1 (Char)'0783900067'
Parameter 2 (Char)'P '
with last row return values:
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