After 6.2 To 7.0 Upgrade, The Schema Is Not Upgraded Properly

(Doc ID 558489.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.0
This problem can occur on any platform.

Symptoms

Problem Statement:


After a 6.2 to 7.0 upgrade, the schema is not upgraded properly.

While validating the schemas after upgrade with OOB 7.0 schema, the following issues are found.
1. Old (unused) tables/columns are not dropped (there is no script for dropping tables)
2. Some tables are not created.
3. Data type mismatch found.

 Steps To Reproduce:

1. Installed 6.2_SP1_EBF_Infranet.zip (executed pin_setup.bat)
2. Installed I6.2_SP4_Infranet.zip (executed pin_sp_setup_sql.pl)
3. Installed 7.0_EBF_Infranet_Base.zip
4. Installed 7.0_EBF_62_70_SqlUpg.zip (executed upgrade.pl)
5. executed pin_setup.bat


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