Argus Mart initial ETL failed - ODI-1519: Serial step "root_step (InternalID:2)" failed because child step "SCN_exec_etl_custom_hooks_POST_ETL_POPULATION (InternalID:200)" is in error. (Doc ID 2960463.1)

Error:
ODI-1519: Serial step "root_step (InternalID:2)" failed because child step "SCN_exec_etl_custom_hooks_POST_ETL_POPULATION (InternalID:200)" is in error.
ODI-1217: Session SCN_exec_etl_custom_hooks_POST_ETL_POPULATION (14423) fails with return code 20010.
ODI-1226: Step PRC_exec_etl_custom_hooks_POST_ETL_POPULATION fails after 1 attempt(s).
ODI-1232: Procedure PRC_exec_etl_custom_hooks_POST_ETL_POPULATION execution fails.
ODI-1228: Task Procedure-PRC_exec_etl_custom_hooks_POST_ETL_POPULATION-Command 0 fails on the target connection DS_AM_ARGUSMART.
Caused By: java.sql.SQLException: ORA-20010: ORA-01403: no data found
ORA-06512: at "AM_MART_USER.SMQ_PT_UTILS", line 25
ORA-06512: at "AM_MART_USER.EMPIRICA_UTILS", line 6
ORA-06512: at line 1
ORA-06512: at "AM_MART_USER.TRG_SM_ETL_CUSTOM_HOOKS", line 3
ORA-06512: at "AM_MART_USER.PKG_SM_UTIL", line 877

-- ERROR while processing p_exec_etl_custom_hooks at 08-Jul-2023 16:25:32
ORA-06512: at "AM_MART_USER.PKG_SM_LOGGING", line 134
ORA-06512: at "AM_MART_USER.PKG_SM_UTIL", line 905
ORA-06512: at line 3

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1105)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:551)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:656)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:230)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:42)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:929)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1280)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1921)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1876)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:304)
at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:271)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:142)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:28)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)
at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:217)
at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:129)
at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:892)
at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2264)
at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:630)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.access$2700(StartScenRequestProcessor.java:85)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:923)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
Caused by: Error : 20010, Position : 0, Sql = BEGIN
pkg_sm_stage_util.p_set_context(-1);
pkg_sm_util.p_exec_etl_custom_hooks('POST_ETL_POPULATION');
END;, OriginalSql = BEGIN
pkg_sm_stage_util.p_set_context(-1);
pkg_sm_util.p_exec_etl_custom_hooks('POST_ETL_POPULATION');
END;, Error Msg = ORA-20010: ORA-01403: no data found
ORA-06512: at "AM_MART_USER.SMQ_PT_UTILS", line 25
ORA-06512: at "AM_MART_USER.EMPIRICA_UTILS", line 6
ORA-06512: at line 1
ORA-06512: at "AM_MART_USER.TRG_SM_ETL_CUSTOM_HOOKS", line 3
ORA-06512: at "AM_MART_USER.PKG_SM_UTIL", line 877

-- ERROR while processing p_exec_etl_custom_hooks at 08-Jul-2023 16:25:32
ORA-06512: at "AM_MART_USER.PKG_SM_LOGGING", line 134
ORA-06512: at "AM_MART_USER.PKG_SM_UTIL", line 905
ORA-06512: at line 3