Not able to open the URL for SIM, RPM and Allocation 14.1 after successful installation

Error:

I have did a complete successful installation for SIM, RPM and Allocation 14.1.

But the Login Page is not coming up. Page error is coming and time out.

Solution:

This problem is due to the browser and java setting not allowing the pages / Jar files to download on client machine and cached.

One Solution is to open Java console and go to Network Settings:

Enable the Direct Connection.

Clear the Java caches and browser cache and give a try.

*******************************Thanks*********************************

In RMS 14.1 working with Deals is giving error ORA - 28595

Error Message:

In RMS while working with Deals there is an database related error pop up while saving.

ORA - 28595 Extproc agent: Invalid DLL path

Screenshot:

Solution:

--> It was found that within the $ORACLE_HOME/hs/admin directory the extproc.ora file had the following value.

SET EXTPROC_DLLS=any

OR

SET EXTPROC_DLLS=

Please update the value to upper case ANY as show below and then try to check again.

SET EXTPROC_DLLS=ANY

*************************************Thanks******************************

Oracle Retail SIM - JPS-01055: Could not create credential store instance

Error Message:

JPS-01055: Could not create credential store instance. Reason oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-10000: There was an internal error in the policy store.

Solution:

Please check the OPSS related users are not locked or expired in the database.

In above issue the SIM related OPSS user SIM_OPSS user was expired and hence it was throwing the above error with error code JPS-01055

*********************************Thanks *********************************

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***********************

In Oracle Retail Warehouse Management system user PAR3214 locked

In Oracle Retail Warehouse Management system 14.0 user PAR3214 locked.

Solution:

We are having a password reset script for user PAR3214 in ORWMS 14.0

rwms_reset_app_user_pwd.sh

First we need to export RDMUSR and RDMPWD

export  RDMUSR = RWMS Schema User
export RDMPWD - RWMS Schema Password

./rwms_reset_app_user_pwd.sh PR PAR3214 PAR3214
Give the userid and password same as shown above. After the script is ran successfully we have to change the password at the login screen.

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

Oracle Retail REIM 14.1 login page not coming after Installation

Oracle Retail REIM 14.1 login page is not coming after a complete Installation

Workaround:

In order to check the issue, we need to check the log files and configuration files for any errors. 1) Weblogic Server Logs: $DOMAIN_HOME/servers/<reim-server>/logs/reim-server.out $DOMAIN_HOME/servers/<reim-server>/logs/reim-server.log 2) ReIM Application log: $DOMAIN_HOME/retail/<reim>/logs/reim-online.log OR at $RETAIL_HOME/reim-batch/log/reim-online.log 3) ReIM Installation log file: $<INSTALL_DIR>/reim/application/reim14install.<timestamp>.log 4) $<INSTALL_DIR>/reim/application/ant.install.properties 5) $<WLS_HOME>/server/lib/weblogic.policy 6) $MW_HOME/wlserver_10.3/common/nodemanager/nodemanager.properties 7) Check and confirm if you have enabled SSL or SSO for this installation there is no errors. Above point 5 (weblogic.policy) file need to be checked for security and permission. Please refer the installation guide of oracle for more details. ****************************** Thanks ************************************ For complete installation Help and Support please drop mail with your requirement at below mentioned Email-ID We can setup Oracle REIM environment along with other Mom products for your learning with just some maintenance cost info@orainstall.com

Install Oracle Retail RPAS 14.0

High level steps to Install RPAS in Oracle Retail 14.0

1) Install RPAS Sever and ConfigTools (which mostly consists of unzipping files and modifying existing environment variables since I am upgrading)

2) Install the Fusion Client (and all it's prerequisites, i.e. WebLogic Server and AppDev, Wallet creation)

3) Create or upgrade the solution domain (rpasInstall -fullinstall or upgradeDomain)

4) Set up the connection for the Fusion Client (Foundation.xml, MultiSolution taskflow)

5) Make sure the linux user who installed the RPAS server and components is also there as     an weblogic admin user.

