OTM Migration errors - Errors for TRIGGER TG_ARCH_SHIPMENT (Doc ID 416073.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 5.0 to 5.0
This problem can occur on any platform.

Symptoms

Client migrating from version 4.5 to version 5.0 may report the following error being generated in the dbupdate, dbmigrate and dbpatch logs.

TG_ARCH_SHIPMENT TRIGGER
Errors for TRIGGER TG_ARCH_SHIPMENT:
10/2 PL/SQL: ORA-00936: missing expression

7/3 PL/SQL: SQL Statement ignored

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