Universal Accounting Link: Incorrect Login
Scenario:
The user wishes to use the Retail Pro Prism Universal Accounting Link on a workstation. They have created a shortcut on the workstation that points to a mapped drive where the application is installed on the server.
Issue:
When the user launches the RP Prism Accounting Link on the workstation using the shortcut that points to the mapped drive on the server, he receives an "Incorrect Login or Password" message. The username and password being used are confirmed to be correct, and the same user can login to the Accounting Link successfully on the server.
Problem:
In this case, the workstation does not have the necessary Oracle Client installed on it or that client is not properly configured.
Solution:
To resolve this issue, we must install the Oracle 12c client from the Retail Pro Prism RIL Database installation image and configure the TNSNAMES.ORA file on the workstation to connect to the RPSODS alias on the server.
Steps:
- Download the RIL installation image from my.retailpro.com solutions page to the workstation
- Launch the AutoRun.exe
- Choose RIL Oracle Database
- Select Oracle Client under type of install
- Enter the Prism DB Host where the Accounting Link is installed
- Browse to the Oracle client folder and locate the tnsnames.ora file
- Edit the tnsnames.ora file, and change the alias from RPROODS to RPSODS.
The Accounting Link will now be able to successfully connect to the database and authenticate the user when it is launched from the workstation.
Summary:
The manual process of sharing out the folder where the Accounting Link executable is installed is only part of what is required to successfully use the application on a client workstation. The second part of that process is ensuring that the Oracle client software necessary for the Accounting Link to connect is also installed and properly configured.