Error in update_bill_closed_t.source Execution During 7.5 PS15 and 7.5 PS17 Upgrade
Last updated on JUNE 15, 2017
Applies to:Oracle Communications Billing and Revenue Management - Version 220.127.116.11.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.
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