I got this email this morning: Dear JD Edwards EnterpriseOne Customer, During the recent COLLABORATE conference Oracle President Charles Phillips announced that Oracle will waive first year Extended Support fees for certain product lines. This includes 8.11 and 8.11 SP1 for JD Edwards EnterpriseOne. What is Extended Support? Many JD Edwards legacy programs are supported ...
After installing the new IBM hardware, I decided to run a full package build just to get an idea of what the performance improvement was. So, here are the results: Existing Hardware New Hardware Client ~4 hours ~5.75 hours Enterprise Server ~4 hours ~2 hours Ok, I’m a little confused on the client portion ...
In our implementation of Employee Self-Service (ESS), we are accessing the EnterpriseOne application directly through parameterized URLs. In doing this, all applications that access the F085530W, which is the work file used for benefits information, result in an error. However, if you access the same applications through the normal E1 web client, it works fine. ...
I was reading through the latest JDETips Journal this morning and found a great article about configuring email notifications within EnterpriseOne. A great article by Mike Wright. We have had email notification configured for quite awhile. We use it for both batch job notifications and workflow messages. However, we hadn’t set it up for object ...
<hint of sarcasm>Although JDE/PeopleSoft/Oracle has done such an awesome job with all of their products</hint of sarcasm>, sometimes you are forced to modify some of the objects. Unfortunately, now that you have modified the object an ESU, that you need, may get released that has that object in it. To prevent the ESU from clobbering ...
We had someone ask this question the other day: Can you tell me what jobs run for over 30 minutes? Well, that seemed simple enough… Take the last action time and subtract the submit time and your good: SELECT JCJOBQUE as JobQueue, JCENHV as Environment, JCUSER as User, substr(jcfndfuf2,0,locate('_',jcfndfuf2) + locate('_',substr(JCFNDFUF2,posstr(jcfndfuf2,'_')+1))) as JobName, concat(concat(JCSBMDATE,'-'),JCSBMTIME) as ...
Recently we were asked the following question: "How many packages of each type per environment did you build last year?" Here is the SQL that I used to gather the information required: select hhpkgname, hhpathcd, year(date(char(hhblddte+1900000))) as hhblddte from sy811/f96215 where hhpkgname not like 'JJ%' --remove the ESUs and hhdatp='CLIENT' --type of build and hhbldsts=50 ...
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 ...
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 ...
Speaking the language is key to becoming a knowledgeable Oracle EnterpriseOne (E1) 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 ...