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.