Friday, October 4, 2013

Steps on how to change JDE Administrator password


1 Stop EnterpriseOne services and JAS Server instances

2 Change the database user password.

alter user user_name identified by new_password;

For this case it will be:

alter user jde identified by your_password;

3 Disable Security Server in the server JDE.INI file by adding “;” in front of SecurityServer as shown below:

[SECURITY]

;SecurityServer=

4 Disable Security Server in the client JDE.INI file. Use 1 machine to apply these changes.

5 Login to the workstation with the new jde user account.

6 Open P98OWSEC

7 (Optional)Change the Proxy User password. The new password entered should be the same case as the database login password.

8 Change the System user password. (Steps are shown below)

I. From P98OWSEC, click on Add System User



II. Under Work with System Users screen, click Find and double-click on JDE.



III. Key in and verify the new password that you have firstly set in the Database Server. Click OK.



9 Change the JDE Login password for Fat Client login also. The steps are shown below:

I. In P98OWSEC, Search for JDE user ID, and click on Admin Password Revis button in the exit bar on the left.



II. Type in new JDE login password, it can be same as the Database password you changed from the beginning or you can have a different password. Click OK.



10 Logout of workstation

11 Update the fat client and Enterprise server JDE.INI files with the new password in [DB SYSTEM SETTINGS] and [SECURITY] sections. Ensure password case accuracy.

12 On JAS(web) server, change the JDBJ.INI files with new password for all environment.

13 Run PORTTEST with the new system user and password

14 Enable Security Server in client and server JDE.INI files.

15 Start E1 service(s). If using multiple servers (logic, enterprise), start services on the server designated as the primary Security Server.

16 Submit a UBE to the server. This will ensure connectivity to the database.

17 Have HTML users login and also submit a UBE to the server.



Reference : E1: SEC: Frequently Asked Questions on the JDE User ID and Password (Doc ID 1261994.1)

Wednesday, October 2, 2013

Add custom font to JDE Enterprise Server for report printing

This is applicable to Enterprise Server running under Linux OS as the built-in font type is less and only default to a few types of font.

Objective : To install custom font in Enterprise Server for report printing.


Solution :
  1. Copy the required font from Windows font folder in location C:\Windows\Fonts
  2. By using, WinSCP, connect to the Enterprise Server and go to location /u01/jdedwards/e910/system/resource/truetype and paste the font copied.
  3. After copied, edit the file /u01/jdedwards/e910/system/resource/pdflib.upr. There are some font pre-configured in pdflib.upr but being commented out with (%). Remove the (%) for the font copied and make sure the font file name matched the font name copied. 
  4. If the font is not listed in pdflib.upr, you can manually type the Font description name and the font file name.   
Example : 
Preconfigured pdflib.upr

If the font is not listed, you can manually add-in the font as shown below:

Reference : 1451775.1 E1:UBE: How to Setup Custom Fonts in EnterpriseOne Tools Release 9.1

Tuesday, October 1, 2013

Report printed in EnterpriseOne shows Times New Roman instead of Arial

Problem : In report design, font property had been changed to Arial. But, reports are printing Times New Roman instead of Arial.

Cause : Default font setting in P98980 is incorrect.


According to the above screenshot for P98980, the Report Font ID is Times New Roman when the Screen and Grid Font ID is set to Arial.

Solution : Open P98980 in fat client, modify all Times New Roman value under Report Font ID when the Screen Font ID and Grid Font ID is Arial as shown in below screenshot.



Reference : E1: UBE: Reports Are Created with Font Times New Roman instead of Arial on EnterpriseOne 8.9 and Above (Doc ID 634731.1)