My Oracle Support Banner

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

Last updated on MARCH 26, 2019

Applies to:

Oracle Transportation Management - Version 6.2.0 to 6.2.4 [Release 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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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