Questions on CREATE_CMT_PROCEDURE.sql (Doc ID 2042802.1)

Last updated on JUNE 22, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and later
Information in this document applies to any platform.

Goal

On : 7.5 PS10, 11 and 12, Conversion Manager

Clarification on create_cmt_procedure.sql

We are upgrading from 7.5-PS4 to 7.5-PS10 and in one of the post installation steps mentioned in Installation Guide -

"Configuring Conversion Manager to Migrate the /purchased_bundle_t Class from a Legacy Database to the BRM Database"

1.Go to the BRM_Home/sys/dd/data directory.
2.Run the following command, which opens SQL*Plus:
sqlplus login/password@database_alias
where:
■login is the login name to use for connecting to the BRM database.
■password is the encrypted password for login.
■database_alias is the BRM database alias.
3.Run the following command:
SQL>@ create_cmt_procedure.sql
The stored procedure is loaded.
4.Run the following command, which exits SQL*Plus:
SQL>exit


However create_cmt_procedure.sql doesn't exist at mentioned path BRM_Home/sys/dd/data directory. why?

Can you please confirm if we need to execute "create_cmt_procedure_oracle.sql" and on each DB schema as we have BRM multischema setup ?


 

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