Oracle Revenue Management and Billing (ORMB) Direct Upgrade From 2.6.0.1 To 2.9.0.0 Failed (Doc ID 2743504.1)

Last updated on JANUARY 15, 2021

Applies to:

Goal

On : 2.9.0.0.0 version, ENV - Environment

We are working on a direct upgrade from ORMB 2.6.0.1 to ORMB 2.9.0.0. We successfully completed the Framework (FW) upgrade and applied the FW rollup pack. There were no errors while applying FW and the FW rollup. During the ORMB 2.9.0.0 upgrade we were getting below two errors at the at initial stage. How do we to resolve the below errors?


Errors:

1. Caused by: Error : 904, Position : 170, Sql = UPDATE ci_prce_calc_ln pcl

ORA-00904: "PC"."REPRC_ENTITY_ID": invalid identifier

2. 2020-12-23 16:09:04,405 [main] ERROR (oem.install.OraDBI) Error while executing SQL: StmtType-U, Stmt-INSERT INTO C1_DRR_TMPLT_DIV(DRR_TEMPLATE_CD,VERSION,CIS_DIVISION) SELECT DRR_TEMPLATE_CD,VERSION,CIS_DIVISION FROM C1_DRR_TMPLT WHERE NOT EXISTS(SELECT * FROM C1_DRR_TMPLT_DIV WHERE (C1_DRR_TMPLT_DIV.DRR_TEMPLATE_CD=C1_DRR_TMPLT.DRR_TEMPLATE_CD and C1_DRR_TMPLT_DIV.CIS_DIVISION=C1_DRR_TMPLT.CIS_DIVISION))
 

  - 2020-12-23 16:09:04,406 [main] ERROR (oem.install.OraDBI)

  java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
 

Solution

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