Error 'BW-ORACLEEBS-100010 SQL Exception: ORA-00942: table or view does not exist' with TIBCO BusinessWorks (TM) Plugin for Oracle E-Business Suite
book
Article ID: KB0087655
calendar_today
Updated On:
Products
Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Oracle E-Business Suite
-
Not Applicable
-
Description
Resolution: Description ========= When running TIBCO BusinessWorks Plugin for Oracle E-Business Suite, the error 'BW-ORACLEEBS-100010 SQL Exception: ORA-00942: table or view does not exist' is thrown in the BW log even though the plugin call is invoked successfully.
Symptoms: ========= The error 'BW-ORACLEEBS-100010 SQL Exception: ORA-00942: table or view does not exist' keeps being thrown for each procedure call in the BW log for TIBCO BusinessWorks Plugin for Oracle E-Business Suite.
Environment =========== Oracle E-Business Suite Version 11.5.10.2 Oracle RDBMS version 11.2.0.3.0
Cause ========== TIBCO BusinessWorks Plugin for Oracle E-Business Suite could not find the log table at plugin user schema.
Resolution: ========== Run common_all_undo.sql and re-run common_all.sql under <BW_Home>/plugins/oracleebs/config folder to ensure that the log table is created with plugin user successfully.
Issue/Introduction
Error 'BW-ORACLEEBS-100010 SQL Exception: ORA-00942: table or view does not exist' with TIBCO BusinessWorks (TM) Plugin for Oracle E-Business Suite