OWNER Columns Missing In Tables EXTERNAL_PREDICATE And TABLE_SET_DETAIL In ROD Database (Doc ID 1360759.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 6.2.0 to 6.2.4 - Release: 6.2 to 6.2
Information in this document applies to any platform.

Symptoms

When attempting to upgrade the production environment from 6.1.0 to 6.2.1, the OWNER column for tables EXTERNAL_PREDICATE and TABLE_SET_DETAIL was not added for glogowner in ROD

-- Steps
1. Follow the upgrade steps to move to OTM Version 6.2.1.
2. In the aa_dbupdate_60 log it will show that the update was applied yet did not throw an ORA error.
3. Verify that the column did not load by looking at the dbpatch_60 log.  You should see something like the following:

START of preupdate9304023a 12:57:01
BEGIN add column of EXTERNAL_PREDICATE.OWNER
END add column EXTERNAL_PREDICATE.OWNER.............................0 Sec
BEGIN add column of TABLE_SET_DETAIL.OWNER
END add column TABLE_SET_DETAIL.OWNER...............................0 Sec
END of preupdate9304023a Elapsed Time: 1 Sec

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