E1 Tips & Tricks

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)

July 1, 2009 | EnterpriseOne - General, IBM i/System i/iSeries/AS400, Java, MetaLink, Minimum Technical Requirements, Oracle Server Manager, enterpriseone, oracle, websphere | No Comments »

EnterpriseOne Is Giving “Element not found” Javascript Error

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.

June 22, 2009 | E1Tips, EnterpriseOne - General, Internet Explorer, Javascript, Microsoft, RegEdit, XML, enterpriseone | No Comments »

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 under Oracle’s Lifetime Support Policy. This means that when Premier Support ends, you may continue to receive updates, and legislative and regulatory fixes for an additional three years under Oracle’s Extended Support. Please be sure to review Oracle’s Lifetime Support Policy for details regarding each JD Edwards release.

How Does this Affect You?
All customers currently using JD Edwards EnterpriseOne 8.11 and 8.11 SP1 will have the first year of their Extended Support fee waived. After that you will have the option of continuing your Extended Support service, and can contact your Support Sales representative to initiate the purchasing process.

For more information, please review the following article on MetaLink 3, NOTE: 778948.1, or contact Global Customer Support for further questions.

I wonder if you still get the HelpDesk101-type support when you first call?  I’m not trying to be negative, but you know what I mean:

• Have you applied all the ESUs?
• Have you modified the object?
• Are you on the latest Tools Release?
• Could you send me a full set of logs for both the web server and the enterprise server? – Yeah, sure. Have funning going through 2 GB of TEXT!

Anyway, it may be a good deal.

May 28, 2009 | EnterpriseOne - General, MetaLink, My Oracle Support, enterpriseone, oracle | No Comments »

Add Record To OCM – F986101

The other day, I had a need to insert many records into the OCM (F986101).  So I set out to create a quick SQL statement that would serve that purpose.  Below is what I came up with:

INSERT INTO SY811/F986101                         

VALUES('DV811',0,'OBJECTNAME','LOCAL','','*PUBLIC',  

'*ALL','P','','H95','AV','SQL','BSFN',            

'USERNAME','','','',0,'',0,'','','','')            

Remember – you may have to make entries in both the SY811 and SVM811 F986101 files.

March 31, 2009 | EnterpriseOne - SQLs, OCM, Object Configuration Management, enterpriseone, sql | No Comments »

Access To Environments

To find out what users or groups have access to a certain environment run the following SQL:

select * from sy811/f0093
where llll='<enviornment>'    

To find out what environments a user or group has access to run the following SQL:

select * from sy811/f0093
where lluser='<userid>'    

March 16, 2009 | EnterpriseOne - SQLs, EnterpriseOne - Security, enterpriseone, sql | No Comments »