OMW Cleanup

When installing ESUs, an OMW project is created. If you have installed a lot of ESUs those projects can make it very annoying when trying to find other legitimate projects that you have access to. Yes, you can filter the OMW Project display, but I kinda find that annoying too. Anyway, I created a very simple SQL that I run once in a while to clean up my OMW:

DELETE FROM sy811/f98221
WHERE PUOMWUSER ='userid'
AND PUOMWPRJID LIKE 'JJ%'

Of course the syntax will need to be adjusted if using a database other than an IBM iSeries.

QACX Files in IFS

We had almost 8000 QACXxxxxxx files in our tmp directory in the IFS on our System i Enterprise server. They didn't seem to be causing any harm, but they were definitely taking up space.

According to Oracle (WARNING: you will need access to Oracle's customer support site), these files are temporary and should be cleaned by the system when a UBE completes processing. So far, since I have been monitoring, the UBEs are completing successfully, but the QACX files are remaining in IFS.

According to the Oracle doc, these files can be deleted...preferably when E1 services are down to ensure that you do not delete something the system is using.

E1 Terminology

Speaking the language is key to becoming a knowledgeable Oracle EnterpriseOne administrator.

So here are a few key terms:

• CNC - Configurable Network Computing. This term was used by JD Edwards to describe the flexibility of OneWorld's architecture.
• Pathcode/Central Objects – code repository
• PD811, PY811, DV811, PS811
• Environment – Pathcode + Data
• PD – Production
• PY – Prototype, Test, CRP
• DV – Development
• PS - Pristine
• Package – compiled code; collection of C++ DLLs
• “Full” - contains all objects in the specified Environment’s Pathcode
• “Update” - contains only the objects specified while defining the package
• eGen – converting object specifications to serialized objects
• Serialized objects – code read by the JAS server to present the User Interface
• “Fat-Client” – EnterpriseOne Windows Client
• ESU/ASU – Electronic Software Update/Application Software Update
• Object updates provided by Oracle

Deleting User Overrides

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'

Introduction to Oracle EnterpriseOne

Technically I guess the name should be Oracle JD Edwards EnterpriseOne. How's that for a name. Anyway, the main system that I work on during the day is EnterpriseOne. 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 (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:

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
	OS	CPU	Disk	RAM	NIC
InstallationA	V5R3	1.4	1.5TB	25GB	1GB
InstallationB	V5R3	0.6	600GB	17GB	1GB

Deployment Server - MS Windows Server 2003
	CPU	Disk	RAM	NIC
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
	CPU	Disk	RAM	NIC	JAS	HTTP
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

Introduction to Me

My name is Stewart Schatz. I have been working with EnterpriseOne 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 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...