My Oracle Support Banner

Unable to Load Zero Usage CDR/Event Using Pin_rel Command (Doc ID 2834408.1)

Last updated on APRIL 04, 2022

Applies to:

Oracle Communications Billing and Revenue Management - Version and later
Information in this document applies to any platform.


On Billing and Revenue Management (BRM) version

When the first usage of the rated file has zero usage, the following error is logged in pin_rel.pinlog while loading the rated events to BRM using pin_rel command:
Error 01/10/22 1:29:06:0932 PM ( 1641814146932 ) T:Update SP Thread 1 REL RELUpdaterThread 2:<HOSTNAME>:UnknownProgramName:0:Update SP Thread 1:0:1641814146:2::::
ORA-20003: Error -20003 error while processing data from event_essentials occurred in the update procedure: start_obj_id0 = 334286724627561591 end_obj_id0 = 334286724627561591 sqlcode = -20003 sqlerrm = ORA-20003: Failed updating account balances
ORA-06512: at "PINDBASE.PIN_REL", line 6249
ORA-20003: Failed updating account balances
ORA-06512: at "PINDBASE.PIN_REL", line 1496
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "PINDBASE.PIN_REL", line 1369
ORA-06512: at "PINDBASE.PIN_REL", line 1667
ORA-06512: at "PINDBASE.PIN_REL", line 6200
ORA-06512: at line 1


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

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