Oracle

ESU Cleanup

Since our installations of EnterpriseOne were installed and the data upgraded we have applied and installed thousands of ESUs. On 4 of the 7, we neglected to apply the ESUs to the Pristine pathcode (PS900/PS910). This made researching code changes a bit of a challenge.

So, the other day, I decided to rectify that and apply the many, many ESUs to Pristine. Because there were some very old ESUs and not all of them were registered with Change Assistant, it was a very time consuming. After I had finished, I noticed that there were several ESUs that had only been applied to PS & PD and others that had only been applied to PS, DV & PY. Rather than look through every ESU and risk missing some, I connected to E1LOCAL and wrote a SQL statement to get every ESU that had been applied to the system that was not in every pathcode.

Please see “Use Oracle SQL Developer To Modify The JDE LOCAL Database” for connection instructions.

SELECT * FROM (
	SELECT A.SDPKGNAME AS ESUNAME, 
		A.SDSUDFUT2 AS SYS, 
		PS.SDSUDFUT2 AS PS910, 
		DV.SDSUDFUT2 AS DV910, 
		PY.SDSUDFUT2 AS PY910, 
		PD.SDSUDFUT2 AS PD910 
	FROM F9671 A
	LEFT JOIN F9671 PS 
		ON A.SDPKGNAME = PS.SDPKGNAME 
		AND PS.SDSUDFUT2='PS910' 
		AND PS.SDSUDET = '90'
	LEFT JOIN F9671 DV 
		ON A.SDPKGNAME = DV.SDPKGNAME 
		AND DV.SDSUDFUT2='DV910' 
		AND DV.SDSUDET = '90'
	LEFT JOIN F9671 PY 
		ON A.SDPKGNAME = PY.SDPKGNAME 
		AND PY.SDSUDFUT2='PY910' 
		AND PY.SDSUDET = '90'
	LEFT JOIN F9671 PD 
		ON A.SDPKGNAME = PD.SDPKGNAME 
		AND PD.SDSUDFUT2='PD910' 
		AND PD.SDSUDET = '90'
	WHERE A.SDSUDFUT2='ALL' 
		AND A.SDSUDET ='10'
	ORDER BY A.SDPKGNAME DESC
)
WHERE PS910 IS NULL
	OR DV910 IS NULL
	OR PY910 IS NULL
	OR PD910 IS NULL

2 Ways To Prevent Java Crapware: Ask Toolbar

How-To-Geek has a great article on how to prevent the Java installer from installing the Ask Toolbar and other crapware.

Below are the 2 methods:

  1. Using the Java Control Panel: This method is only available if you already have java installed and want to avoid accidentally installing its crapware when you update it.
    1. Press the [Windows] key
    2. type java
    3. Click Configure Java
    4. At the bottom of the Advanced tab, put a check in the Suppress sponsor offers when installing or updating Java option.
       image
  2. Use the registry to set the option even before Java is installed.
    1. Open notepad
    2. Paste the following into a new document
       Windows Registry Editor Version 5.00  [HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft] SPONSORS=DISABLE  [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\JavaSoft] SPONSORS=DISABLE 
    3. Save the document with a .reg extension
    4. Double-Click the new file

How to Increase Your JD Edwards Performance with the New UI on 9.1.4

Gustavo Barizon is a great guy and a very knowledgeable CNC Admin.  He works for cd|group and is hosting a webinar on Friday.  I suggest you check it out.

Join CD Group for this JD Edwards Users Webinar to learn how to use the latest and greatest enhancements from JD Edwards User Interface 9.1.4.  In less than one hour, you will see how to: 

  • Increase your performance using CafeOne and E1 Pages 
  • Take advantage of Watchlists to pro-actively engage your processes 
  • Use the context-sensitive help to get insights on your procedures 

You will also  be able to see the iPad app in action and learn about whats new in mobility solutions for JD Edwards. Dont miss this opportunity to increase your knowledge about JD Edwards

Title: How to increase your JD Edwards performance with the new UI on 9.1.4
Date: Friday, September 12, 2014
Time: 12:00 PM – 1:00 PM EDT 
Speaker: Gustavo Barizon

Space is limited.
Register for this webinar now.

Use Oracle SQL Developer To Modify The JDE LOCAL Database

During our upgrade process, we apply all of the ESUs to become code current before mirroring the upgraded code to the other pathcodes.

The process of doing this does not automatically update the Electronic Software Updates application to reflect that all of the ESUs are in all the pathcodes.

There a couple of different way to update the grid:

  1. Apply the ESUs to the other environments.  This can be a very long and tedious endeavor because there could be thousands of ESUs to apply.
  2. Update the JDE LOCAL database.

I have done option 1 in the past but found it kind of a pain and since I knew that I didnt really want the process to really do anything except update the table, I chose to come up with a process to do option 2.

Here is what I did:

  1. Install and configure Oracle SQL Developer.  This is really the hardest part, but really not much of an issue.
  2. Create a connection to the JDESY910 database.  Remember, not only is JDESY910 the name of the database, but by default it is also the UserID and Password.
    image
  3. Run the following SQL
     INSERT INTO F9671 (SDPKGNAME,SDSUDET,SDSUDS,SDSUDATE, SDSUTIME,SDSUDFUT1,SDSUDFUT2,SDSUDFUT3,SDUSER,SDPID, SDUPMJ,SDUPMT,SDJOBN) SELECT SDPKGNAME,90,15,113284,111111,' ','DV910',0, 'JDE','SQL',113284,111111,'<deployment name server>' FROM F9671 WHERE SDSUDET=90 AND SDSUDFUT2='PD910' 
    • In this SQL, we upgraded PD910 and then moved the code to DV & PY.
    • We only need the status 90 records because those are the ones that the grid uses.

Hope this helps.