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

Remove EnterpriseOne (E1) Environment Selection Screen

In our EnterpriseOne (E1) configuration, I force the user to pick what environment they are going to go into before they login by presenting an HTML page that then gives them links to the different environments.

I have each environment on it’s own port, so that I can bring down one environment without disturbing the others.

Anyway, by default, after signing in E1 asks the user what environment they would like to log into. Since I have everything separated, they only get one choice.

The users were annoyed with this “extra” screen that didn’t really provide them with anything. So, I did some research and found a way to remove it on JDEList. I also specified a default role with these settings.

In the JAS.INI file in the WebSphere instance:

[OWWEB]
DefaultEnvironment=JPD811
DefaultRole=*ALL

[LOGIN]
DisplayEnvironment=Hidden
#Options: Show|Hidden|ReadOnly|UseDefault

Hope this helps. It was an easy way to be the Hero-of-the-day…10 minutes…few seconds.

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

Leggo My EnterpriseOne (E1) Object!

While trying to delete an object the other day, I received the ever-helpful “Object exists in an active project” error. Since our developers have created a few hundred OMW projects, I didn’t want to go searching through every project to see where this object was. I realize that I should have been able to look at the News/Status tab and get the info, but it didn’t seem to be working.

Anyway, I used the following SQL to get the info (iSeries syntax):

select * from sy811/f98222 where POOMWOBJID like '[object_name]%'

iSeries Audit Journal

Use the following command to display the contents of the audit journal on the iSeries:

DSPJRN JRN(QSYS/QAUDJRN) FROMTIME(092807 080000) JRNCDE((T *ALLSLT)) ENTTYP(AF)

This is very useful when researching security issues.

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