My Oracle Support Banner

Card Number Search in Customer Care Portal (CCP) Dashboard Screen Failed with ORA-01006 (Doc ID 1326849.1)

Last updated on MARCH 25, 2019

Applies to:

Oracle Communications Network Charging and Control - Version 3.1.0 and later
Information in this document applies to any platform.

Symptoms

To open CCP Dashboard screen, login to the Service Management System (SMS) screen and navigate to the following screen:
Services -> CCP Dashboard


Here is an example search panel on the CCP Dashboard screen:

When searching on Card Number and Show Linked Subscribers option is selected, following Java SQL Exception error was thrown:
"ORA-01006: bind variable does not exist"

The available search fields as shown on search panel will depend on how your system has been set up. A maximum of four search fields may be available. This is configurable via SMS -> Services -> Subscriber Profile Manager -> CCP Dashboard Config.

Example search fields are:
• Card Number
• Customer
• Subscriber Id
• Wallet Reference

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.