Upgrade Driver u10124646.drv Fails on Script "'onttab.odf" : Error : ORA-54033: column to be modified is used in a virtual column expression

(Doc ID 2332146.1)

Last updated on NOVEMBER 26, 2017

Applies to:

Oracle Order Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms


As part of the upgrade driver execution , script onttab.odf fails
on the following sql statement

SQL STATEMENT

ALTER TABLE ONT.OE_HOLD_SOURCES_ALL MODIFY (HOLD_ENTITY_ID VARCHAR2(250))

with the following error

ERROR


ORA-54033: column to be modified is used in a virtual column expression

STEPS

This issue is reproducible at will when running the upgrade driver $AU_TOP/patch/115/driver/u10124646.drv




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