Execution of install.sh and pin_75_75ps10_upgrade.pl Failed as Part of 7.5 PS10 Upgrade. (Doc ID 1999865.1)

Last updated on AUGUST 27, 2023

Applies to:

Goal

Qn1:

On Oracle Communications Billing and Revenue Management (BRM) version 7.5.0.10, when upgrading BRM from 7.5 PS4 to 7.5 PS10, the following errors are faced during execution of below mentioned upgrade scripts -

1. Run the install.sh script (which is under section - Upgrading the Schema on Multischema Systems):

It says - '<INTEGRATE ROLE>' does not exist, so possibly ifw_Roles.sql was not executed in past.

1. Shall we comment the creation of <INTEGRATE DB SID> schema which is part of the ifw_Roles.sql and proceed further with execution of ifw_Roles.sql and then 'create_pricing_discountmodel_procedures.plb' because we do not want to create <INTEGRATE DB User> but need the Role '<INTEGRATE ROLE>'?

2. Post this, should we execute 'create_pricing_discountmodel_procedures.plb' on <INTEGRATE DB> (ifw) schema from both application schemas or executing it only once is sufficient?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.