E1 Tips The Tips & Tricks of a CNC Administrator on Oracle JDEdwards EnterpriseOne

Posts Tagged ‘esu’

Oracle Give Away Extended Support

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 ...

Greater Than 10 Record Grid Time Bomb

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.  ...

Configuring Object Notification

04.08.2008 · Posted in EnterpriseOne - General

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 ...

ESU Retrofits and Transfering Objects

<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 ...

EnterpriseOne (E1) Batch Job Runtimes

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 ...

EnterpriseOne (E1) Package Build Count

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 ...

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 ...

EnterpriseOne (E1) 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 ...

E1 Terminology

03.06.2007 · Posted in EnterpriseOne - General

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 – ...