Error 'BW-ORACLEEBS-100010 SQL Exception: ORA-00942: table or view does not exist' with TIBCO BusinessWorks (TM) Plugin for Oracle E-Business Suite
Article ID: KB0087655
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
Feedback
