Not Able to Create BRM Database Objects with Size Greater than 30 Characters After BRM 12PS2 Upgrade (Doc ID 2675333.1)

Last updated on MAY 29, 2024

Applies to:

Goal

An user is implementing the Billing and Revenue Management (BRM) upgrade from 7.5 PatchSet (PS)17 with Database version 12.1 to 12 PS2 with Database version 12.2.

When running the Database upgrade steps, a couple of procedures are in an invalid state, since the procedures are using identifier which is greater than 30 characters, and the compatible parameter is still showing 12.1 in the user's Database.

From the 12.2 Database document, it seems the Database objects can be created with size greater than 30 characters only if the Database compatible parameter is set to 12.2.

Please confirm if the compatible parameter can be set to 12.2, because this parameter cannot be reversed once it is set to 12.2.
 

Solution

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