Oracle Retail RIB 14.1 installation weblogic.policy file update

RIB Weblogic.policy file update for applications RMS, TAFR, RWMS, and SIM:

The format should be correct else it will show error while deploying the application on RIB admin console:

Also, while accessing the Retail Integration Bus Manager console for application below if the formart is not correct or not added to weblogic.policy file then the subscriber option is not showing:

grant codeBase "file:/U01/RIB141/Middleware/user_projects/domains/rib_domain/servers/rib-rms-server/tmp/_WL_user/rib-rms.ear/-"
{
permission java.security.AllPermission;
permission oracle.security.jps.service.credstore.CredentialAccessPermission "credstoressp.credstore", "read,write,update,delete";
permission oracle.security.jps.service.credstore.CredentialAccessPermission "credstoressp.credstore.*", "read,write,update,delete";
};

grant codeBase "file:/U01/RIB141/Middleware/user_projects/domains/rib_domain/servers/rib-tafr-server/tmp/_WL_user/rib-tafr.ear/-"
{
permission java.security.AllPermission;
permission oracle.security.jps.service.credstore.CredentialAccessPermission "credstoressp.credstore", "read,write,update,delete";
permission oracle.security.jps.service.credstore.CredentialAccessPermission "credstoressp.credstore.*", "read,write,update,delete";
};

grant codeBase "file:/U01/RIB141/Middleware/user_projects/domains/rib_domain/servers/rib-rwms-server/tmp/_WL_user/rib-rwms.ear/-"
{
permission java.security.AllPermission;
permission oracle.security.jps.service.credstore.CredentialAccessPermission "credstoressp.credstore", "read,write,update,delete";
permission oracle.security.jps.service.credstore.CredentialAccessPermission "credstoressp.credstore.*", "read,write,update,delete";
};

grant codeBase "file:/U01/RIB141/Middleware/user_projects/domains/rib_domain/servers/rib-sim-server/tmp/_WL_user/rib-sim.ear/-"
{
permission java.security.AllPermission;
permission oracle.security.jps.service.credstore.CredentialAccessPermission "credstoressp.credstore", "read,write,update,delete";
permission oracle.security.jps.service.credstore.CredentialAccessPermission "credstoressp.credstore.*", "read,write,update,delete";
};

......................................................................Thanks..........................................................................

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