Upgrade to 12.2 & higher fails with "ORA-14080: partition cannot be split along the specified high bound ORA-06512: at line 25" (Doc ID 2692376.1)

Elapsed: 00:00:00.02
23:10:55 SQL>
23:10:55 SQL> Rem ===========================================================================
23:10:55 SQL> Rem End Bug#8710750  changes: split WRH$_SQLTEXT table to avoid ref counting
23:10:55 SQL> Rem contention.
23:10:55 SQL> Rem ===========================================================================
23:10:55 SQL>
23:10:55 SQL> Rem ===========================================================================
23:10:55 SQL> Rem Check for missing partitions for WRH$_MVPARAMETER, and create if required
23:10:55 SQL> Rem ===========================================================================
23:10:55 SQL>
23:10:55 SQL> -- create missing partition if needed
23:10:55 SQL> declare
23:10:55   2   l_dbid number;
23:10:55   3   partcnt1 number;
23:10:55   4   partcnt2 number;
23:10:55   5   sqlstr varchar2(1000);
23:10:55   6  begin
23:10:55   7   select dbid into l_dbid from v$database;
23:10:55   8  
23:10:55   9   select count(*) into partcnt1 from dba_tab_partitions
23:10:55  10   where table_name = 'WRH$_MVPARAMETER'
23:10:55  11   and partition_name = 'WRH$_MVPARAMETER_MXDB_MXSN';
23:10:55  12  
23:10:55  13   select count(*) into partcnt2 from dba_tab_partitions
23:10:55  14   where table_name = 'WRH$_MVPARAMETER'
23:10:55  15    and partition_name like 'WRH$_MVPARA_' || l_dbid || '%';
23:10:55  16  
23:10:55  17   if (partcnt1 = 1 and partcnt2 = 0) then
23:10:55  18   sqlstr := 'alter table WRH$_MVPARAMETER ' ||
23:10:55  19    'split partition WRH$_MVPARAMETER_MXDB_MXSN at ' ||
23:10:55  20    '(' || l_dbid || ',MAXVALUE) into ' ||
23:10:55  21    '(partition WRH$_MVPARA_' || l_dbid || '_0, ' ||
23:10:55  22    ' partition WRH$_MVPARAMETER_MXDB_MXSN)' ||
23:10:55  23    ' update indexes';
23:10:55  24  
23:10:55  25   execute immediate sqlstr;
23:10:55  26   end if;
23:10:55  27  end;
23:10:55  28  /
declare
*
ERROR at line 1:
ORA-14080: partition cannot be split along the specified high bound
ORA-06512: at line 25

Identifier CATPROC 20-07-09 11:10:55
SCRIPT    = [/ORACLE/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/a1102000.sql]
ERROR     = [ORA-14080: partition cannot be split along the specified high bound ORA-06512: at line 25
]