My Oracle Support Banner

CCS Report Function Does Not Work with Error ORA-02019 (Doc ID 1364979.1)

Last updated on JUNE 17, 2022

Applies to:

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

Symptoms

 

The Service Management Screen has the Report Function which allows you to manage reports on which the data source can be based on various applications, one of them is CCS based report

The Report Function can be accessed via SMS Screen -> Operator Functions-> Report Functions

Note: The time and date used is the system date of the SMF database, which is not necessarily the same as the local time of the user scheduling the report.

On SMS Report Function Screen, you can schedule when that particular report should be generated, it is called Scheduled Report.

When the scheduled report is running, the process will be logged into specific trace file which is located in SMS server on /IN/service_packages/SMS/output directory. The file name will follow the following convention:

smsReport-[Scheduled Report Identity]-[nn].lst

Note:
- Scheduled Report Identity is based on the value of description of Scheduled Report in the screen.
such as TestRun2, SomeReportTest as presented by Image 01
- nn is the sequence number
For more details information about SMS Report Function please refer to SMS User Guide.



The Charging Control Services (CCS) Report Function process terminated with error ORA-02019 as seen by this following trace:

Changes

 

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
Changes
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.