My Oracle Support Banner

During 11.5.8 upgrade to 11.5.10.2, u3480000.drv is erroring out while running ontup260.sql with ORA-01733 error (Doc ID 333799.1)

Last updated on JULY 19, 2021

Applies to:

Oracle Order Management - Version 11.5.8 to 11.5.10.3 [Release 11.5.8 to 11.5.10]
Information in this document applies to any platform.
u3480000.drv
ontup260.sql

Symptoms

During upgrade from 11.5.8 to 11.5.10.2, u3480000.drv is erroring out while
running ontup260.sql

Error showing in adworker log :

AD Worker error:
The following ORACLE error:
ORA-01733: virtual column not allowed here

occurred while executing the SQL statement:

INSERT into oe_system_parameters_all ( org_id, creation_date, created_by,
last_update_date, last_updated_by, master_organization_id ) select org_id,
creation_date, created_by, last_update_date, last_updated_by,
master_organization_id from oe_system_params_upg where rowid = ( select
rowid from oe_system_params_upg b where b.org_id =
oe_system_params_upg.org_id and RTRIM ( b.org_id ) is not null and
rownum=1 )

Error occurred in file
/oracle8/oracle/sav11appl/ont/11.5.0/patch/115/sql/ontup260.sql
with arguments ''.

Verified the issue by the adworker log file <abc.txt>, which displays the error coming from
ontup260.sql

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


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