The EnterpriseOne category will include all posts and pages pertaining to EnterpriseOne.

Deleting User Overrides In EnterpriseOne (E1)

Once in a while my power-user wants to delete some User Overrides because they created some that they want everyone to use. Well, the UO app usually works pretty well, until your get some can not be deleted with the normal process. Here is the process that I go through:

1. Open a ?Fat Client? in the environment in which want to delete the UO
2. Fastpath to UO
3. Use the QBE to find the UOs that you would like to delete
4. Highlight them and click delete
5. NOTE: If some of them do not delete and give you an error like ?The object is in an open project?:
* Run a SQL statement similar to the following from the green screen to select the records desired and then delete them:

SELECT * FROM copy811/f98950 WHERE UOUSER ‘*PUBLIC’ and
UOOBNM=’Pxxxx’ and UOFMNM=’WxxxxA’ and UOVERS=’XJDE0016′

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

When working at home, starting with cheap web hosting is best and hence midphase or powweb are better choices.

Introduction to Oracle EnterpriseOne (E1)

Technically I guess the name should be Oracle JD Edwards EnterpriseOne (E1). How’s that for a name. Anyway, the main system that I work on during the day is EnterpriseOne (E1). It is what my employer uses for their ERP (Enterprise Resource Planning – a fancy name for accounting) system.

It was originally a JD Edwards product called OneWorld (the new version of JDE’s very stable product “World”). Then JD Edwards was purchased by PeopleSoft to try and avert a take-over by Oracle and was named EnterpriseOne (E1) (combining PeopleSoft’s product name, “Enterprise”, with “OneWorld”). However, in the end, Mr. Ellison won the battle to acquire PeopleSoft, which resulted in the name JD Edwards EnterpiseOne.

Ok, enough with the name…

Currently, we have two installations with the following configurations:

.myT {font: bold 10px; border: 1px solid #000000;}

E1 Software
  E1 Version Tools Release
InstallationA 8.11 SP1 8.95.P1
InstallationB 8.11 SP1 8.95.P1
Enterprise Server – IBM iSeries 550
InstallationA V5R3 1.4 1.5TB 25GB 1GB
InstallationB V5R3 0.6 600GB 17GB 1GB
Deployment Server – MS Windows Server 2003
InstallationA Dual Intel Xeon 2.8 GHz 136 GB 2 GB 1 GB
InstallationB Dual Intel Xeon 3.2 GHz 136 GB 2 GB 1 GB
Java Application Server – MS Windows Server 2003
InstallationA Dual Intel Xeon 2.8 GHz 68 GB 2 GB 1 GB IBM WAS 5.0.2 IBM HTTP 2.0
InstallationB Dual Intel Xeon 3.2 GHz 68 GB 3.2 GB 1 GB IBM WAS 5.0.2 IBM HTTP 2.0

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

Although 70-270 or 646-204 is not a prerequisite in 70-620 or the proceeding advanced exams like 220-601 and 70-649, but eventually one suffers because of ill preparation in SY0-101.

Introduction to Me

My name is Stewart Schatz. I have been working with EnterpriseOne (E1) or previous versions of it for about 5 years. It’s been a very challenging and frustrating 5 years.

I live in a very small town north of Bismarck, ND called Wilton. My family and I love it. It has a population of about 750. No I didn’t forget any zeros. It really is just 750. Anyway, I am a definite “Tech-guy”, or geek as my family and friends like to say. I personally take that as a compliment.

Anyway, I work in Bismarck for a company that uses Oracle EnterpriseOne (E1) as it’s ERP system.

Over the years, it has been very hard to find information about the systems that I work on, so usually when I find some good info I print it out. Well, the problem is that I usually end up loosing that paper because my desk is full of the stuff…and Hey! I’m a geek and if it’s worth having then it is worth having in electronic form.

So I plan to use this blog as a place to store tips, tricks, changes, tests and other stuff. Not to mention a place to vent the many frustrations that seem to come up. I’d also like it to be a sounding board to get other’s ideas if anyone eventually reads this other than me.

So, here it goes…

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