19c :Upgrade or postupgrade_fixups.sql fails with error "ORA-04023" (Doc ID 2650211.1)

Identifier CATPROC 22-11-02 07:12:37
SCRIPT = [/u01/app/oracle/product/19.3.0.0/db_3/rdbms/admin/depssvrm.sql]
ERROR = [ORA-04023: Object SELECT /*CROSSCON*/ /* */ /*"K"*/ /* ID */ * FROM "SYS"."DBA_AUTOTASK_TASK" could not be validated or authorized
ORA-06512: at "SYS.CDBVIEW_INTERNAL", line 93
ORA-06512: at "SYS.CDBVIEW", line 6
ORA-06512: at line 1
]
STATEMENT = [BEGIN CDBView.create_cdbview(false,'SYS','DBA_AUTOTASK_TASK','CDB_AUTOTASK_TASK'); END;
]
..

 

SQL> @postupgrade_fixups.sql

..

..

Package body created.

No errors.

DECLARE

*

ERROR at line 1:

ORA-04023: Object with

segments as (select tablespace_name, inuse from(

select ds.tablespace_name,

row_number() over (partition by tablespace_name order by 1) rn,

round(nvl(sum(ds.bytes) over (partition by ds.tablespace_name),0)/:a,2) as inuse

from sys.dba_segments ds) where rn =1 ),

ts_qresult as (

SELECT /*+ MATERIALIZE */

dt.tablespace_name as name,

dt.contents could not be validated or authorized

ORA-06512: at "SYS.DBMS_PREUP", line 4086

ORA-06512: at "SYS.DBMS_PREUP", line 10540

ORA-06512: at line 11

Session altered.