Loading Of Delayed Event Is Failing Because Of Pin_rel Procedure Error ORA-06502 (Doc ID 1331201.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.
*** Checked for relevance on 22-May-2013 ***
*** Checked for relevance on 14-Mar-2015 ***

Goal

When trying to load pre-rated data from the pipeline output into the database using REL, the event is getting generated into database but the procedure pin_rel is failing with the following log:

ORA-06512: at "BRM3.PIN_REL", line 2841
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "BRM3.PIN_REL", line 3388
ORA-20014: Error -6502 occurred in the update item balances ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "BRM3.PIN_REL", line 2841
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 1

Solution

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