Error 'BW-ORACLEEBS-100010 SQL Exception: ORA-00942: table or view does not exist' with TIBCO BusinessWorks (TM) Plugin for Oracle E-Business Suite

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 &ltBW_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