BRM Multischema Functionality Missing Grant After Schema Additions on BRM 7.5 PS8 (Doc ID 1923684.1)

Last updated on JULY 20, 2017

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.

Symptoms

On BRM 7.5PS8, Multischema Installation

Issue:

BRM multischema functionality did not worki properly after schema additions on BRM 7.5 PS8 due to missing grants. It was preventing the creation of accounts on multi schema environment.

Error as follows:
           =ORA-01031: insufficient privileges


Description:

Followed the instructions in the documentation section - "Installing a Multischema System: Task List" to add new schemas to the multischema setup, a lot of grants were missing for the secondary schemas, which caused errors and failures to create a new account.

 

Changes

 

Cause

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