My Oracle Support Banner

Execution of and Failed as Part of 7.5 PS10 Upgrade. (Doc ID 1999865.1)

Last updated on AUGUST 27, 2023

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.5.0]
Information in this document applies to any platform.



On Oracle Communications Billing and Revenue Management (BRM) version, 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 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?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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