EMCC/OMS ORA-06533 ORA-06512: at “SYSMAN.NZDT_ADD_OMS_JOB” during RU patching

Got the following error during the latest step the EM13.5 RU17 patching.

[Oct 3, 2023 8:17:46 AM] DB user name: sysman is used for db connection
[Oct 3, 2023 8:17:47 AM] Executing submit job ….
[Oct 3, 2023 8:17:48 AM] ORA-06533: Subscript beyond count
ORA-06512: at "SYSMAN.NZDT_ADD_OMS_JOB", line 36
ORA-06512: at line 1

Issue is that the system believe that the configuration is multiOMS when it is not. Indeed, the number of OMS has been reduced into this environment.
Solution is to delete the reference to the former OMS in the mgmt_oms_parameters and mgmt_emrep_oms_name tables

#1 Check these tables

select * from mgmt_oms_parameters;
select * from mgmt_emrep_oms_name; 

#2 Save their content

create table mgmt_oms_parameters_bkp as select * from mgmt_oms_parameters; create table mgmt_emrep_oms_name_bkp as select * from mgmt_emrep_oms_name; 

#3 Run the datafix

delete from mgmt_oms_parameters where host_url='<oldOMS>:4889_Management_Service';
delete from mgmt_emrep_oms_name where oms_name='<oldOMS>:4889_Management_Service'