EM 13c: OMS RU patching fails with error ORA-01422: exact fetch returns more than requested number of rows (Doc ID 3007240.1)

Updating repository with RCU reference file "<OMS_HOME>/.omspatcher_storage/35854889_Dec_26_2023_03_38_24/original_patch" for plugin home "<OMS_HOME>/plugins/oracle.sysman.db.oms.plugin_13.5.1.0.0"

Some error occurred during RCU update. Please refer individual log file(s) for details.
Log file location: <OMS_HOME>/cfgtoollogs/omspatcher/2024-02-11_12-25-58PM_SystemPatch_35861059_21/rcu_applypatch_original_patch_2024-02-11_12-36-34PM.log

.....

.....

OMSPatcher failed to execute some of the patching steps. Please check the Patching summary,individual logs and try to resolve the issue. Once the issue is resolved,Please execute below command to complete patching session:
omspatcher resume

------------------------------------------------------------------------------------------------
OMSPatcher wont allow any other patching operations unless the script is executed successfully
------------------------------------------------------------------------------------------------

Log file location: <OMS_HOME><oms_home>/cfgtoollogs/omspatcher/35861059/omspatcher_2024-02-11_11-46-30AM_apply.log

Recommended actions: Please check log file(s) for failed RCU artifact action(s) and contact Oracle Support with the logs.

OMSPatcher failed with error code 245

Repository ApplyRepositoryPatch in progress.
Executing pre create operations
Percent Complete: 55
Percent Complete: 58
Percent Complete: 61
Percent Complete: 64
Percent Complete: 67
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 27
File:<OMS_HOME>/plugins/oracle.sysman.db.oms.plugin_13.5.1.0.0/sql/db/upgrade/emwh_data_upgrade.sql

...

...

-- get WH db info from repos
begin
sql_txt := 'select target_guid, db_cred_guid, host_cred_guid from db_caw_repos';
execute immediate sql_txt into l_tgt_guid, l_db_cred_guid, l_host_cred_guid;
exception
when NO_DATA_FOUND then
dbms_output.put_line('AWR Warehouse not configured. Nothing to upgrade.');
return;
end;