Error in update_bill_closed_t.source Execution During 7.5 PS15 and 7.5 PS17 Upgrade (Doc ID 2272440.1)

Last updated on JUNE 15, 2017

Applies to:

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

Symptoms

When installing Oracle Communications Billing and Revenue Managment (BRM) 7.5.0 patchset 15, the follow error occurs during the execution of update_bill_closed_t.source:

DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 39

<Note 2161375.1> suggested to change partition_data variable to be larger (e.g 20,000), since the variable's current size is too short for some customer metadata.  After the change, the same error could still occur and it was determined that the the bill_t metadata was even larger (around 600,000 characters).  Since partition_data variable only accept 32,767 characters, it is not possible to run this script given the table metadata size.

Changes

 

Cause

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