Web Only Version Pain

We seem to be having an issue with old “web only” versions.  There are times when the “web only” version causes the other version to not egen correctly.  So, below is the SQL that can be used to select the “web only” versions.

SELECT count(*) FROM COPD811/F983051
WHERE VRVCC2='1'             

If you want to be more precise, you can grab the “web only” versions that have been executed prior to a certain date by using the VRVED field and the six digit date which can be found on the e1 dates page.

Presentations from Oracle OpenWorld 2009

JD Edwards and Oracle Application Integration Architecture: One Powerful Combination

Red Stack Technology and JD Edwards EnterpriseOne 8.12: Future Is Bright for Orlando Utilities Commission

Maximize your JD Edwards EnterpriseOne investment with Tools and Technologies

The Benefits of Running JD Edwards EnterpriseOne on the Oracle Technology Stack

Choosing the Right Technology Stack for JD Edwards EnterpriseOne

EnterpriseOne Event Rules Debugger Broker Error

The other day I was notified by a developer that he was receiving the errors pictured to the left when opening the debugger.  The application looked like it opened just fine and then right before it was done, these errors would appear.

I checked all the logs and re-installed the BPM Broker but the error persisted. 

Then I searched the My Oracle Support site and… tada!  A hit.  Knowledge Base ID 661700.1 had the solution.

There are about 5 different solutions listed and, of course, my issue was resolve with solution #5.

1. For 8.97 and higher Tools Releases Only:Make sure the following DLL files are registered on the workstation using the command

regsvr32 <Drive Letter>:\<E1 Release>\system\bin32\<DLL name>

E1Soap.dll
DebuggerService.dll
WinUBEDbgService.dll
JDEBPMSoap.dll
JDEBPMSockets.dll

I’m not sure which DLL was having the issue, but after I ran through these commands the error went away.

Hope this helped. 

Batch Version (P98305W) Version Error

After our latest tools release update there was a special instruction that I forgot to do on one of the environments.  It was to delete all versions of the Batch Versions (P98305W) application.  Usually, there will be just one version: ZJDE0001.

Well, since I forgot, to the left is the error that you might get if you don�t do it.  The second image is the Interactive Versions screen that you will need to use to delete the version.

EnterpriseOne & Sharepoint

A few weeks ago I attended a webinar sponsored by JDETips and presented by K-Rise Systems.

K-Rise has a very interesting set of EASYProcess web parts that integrate with EnterpirseOne.

Below is a list of selling points:

• With EASYProcess you get the power of Web portal interfaces, workflows, a business process automation engine, data integration, reporting, web services and handheld development, all in one place, integrated seamlessly to work with JDE and any database.
• Absolutely NO CODING in using EASYProcess.Your staff will be developing with EASYProcess very quickly. The learning curve is a couple of days. On-Site and On-Line training available. See possible projects below.
• Are you paying your developers to accurately place semi-colons? Let EASYProcess do that. Now your staff can do what they do best: build useful applications for your customers and users.
• Creates SharePoint compatible webparts with complex workflow.
• Team Development Friendly. All versions of World & E1 compatible

It looks like this product could really help in making EnterpriseOne data available through SharePoint a trivial task.

EnterpriseOne Minimum Technical Requirements

Recently, I found that the Minimum Technical Requirements for Oracle EnterpriseOne to be a little difficult to track down. 

So I thought I should create a post about it here so that I don�t have to waste a bunch of time looking for it. 

If I remember I did this, anyway.

JD Edwards EnterpriseOne Current MTR Index (Doc ID 747323.1)

Processing, Processing, Processing!

We had a user submit an issue last week that was a little baffling.

User: “When I try to access an application in EnterpriseOne all I get is the processing image.”

Us: “Does the ‘processing’ ever go away?”

User: “No.  It just sits there.”

Us: “um, ok. Let us do some checking and we’ll get back to you.”

Our PC support staff was able to remote into the PC and found that there was an “element not found” Javascript error.

The error was fixed by modifying the following registry entry:

HKEY_CLASSES_ROOT\TypeLib\{EAB22AC0-30C1-11CF-A7EB-0000C05BAE0B}\1.1\0\win32

Replace the current value on the default setting from:

"C:WINDOWS\system32\shdocvw.dll"

to

"C:WINDOWS\system32\ieframe.dll"

We didn’t have to reboot for this setting to take effect, but you may have to.

EnterpriseOne Javascript Error Causing Errors In Internet Explorer

We recently went live with Employee Self-Service.  In doing so, we no longer send employees their direct deposit pay stub.  Over the last few days we were notified that some employees were unable to view the paycheck details. 

We began troubleshooting the issue with looking at the usually culprits:

• Browser used (Firefox doesn�t work with EnterpriseOne Tools Release 8.97)
• Browser security settings (EnterpriseOne & IE7)
• Browser add-ons/plug-ins/extensions

However, nothing seemed suspect.

So, I put on the Web Developer Hat (don�t tell Charlie) and started troubleshooting.  I found that there was a Javascript error in Internet Explorer.  I tracked down the offending file an commented out the code.

The Javascript file that I changed was /js/JDEDTA.js.

The specific line that was causing the problem was line 344.  I commented out the whole thing because who needs �typeahead� functionality in Employee Self-Service?

340:    this.saveAutoCompleteData = function(){

341:        //Hack to make typeahead work in IE

342:        /*if(document.all){

343:            var formToPost = document.forms[this.formName];

344:                  window.external.AutoCompleteSaveForm(formToPost);

345:        }else if (!this.isSafari){

346:            var formToPost = document.forms[this.formName];

347:              if (formToPost)

348:              {

349:                  var action = formToPost.action;

350:                  formToPost.action = "javascript:void(0)";

351:                  formToPost.submit();

352:                  formToPost.action = action;

353:              }

354:        }*/

355:    }

Simple E1 URLs

Jeff Stevenson has a very good post on his blog about simplifying how users access EnterpriseOne using Apache virtual hosts, DNS mappings, host aliases and redirects.

Make a URL that looks like this:

http://server.company.com:82/jde/owhtml

Look like this:

http://e1.company.com or http://e1

Thanks, Jeff!

Metalink 3 Is Now My Oracle Support

Just an FYI, Oracle�s support site is now called �My Oracle Support�.

Metalink �> Metalink 3 �> My Oracle Support

Next Page »