Tuesday, January 5, 2016

Oracle Retail ARI 14.0 Installation Error

After installing ARI 14.0 got error login to RMS as schema user (RMS14DEV). 

A pop up error message is coming as below

"Error ORA-04067 not executed stored procedure PUBLIC.ARI_INTERFACE_SQL does not exist returned by program unit ari_interface_lib.get_is_ari_user"

Solution:

Perform step 1 and 2 if not done during installation of ARI.

1) Log into SQL *Plus as <RMS Schema Owner>
SQL> drop package ARI_INTERFACE_SQL;

2) Log into SQL *Plus as <master schema owner>
SQL> @user_syns.sql
When prompted for the user name, use <RMS Schema Owner>.

--> Create or replace synonym RMS14DEV.ARI_INTERFACE_SQL for ARI140M.ARI_INTERFACE_SQL

Re-creating the SYSNONMS, the login to RMS will be successful.

****************************Done***********************



No comments:

Post a Comment