EnterpriseOne (E1) ESU Investigation

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

Oracle EnterpriseOne (E1) & MS Access

Unfortunately, we have users that like to use other applications to access our Oracle JD Edwards EnterpriseOne (E1) data. I say, "unfortunately", because when users view data outside the application, you never really know if what they are looking at is really what they want to see. Of course, this is dependant on the expertise of the user.

Anyway, we found a limitation on one of our users favorite little helper applications, Microsoft Access. There is a limit to the number of indexes a file can have that MS Access links to. That limit is 32. Which, in most cases is plenty. Our F06116 has 32 indexes, but was still not able to be linked to. I think it is because MS Access counts the actual file as one of the indexes.

Hope this helps someone else dealing with Oracle JDEdwards EnterpriseOne (E1) file access with Microsoft Access.

Here are some other Microsoft Access limitations.

Technorati Tags: e1,enterpriseone,erp,peoplesoft,oracle,jde,jd edwards

EnterpriseOne (E1) & IE7

We have been looking to upgrade all our users to IE7 ever since we upgraded E1 tools to 8.96.1.5. However, there are many internal industry specific applications that do not work correctly with the latest version of the market dominating Internet Explorer 7.

Please note that I said “market dominating” not personally preferred. I use FireFox.

Anyway, while doing some testing with E1, we noticed that PDFs wouldn’t display. We verified that the IE7’s handy little popup-blocker was disabled but still could not get a PDF. I then proceeded to get frustrated with the issue and the many entries on the web that referred to what seemed like my problem, but had resolutions that didn’t work, for me.

So, I handed the issue off to one of our help desk techs (just one of the many advantages to being in a large organization). He solve the issue without much problem. He found that, although the E1 site was listed in IE7’s “Trusted Sites”, there was a setting that needed to be “enabled” in order for the app to work as intended.

Tools -> Internet Options -> Security -> Trusted Sites -> Custom Level -> Downloads -> Automatic prompting for file downloads

What a pain!

Anyway, hope it helps…even if I’m the only one that reads this thing.

Technorati Tags: e1,enterpriseone,erp,peoplesoft,oracle,jde,jd edwards

Promoted EnterpriseOne (E1) Projects

So, to continue with the SQL theme from our E1 Development Manager, here is one that retrieves info about the projects that have been promoted since a given date. It gives the Project Name, Project Description, Object Name, Object Description, Object Type and the person’s userid that is on the object in PY.

SELECT PMOMWPRJID PROJ_NAME, PMOMWDESC PROJ_DESC, 
 POOMWOBJID OBJECT_NAME,IFNULL(C.SIMD,VRJD) OBJECT_DESC, 
 POOMWOT OBJECT_TYPE, 
 (SELECT E.SIUSER FROM OL811/F9861 E 
 WHERE E.SIOBNM = C.SIOBNM AND E.SIPATHCD = 'PY811') DEVELOPER 
FROM SY811/F98220, 
 ((SY811/F98222 
 LEFT OUTER JOIN OL811/F9860 C ON POOMWOBJID = C.SIOBNM) 
 LEFT OUTER JOIN COPD811/F983051 ON POOMWOBJID = 
 CONCAT(CONCAT(RTRIM(VRPID),'|'),VRVERS) ) 
WHERE PMOMWPS in ('38') AND PMOMWPRJID = POOMWPRJID AND 
 POOMWOT NOT IN ('UO', 'SE_TASK', 'SE_REL') AND 
 PMUPMJ > 107250 
ORDER BY PMOMWPRJID, POOMWOBJID 

Technorati Tags: e1,enterpriseone,erp,peoplesoft,oracle,jde,jd edwards

Who Has Access To That In EnterpriseOne (E1)?

There are many things that I find frustrating about the GUI tools for EnterpriseOne (E1), especially when doing Systems Administration functions.

Apparently, I’m not the only one. We give read-only access to most of the SysAdmin applications to our developers. You may have your own opinions about that, but it’s what we chose to do.

Anyway, our development manager gets a lot of CNC-type questions from our users and doesn’t like to always “bother” us with them. One of the questions she gets is “Who has access to the application or UBE?”. She got tired of wading through the multiple GUI applications required to get that information and came up with a very slick SQL query that returns the information quickly:

Note: iSeries DB2 syntax

SELECT ABALPH, FSOBNM, RLFRROLE, RLTOROLE 
FROM SY811/F00950, SY811/F95921, SY811/F0092, PRODDTA/F0101 
WHERE FSOBNM = 'PXXXX' AND 
 FSUSER = RLFRROLE AND
 RLTOROLE = ULUSER AND 
 ULAN8 = ABAN8 

Thanks Deb!

Technorati Tags: e1,enterpriseone,erp,peoplesoft,oracle,jde,jd edwards