CCB Customer Information Audit Portal Sql Exception on MSSQL Server (Doc ID 1377120.1)

Last updated on MARCH 29, 2012

Applies to:

Oracle Utilities Customer Care and Billing - Version: 2.3.1 and later   [Release: 2.3 and later ]
Information in this document applies to any platform.

Goal



CC&B: Customer Information Audit Portal SQL Exception on Environment that using MSSQL Server.

Control Central Search -> Select an account -> Main Menu -> Customer Information -> Customer Information Audit Portal -> Select a Maintenance Object -> Press the Refresh button



Category: 11007
Number: 11013
Call Sequence:
Program Name: DataExplorerSQLProcessor
Text: SQL 1: Error executing iterate for rawSQL:
SELECT L.BUS_EVT_LOG_ID , L.LOG_DTTM , L.USER_ID , MO.DESCR as MAINT_OBJ_CD , LTRIM(RTRIM(L.PK_VALUE1)) as PK_VALUE1 , LTRIM(RTRIM(MOPT.MAINT_OBJ_OPT_VAL)) as FK_REF_CD FROM F1_BUS_EVT_LOG L , CI_MD_MO_L MO , CI_MD_MO_OPT MOPT WHERE L.MAINT_OBJ_CD = MO.MAINT_OBJ_CD AND MO.LANGUAGE_CD = ? AND MO.MAINT_OBJ_CD = MOPT.MAINT_OBJ_CD(+) AND MOPT.MAINT_OBJ_OPT_FLG(+) = 'F1FK' AND L.MAINT_OBJ_CD =(?)
with 'FixedCHAR' parameter named 'F1' to : 'ACCOUNT' to indices: 2
with 'FixedCHAR' parameter named 'LANGUAGE' to : 'ENG' to indices: 1
Description: SQL Exception
Table: null
Field: null


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