Replication of CCS Data Failing with Oracle Error "ORA-01843: not a valid month"
(Doc ID 2478872.1)
Last updated on MARCH 25, 2019
Applies to:Oracle Communications Network Charging and Control - Version 4.3.0 to 188.8.131.52.0 [Release 4.3 to 12.0.0]
Oracle Communications Convergent Charging Controller - Version 6.0.0 to 184.108.40.206.0 [Release 6.0 to 12.0.0]
Information in this document applies to any platform.
On all versions of Oracle Communications Network Charging and Control (OCNCC or NCC) and Oracle Communications Convergent Charging Controller (OC3C or 3C) up to and including 220.127.116.11, an issue can occur when creating a new subscriber in the Charging Control Services (CCS) Subscriber Management screens resulting in the row not replicating to the Service Logic Controllers (SLCs) and Voucher Wallet Servers (VWS').
The following error is logged by the updateLoader processes:
Here the ACS_CUST_ID is NULL in bad example and the rest of the fields are shifted by 1 and as a result, the Calling Line Identifier (CLI) is interpreted as the CREATION_DATE which is causes the ORA error when the updateLoader tries it commit the value to a column with a DATE datatype.
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