Symptoms

Dear K2 Team,

Please could I request your help in resolving this.

Error is :
PLS-00201: identifier 'GET_AVG_BAL' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

 

Diagnoses

it's probably something to do with the fact that the user (in Oracle) sits under "Other Users". use the following script to create synonyms:

This is just an example

 Connect K2Account/K2pass
 CREATE PUBLIC SYNONYM K2PROCEDURE FOR K2PROCEDURE
WHERE K2PROCEDURE is my StoredProcedure Name

According to this article: http://technopark02.blogspot.com/2012/03/resolving-pls-00201-identifier.html
 

Resolution

it's probably something to do with the fact that the user (in Oracle) sits under "Other Users". use the following script to create synonyms:

This is just an example

 Connect K2Account/K2pass
 CREATE PUBLIC SYNONYM K2PROCEDURE FOR K2PROCEDURE
WHERE K2PROCEDURE is my StoredProcedure Name

According to this article: http://technopark02.blogspot.com/2012/03/resolving-pls-00201-identifier.html