CCB 2.6 Initial Installation Issue While Executing DB Script (Doc ID 2290930.1)

Last updated on AUGUST 08, 2017

Applies to:

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

Symptoms

On : CCB 2.6.0.0.0 version, IP - Installation

CCB 2.6 initial installation issue while executing DB script

Facing issue while executing DB script for initial install on page 23 as per the document.

ERROR
-----------------------
ERROR: ORA-00904: "CTXT_VAL": invalid identifier (DBD ERROR: error possibly near <*> indicator at char 36 in 'select XAI_RCVR_ID, RCVR_CTXT_FLG, <*>CTXT_VAL, F1_CTXT_VAL_LONG, SEQNO from CI_XAI_RCVR_CTX') occured while executing select XAI_RCVR_ID, RCVR_CTXT_FLG, CTXT_VAL, F1_CTXT_VAL_LONG, SEQNO from CI_XAI_RCVR_CTX


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Installing the Oracle Utilities Customer Care and Billing Database Component Using OraDBI.java

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
There is an impact on customer delivery.

Cause

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