Issue With Patch 7594320 While Upgrading Pipeline From BRM 7.3 to BRM 7.4 (Doc ID 1096062.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 08-Oct-2013***

Goal

During the pipeline upgrade from BRM 7.3 to BRM 7.4 using <Patch 7594320>, we encounter an issue running the 'pin_731_74_pipeline_upgrade.pl' due to DD_OBJECTS_T table.

The error is:


ERROR at line 1:
ORA-20002: SCRIPT FAILED WITH THE ERRORORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "TEST09_IFW.ADD_NEW_COLUMNS_74", line 766
ORA-04063: package body "TEST09_IFW.PIN_UPG_COMMON" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"TEST09_IFW.PIN_UPG_COMMON"
ORA-06512: at line 1


Why is the pipeline upgrade script referring to an BRM base-server table?

Steps to reproduce

1) Install Patch 7594320.
2) Go to $IFW_HOME/upgrade and update information about the databases section with Pipeline DB details in file IFW_HOME/upgrade/pin_setup.values
3) cd IFW_HOME/upgrade/731_74
4) run perl script pin_731_74_pipeline_upgrade.pl

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