Error 'TIBCO-BW-PALETTE-ORACLEEBS-510010: SQL Exception: ORA-06550: PLS-00201: identifier 'XXX' must be declared' with TIBCO BusinessWorks Plugin for Oracle E-Business Suite

Error 'TIBCO-BW-PALETTE-ORACLEEBS-510010: SQL Exception: ORA-06550: PLS-00201: identifier 'XXX' must be declared' with TIBCO BusinessWorks Plugin for Oracle E-Business Suite

book

Article ID: KB0080441

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Oracle E-Business Suite 6.x

Description

Description:         
=========
When migrating the project designed in BusinessWorks 5.x and TIBCO ActiveMatrix BusinessWorks Plug-in for Oracle E-Business Suite 1.3.0 to BusinessWorks 6.x and TIBCO ActiveMatrix BusinessWorks Plug-in for Oracle E-Business Suite 6.x.
After migration process with customAPI activity throws below exception:

****************************************************
INFO  [bwEngThread:In-Memory Process Worker-3] com.tibco.bw.palette.generalactivities.Log.ORACLE-CDH-Servicess.Logging - <?xml version="1.0" encoding="UTF-8"?><ActivityErrorData xmlns="http://tns.tibco.com/bw/palette/internal/activityerror+bw.oebs.CustomeAPI"><ns0:OracleEBSPaletteSQLException xmlns:ns0="http://schemas.tibco.com/bw/plugins/oracleEBS/oracleEBSExceptions"><msg xmlns="">TIBCO-BW-PALETTE-ORACLEEBS-510010: SQL Exception: ORA-06550: line 1, column 7:
PLS-00201: identifier 'TIB_BW_EBS_PKG.INITIALIZE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06550: line 1, column 336:
PLS-00201: identifier 'TIB_BW_EBS_PKG.GET_MESSAGE' must be declared
ORA-06550: line 1, column 336:
PL/SQL: Statement ignored
**************************************************** 

Symptoms:
=========
The error  'TIBCO-BW-PALETTE-ORACLEEBS-510010: SQL Exception: ORA-06550: PLS-00201: identifier 'XXX' must be declared' keeps being thrown for each procedure cal in the BusinessWorks log for TIBCO BusinessWorks Plugin for Oracle E-Business Suite.
    
Cause
==========
This error indicated that the required package is missing for running the plugin palette.
 

Issue/Introduction

Error 'TIBCO-BW-PALETTE-ORACLEEBS-510010: SQL Exception: ORA-06550: PLS-00201: identifier 'XXX' must be declared' with TIBCO BusinessWorks Plugin for Oracle E-Business Suite

Environment

Product: TIBCO BusinessWorks Plugin for Oracle E-Business Suite Version:6.x OS: All Supported Operating Systems

Resolution

The implementation of customAPI activity extended that of the PLSQL API palette. It means that the TIB_BW_EBS_PKG package is used by customAPI palette and it is required to execute the common_all.sql script to run the Plugin 6.x palette.

To resolve this issue run the common_all_undo.sql and common_all.sql present under <BW_Home>/plugins/oracleebs/config folder.