My Oracle Support Banner

"ORA-00942: table or view does not exist" While Executing Function FN_FU_STATUS_UPDATE in Patchset - 18.2.4.0.0. (Doc ID 2765233.1)

Last updated on MARCH 31, 2021

Applies to:

Oracle Banking Digital Experience - Version 18.2.0.0.0 to 18.2.0.0.0 [Release 18]
Information in this document applies to any platform.

Symptoms

When attempting to implement patchset installer 18.2.4.0.0, the execution of database function - FN_FU_STATUS_UPDATE has failed with below error:

ERROR
-----------
LINE/COL  ERROR
--------- -------------------------------------------------------------
34/6      PL/SQL: SQL Statement ignored
34/44     PL/SQL: ORA-00942: table or view does not exist
37/5      PL/SQL: SQL Statement ignored
37/43     PL/SQL: ORA-00942: table or view does not exist
43/6      PL/SQL: SQL Statement ignored
43/44     PL/SQL: ORA-00942: table or view does not exist
46/6      PL/SQL: SQL Statement ignored
46/47     PL/SQL: ORA-00942: table or view does not exist
53/6      PL/SQL: SQL Statement ignored
53/47     PL/SQL: ORA-00942: table or view does not exist
56/6      PL/SQL: SQL Statement ignored
56/47     PL/SQL: ORA-00942: table or view does not exist
59/5      PL/SQL: SQL Statement ignored
59/43     PL/SQL: ORA-00942: table or view does not exist
65/5      PL/SQL: SQL Statement ignored
65/43     PL/SQL: ORA-00942: table or view does not exist
71/6      PL/SQL: SQL Statement ignored
71/44     PL/SQL: ORA-00942: table or view does not exist
74/6      PL/SQL: SQL Statement ignored
74/47     PL/SQL: ORA-00942: table or view does not exist


STEPS
-------
1. Download and implement patchset installer - 18.2.4.0.0.
2. Check installation log file - DB_installation.log available at location - <OBDX PATCH INSTALLER DIR>\OBDX_Patch_Installer\ExecInstances\<Date>\logs\db
   OR
   Login to OBDX database schema and check the function - FN_FU_STATUS_UPDATE.

 

Changes

 

Cause

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

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


In this Document
Symptoms
Changes
Cause
Solution
References


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