My Oracle Support Banner

12.2 Upgrade Report has ASF Objects with Column Type ROWID. (Doc ID 2899430.1)

Last updated on SEPTEMBER 29, 2022

Applies to:

Oracle Sales Online - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms


ACTUAL BEHAVIOR
---------------
When upgrading to 12.2, the Upgrade Readiness Report is showing several ASF objects with the exception "Column Type should not be ROWID."

 

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
---------------- ------------------------------ ------------------------------ ------------------------------
APPS            ASF_SC_BIN_MV                  AROWID                         ROWID
APPS             ASF_SC_BIN_MV                  BROWID                         ROWID
APPS             ASF_SC_BIN_MV                  CROWID                         ROWID
APPS             ASF_SC_BIN_MV                  DROWID                         ROWID
APPS              ASF_SL_BIN_MV                  AROWID                         ROWID
APPS             ASF_SL_BIN_MV                  BROWID                         ROWID
APPS             ASF_SL_BIN_MV                  CROWID                         ROWID
APPS            ASF_SL_BIN_MV                  DROWID                         ROWID



EXPECTED BEHAVIOR
-----------------------
The upgrade readiness report should not show any exceptions related to ASF objects.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Run the 12.2 upgrade readiness report.

 

Changes

 Upgrade to 12.2

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
Changes
Cause
Solution


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