My Oracle Support Banner

E_REJECT_DATA_NOTIF_JOB Failed Due to "ORA-00942: table or view does not exist" (Doc ID 2982632.1)

Last updated on OCTOBER 30, 2023

Applies to:

Oracle Retail Science Platform Cloud Service - Version 23.1 and later
Oracle Retail AI Foundation Cloud Service - Version 23.2 and later
Information in this document applies to any platform.

Goal

After recent version update, E_REJECT_DATA_NOTIF_JOB fails with log below.

2023-10-20T23:34:02,737 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: BEGIN reject_record_reload.load_all_e_notification; END;
2023-10-20T23:34:02,738 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh:
2023-10-20T23:34:02,738 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: *
2023-10-20T23:34:02,739 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ERROR at line 1:
2023-10-20T23:34:02,739 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-20001: Error occurred in REJECT_RECORD_RELOAD.LOAD_ALL_E_NOTIFICATION
2023-10-20T23:34:02,739 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-06512: at "RADM01.RI_LOG_UTIL", line 274
2023-10-20T23:34:02,740 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-06512: at "RABE01USER.REJECT_RECORD_RELOAD", line 721
2023-10-20T23:34:02,740 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-20001: Error occurred in REJECT_RECORD_RELOAD.LOAD_E_NOTIFICATION
2023-10-20T23:34:02,741 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-06512: at "RADM01.RI_LOG_UTIL", line 274
2023-10-20T23:34:02,741 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-06512: at "RABE01USER.REJECT_RECORD_RELOAD", line 680
2023-10-20T23:34:02,741 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-00942: table or view does not exist
2023-10-20T23:34:02,742 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-06512: at "RABE01USER.REJECT_RECORD_RELOAD", line 660
2023-10-20T23:34:02,742 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-06512: at "RABE01USER.REJECT_RECORD_RELOAD", line 703
2023-10-20T23:34:02,742 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-06512: at "RABE01USER.REJECT_RECORD_RELOAD", line 703
2023-10-20T23:34:02,743 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-06512: at line 1
2023-10-20T23:34:02,743 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh:
2023-10-20T23:34:02,744 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh:
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.