usermgr -d domainPath -add [userName] -label [label] -group [groupName] {-admin}

6) Start the DomainDaemon

Example:
nohup ./DomainDaemon -port 55555 -start -ssl 2 -wallet file:/u01/Oracle/RPAS/fclient/tmp/wallets/server &

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

For complete installation Help and Support please drop mail with your requirement at below mentioned Email-ID

We can setup Oracle RPAS environment along with Planning Modules required with just some maintenance cost

info@orainstall.com

RMS 14.1 Installation Steps

Oracle Retail RMS 14.1 High Level Installation Steps

Below are the steps to install Oracle Retail 14.1 on Oracle Linux 6 / Red Hat Enterprise Linux 6.

1) First we have to install Oracle Database 12cR1

2) Follow the installation guide of Oracle for Schema user creation for RMS product.

3) Oracle WebLogic Server 11g Release 1 (10.3.6)

4) Oracle Forms Services 11g Release 2 (11.1.2.2)

5) Run the RMS product batch and application installers

Please follow Oracle Guide for all details related to Installation of RMS 14.1

https://docs.oracle.com/cd/E12448_01/rms/pdf/141/rms-141-ig-03.pdf

**********************Thanks***********************************

For support on Retail Installation on your machine please contact at
info@orainstall.com

Oracle Retail SIM 14.1 error at login screen

Problem: Login Page error at SIM 14.1 Fresh Installation

Workout:

Please do the following troubleshooting:

1. Shut down all the servers of the WebLogic Domain created.

2. Once you extract the SIM installer to <INSTALL_DIR> copy the sim-security.zip present in <INSTALL_DIR>/sim/application/sim14 to the WEBLOGIC_DOMAIN_HOME/lib and extract it contents in the folder.

3. Start the domain admin server.

4. Log into the WebLogic console.

5. Navigate to: security realms -> myrealm (default realm) -> providers.

6. Start a Lock and Edit session.

7. Click New provider.

8. Select the provider type from the list: SimWlsDbAuthenticator.

9. Set the provider name (Default: SimWlsDbAuthenticator).

10. Click Ok.

11. Open the new provider configuration.

12. Under Common, set the Control Flag to SUFFICIENT.

13. Click Provider Specific.

14. The SIM Data Source Name defaults to SimDataSource which is what the SIM installer creates, so it should be left to the default value.

15. Check that the GroupName is set to the name of the group used for SIM secure users.

16. Click Ok.

17. On the provider list, click Reorder.

18. Move the SimDbAuthenticator to the top of the list, or above the DefaultAuthenticator.

19. Click Ok.

20. Click Activate Changes.

21. Shutdown the admin server.

22. Start the admin and managed servers for the domain.

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

If still issue please post comments.

For support on Retail Installation on your machine please contact at
info@orainstall.com

Oracle Retail RIB RIHA Login Problem after installation

Problem: Not able to login to fresh Installation of RIB 14.1 RIHA 

Solution:

1) During the installation of RIHA in RIB 14.1 version, there is step of compiling the riha-app, you are suppose to execute this:

$....tools-home/riha/bin>  ./riha-app-compiler.sh -setup-security-credential

At this step, when you specify the username and password for RIHA tool, they will get accepted as the login credentials.

2) In the next step while executing, ./riha-app-deployer.sh -prepare-wls ---> all the datasource required by RIHA application will be created based on the number of applications  in scope of rib-deployment-info.xml and user information required for riha app to login will be created (RihaAdminGroup and user entered in riha compilation phase)

With login to the admin console where RIHA managed application server (riha_server) is deployed we can check if the data sources are created successfully or not. If not then please check the installer logs for any error during install.

If both the above steps are executed and still the issue exists, then looks like the compilation/deployment was not successful.  Try to undeploy the riha-app and re-execute those steps.

In case the problem repeats fetch the logs from $<RIB_HOME>/tools-home/riha/log/ directory.

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

Info:

If you need help on RIB or any other Retail Production Demo installation please contact at

info@orainstall.com