Error in update_bill_closed_t.source Execution During 7.5 PS15 and 7.5 PS17 Upgrade
(Doc ID 2272440.1)
Last updated on AUGUST 17, 2018
Applies to:Oracle Communications Billing and Revenue Management - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
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:
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!