While working with OEBS Plugin version 6.1 and BW 6.x we can come across an error during trying to run the Custom Procedure  through CustomAPI pallette. Below is the error output:

"

TIBCO-BW-PALETTE-ORACLEEBS-510010: SQL Exception: ORA-06550: line 1, column 33:
PLS-00201: identifier 'C_PACKAGE02.ADDCUSTOMER' must be declared
ORA-06550: line 1, column 33:
PL/SQL: Statement ignored
-{ActivityName=CustomAPI, ProcessName=ebs_sample01.Process, ModuleName=EBS_sample01}

"

For complete error details, kindly refer the "OEBS_Error.txt"

To resolve the issue, please follow the below steps:

1. Go to the process and click on the OracleAPI pallette. Go to properties>>General
2. Click on the tab: Generate SQL Script. Please refer the "GenerateSQLScript.txt" file attached to the article
3. Execute the script in the related database.
4. Provide the connection details(username/password/JDBC URL) as prompted by the pop-up.
5. Run the process.

The issue should be resolved.