E1 Tips

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.

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

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

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.

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.

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)

.cat{font-weight:bold;color:#c00c08;}

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_ROOTTypeLib{EAB22AC0-30C1-11CF-A7EB-0000C05BAE0B}1.1win32

Replace the current value on the default setting from:

"C:WINDOWSsystem32shdocvw.dll"

to

"C:WINDOWSsystem32ieframe.dll"

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

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!

Just an FYI, Oracle’s support site is now called “My Oracle Support”.

Metalink –> Metalink 3 –> My Oracle Support

We have been having some issues lately where users create web-only versions and expect to use them after a full package has been built and deployed.

We have processes in place for them to submit new versions to our development teams, but sometimes things don’t happen the way they are designed.

Anyway, I was doing some checking and noticed that there were quite a few versions in the F983051 that were web-only versions and were older than the last full build.

So, I created an SQL that we are going to run immediately after the deployment of a new full package.

DELETE FROM <central objects>/F983051
WHERE VRVCC2='1' 

***NOTE: the syntax used in the SQL statement is for the IBM System i (as400, iSeries)