Upgrading from OTM 5.5 to 6.x, Receiving Errors from Dbupdate_60 Log File (Missing Objects In ROD) (Doc ID 1530321.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version 6.0 and later
Information in this document applies to any platform.

Symptoms

On OTM 6.0 the following error s are seen:

 

Problem Summary
---------------------------------------------------
Errors in dbupdate_60 log file due to missing Objects in ROD

In the dbupdate_60.log file, there are many success statements for triggers like this:

TG_ARCH_INVOICE                TRIGGER

There are also a number of errors like this:

Errors for TRIGGER TG_ARCH_ALLOCATION:                                                                                  
34/2            PL/SQL: ORA-00904: "TOTAL_ALLOC_C_FN_CURRENCY_GID": invalid identifier                                  
                                                                                                                        
7/3             PL/SQL: SQL Statement ignored  

Problem Description
---------------------------------------------------
This is encountered during a database upgrade from 5.5 to 6.x, while running the dbupdate_60.sh script. The script may fail to compile some of the triggers on the OLTP database due to this problem.

Changes

 Upgrading OTM / FTI database from 5.5 to 6.x

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