EnterpriseOne (E1) ESU Investigation

Read Time:49 Sec

The title sounds like something out of CSI or Law & Order SVU…

Today our Development Manager was inquiring about what ESUs have been applied and to what environments.

Here is the SQL that I came up with:

Note: I restricted this query to only ESUs that were applied after our "Fix Current" project completed on 106041 (Feb. 10, 2006). Otherwise, there would be more listings than I could handle. Also, you’ll find the little trick to convert the JDE 6 digit date to something more readable.

SELECT SDPKGNAME as ESU,
 date(char(Min(Case when SDSUDFUT2= 'PS811' then SDSUDATE end)+1900000)) as PS811,
 date(char(Min(Case when SDSUDFUT2 = 'DV811' then SDSUDATE end)+1900000)) as DV811,
 date(char(Min(Case when SDSUDFUT2 = 'PY811' then SDSUDATE end)+1900000)) as PY811,
 date(char(Min(Case when SDSUDFUT2 = 'PD811' then SDSUDATE end)+1900000)) as PD811
FROM SY811/F9671, SY811/F9670
WHERE (SDSUDET = '90')
 and (SUSUDATE > 106041)
 and (SDPKGNAME=SUPKGNAME)
GROUP BY SDPKGNAME 
ORDER BY SDPKGNAME DESC

Author

Stewart Schatz

Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it. Side Hustle: Owner/Operator of E1Tips.com Location: Lancaster, PA USA What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.

stewart@9rains.com

http://stewartschatz.com

Happy

Sad

Excited

Sleepy

Angry

Surprise

Average Rating

5 Star

4 Star

3 Star

2 Star

1 Star

(Add your review)

2 thoughts on “EnterpriseOne (E1) ESU Investigation”

Brenda says:

January 31, 2008 at 11:58 PM

I enjoy reading your posts, keep them coming

Reply
stewart says:

February 1, 2008 at 8:03 AM

Thanks! I appreciate your feedback. If you have anything that you would like me to try and cover, please let me know.

Reply