GSCC Error Report - Section 25 - Column Type Should Not Be ROWID (GL Table)
(Doc ID 2664448.1)
Last updated on DECEMBER 19, 2022
Applies to:
Oracle Property Manager - Version 12.2.9 and laterInformation 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 |