Issue During Upgrade To BRM 7.5 Patchset 4 And Patchset 5 (Doc ID 1552426.1)

Last updated on NOVEMBER 08, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.
***Checked for relevance on 9-FEB-2015***

Goal

Scenario:

* Upgrading from  BRM 7.5 PS2 or PS3 to BRM 7.5 PS4 or PS5

* The file being executed is "pin_75ps5_upgrade.pl" or "pin_75ps4_upgrade.pl"

* We are facing the below error :

console:

################################################
################################################
Started dd_objects_event_def_taxes.source at Thu May 2 10:48:17 2013
Modifying DB Schema...
Loading objects from file /FS/portal/7.5/sys/dd/data/dd_objects_event_def_taxes.source
*** Error: Unable to update the Portal Base database.
  Exiting from the install without finishing successfully.
  Please check for errors in /FS/portal/7.5/tmp/tmp.out
  and then rerun this program.
  

 tmp.out:

Executing sqlplus -s pin/***@pindb < "/opt/portal/7.5/tmp/tmp.sql"

COLUMN_NAME
------------------------------
TAX_CODE

tmp.sql:

select column_name from user_tab_columns where table_name =
upper('EVENT_BILLING_TAXES_T') and column_name = upper('TAX_CODE');
exit;

  

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