REP-0004: Warning: Unable to open user preference file
Symptoms:
Concurrent request logfiles have the below error:
REP-0004: Warning: Unable to open user preference file
Cause:
The prefs.ora is either missing or non-accessible.
Solution:
1. No prefs.ora file in HOME directory:
Oracle Reports will look into the user's HOME directory for the prefs.ora preferences file. If a prefs.ora file does not exist in your HOME directory, you can copy the prefs.ora file that came with the Oracle Tools.
Enforcing password complexity for database users
It is recommended to enforce checks and response actions for failed logins, password complexity, password expiration and password reuse.
Password complexity can be implemented through profiles.
The script for password management implementation utlpwdmg.sql can be used to create a new function to verify password complexity rules.
Verify Function is a quick and easy way to enforce quality of database passwords—for example, they should contain a certain number of characters, should not be identical to the username, and so on.
By executing this script utlpwdmg.sql, it will attach the function to the profile DEFAULT, which is the default profile for all users.
The following password complexity is set with the 'utlpwdmg.sql' script.
Changing OACORE java heap size in Oracle E-Business Suite R12.2.x
Increasing oacore memory in EBS 12.2.x
Login to the Weblogic Console
http://hostname:port/console
Enter Username and Password.
Forms Service shows down in Oracle Enterprise Manager Cloud Control 12c
Symptoms
Forms service shows down for the E-Business Suite instance discovered in OEM but it is Up.
Cause
Wrong Forms URL
Solution
1. Go to targets-->All targets
2. In the Search Target Name, enter "Forms" or in the Search LOV select "Forms" then click (Go) button
How to Create a Read Only APPS Schema in Oracle E-Business Suite
Create an APPS READONLY user
There are 2 ways to achieve this:
1) Create a user and grant select option to that user.
This will have to be done individually for all users that you want to have as read only.
2) Create a readonly role and assign users this role.
This will have to be done once and then assign this role to the users.