2783937 - Invalid *HIVE* objects on Oracle upgrade

After completing the upgrade to 18c or higher, when applying SBP catsbp fails and the following invalid object are reported:

SQL> select owner,object_type,object_name from dba_objects where status != 'VALID';

OWNER OBJECT_TYPE OBJECT_NAME
-------------------- ----------------------- ------------------------------
SYS VIEW DBA_HIVE_TABLES
SYS VIEW USER_HIVE_TABLES
SYS VIEW ALL_HIVE_TABLES
SYS VIEW DBA_HIVE_COLUMNS
SYS VIEW USER_HIVE_COLUMNS
SYS VIEW ALL_HIVE_COLUMNS
SYS VIEW DBA_HIVE_DATABASES
SYS VIEW USER_HIVE_DATABASES
SYS VIEW ALL_HIVE_DATABASES
PUBLIC SYNONYM DBA_HIVE_TABLES
PUBLIC SYNONYM USER_HIVE_TABLES
PUBLIC SYNONYM ALL_HIVE_TABLES
PUBLIC SYNONYM DBA_HIVE_COLUMNS
PUBLIC SYNONYM USER_HIVE_COLUMNS
PUBLIC SYNONYM ALL_HIVE_COLUMNS
PUBLIC SYNONYM DBA_HIVE_DATABASES
PUBLIC SYNONYM USER_HIVE_DATABASES
PUBLIC SYNONYM ALL_HIVE_DATABASES
SYS PACKAGE BODY DBMS_HADOOP
SYS PACKAGE BODY DBMS_HADOOP_INTERNAL

Running utlrp doesn't help.

• Oracle 18c or 19c
• Any SAP product
• HPUX, AIX

18c, Invalid Objects, DBA_HIVE_TABLES, USER_HIVE_TABLES, ALL_HIVE_TABLES, DBA_HIVE_COLUMNS, USER_HIVE_COLUMNS, ALL_HIVE_COLUMNS, DBA_HIVE_DATABASES, USER_HIVE_DATABASES, ALL_HIVE_DATABASES, DBMS_HADOOP, DBMS_HADOOP_INTERNAL , KBA , BC-DB-ORA , Oracle , Problem