My Oracle Support Banner

GSCC Error Report - Section 25 - Column Type Should Not Be ROWID (GL Table) (Doc ID 2664448.1)

Last updated on APRIL 29, 2020

Applies to:

Oracle Property Manager - Version 12.2.9 and later
Information in this document applies to any platform.

Goal

Upgrading from 12.1.3 to 12.2.9. Ran the GSCC Report. The following entry is showing for 2 GL tables.

Please advise if fix is needed of if this can be ignored.

DOC> **********************************************************************
DOC> SECTION-25 [minimal]
DOC> **********************************************************************
DOC> "Column Type should not be ROWID."
DOC>
DOC> - P2: Stored ROWID references may be broken when tables are patched.
DOC> - Fix: Re-design table to reference the target table primary key.
DOC> - Unused columns or columns that only store the ROWID temporarily
DOC> can be ignored.
DOC> Note: this check does not work prior to Online Patching Enablement.
DOC>#

OWNER TABLE_NAME COLUMN_NAME DATA_TYPE
---------------- ------------------------------ ------------------------------ ------------------------------
PN PN_GL_BC_PACKETS_29485607 ORIGINATING_ROWID ROWID
PN PN_GL_BC_PACKETS_HIST_29485607 ORIGINATING_ROWID ROWID
 

Solution

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
Goal
Solution


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