Move Over PeopleSoft Customer Connection. Now There’s Oracle MetaLink 3

Can you say “Up Grade”?

The beautiful, exquisitely organized PeopleSoft Customer Connection will be no more.

It is being replaced with the new Oracle MetaLink 3.

You can get all the details about the upgrade on the PeopleSoft and JD Edwards Support Transition page.

Tags: e1, EnterpriseOne - General, jd edwards, jde, oracle, oracle, peoplesoft, psft

20 Products Affected By Oracle’s Lastest Critical Patch Update

Oracle released the October 2008 Critical Patch Update.  This update contains 36 new security fixes across 20 different products.

A piece of EnterpirseOne, the Business Services Server, is included in this update. 

Oracle CPU – October 2008
Oracle CPU FAQ

Tags: e1, EnterpriseOne - General, EnterpriseOne - Security, oracle, oracle, peoplesoft, security, xe

Adding To PeopleBooks Documenation

We have some custom documentation that we want to have linked to when people go to the EnterpriseOne Documentation.  Essentially we want an extra link on the first page of PeopleBooks.

We want this:

To look like this:

So, I did a little digging into the structure of PeopleBooks and was a little surprised at its complexity.  I guess it had to be that way to enable "contextual" help.

Anyway, I changed the psoltoc.js file in

E:\Program Files\psol\webserv\peoplesoft\applications\peoplesoft\PSOL\htmldoc\js

You can append the necessary Javascript to the end of the file similar to the line below:

document.writeln("<P CLASS=TOPICLIST><a href=\"http://yourserver.com/e1_documenation/index.htm\"   target=\"_top\">" + "Custom Documentation" + "</a>");

Tags: e1, enterpriseone, EnterpriseOne - General, EnterpriseOne - JAS (Java Application Server), PeopleBooks, peoplesoft

Easy Tools Release Version Switch

While trying to do testing of the 8.97 Tools Release, we end up with having both the 8.96 Tools Release and the 8.97 Tools Release on our Deployment Server.  This is required so that we can continue to support package builds of the 8.96 environments. 

When switching from one to the other, I usually just rename the 3 important directories (OneWorld Client Install, SYSTEM & SYSTEMCOMP) by appending the Tools Release version to the end (i.e. SYSTEM -> SYSTEM_897). This can get a little tedious. 

So, I through together a quick BAT file to take care of it for me.

@ECHO OFF
IF EXIST "E:\PeopleSoft\E811\OneWorld Client Install_897\Install.inf"   GOTO :Activate897
IF NOT EXIST "E:\PeopleSoft\E811\OneWorld Client Install_897\Install.inf"   GOTO :Activate896

:Activate896
ECHO Activating 896
PAUSE
MOVE "E:\PeopleSoft\E811\OneWorld Client Install" "E:\PeopleSoft\E811\OneWorld Client Install_897"
MOVE "E:\PeopleSoft\E811\OneWorld Client Install_896" "E:\PeopleSoft\E811\OneWorld Client Install"
MOVE "E:\PeopleSoft\E811\SYSTEM" "E:\PeopleSoft\E811\SYSTEM_897"
MOVE "E:\PeopleSoft\E811\SYSTEM_896" "E:\PeopleSoft\E811\SYSTEM"
MOVE "E:\PeopleSoft\E811\SYSTEMCOMP" "E:\PeopleSoft\E811\SYSTEMCOMP_897"
MOVE "E:\PeopleSoft\E811\SYSTEMCOMP_896" "E:\PeopleSoft\E811\SYSTEMCOMP"
SET WHATDONE=Activated 896
GOTO :END

:Activate897
ECHO Activating 897
PAUSE
MOVE "E:\PeopleSoft\E811\OneWorld Client Install" "E:\PeopleSoft\E811\OneWorld Client Install_896"
MOVE "E:\PeopleSoft\E811\OneWorld Client Install_897" "E:\PeopleSoft\E811\OneWorld Client Install"
MOVE "E:\PeopleSoft\E811\SYSTEM" "E:\PeopleSoft\E811\SYSTEM_896"
MOVE "E:\PeopleSoft\E811\SYSTEM_897" "E:\PeopleSoft\E811\SYSTEM"
MOVE "E:\PeopleSoft\E811\SYSTEMCOMP" "E:\PeopleSoft\E811\SYSTEMCOMP_896"
MOVE "E:\PeopleSoft\E811\SYSTEMCOMP_897" "E:\PeopleSoft\E811\SYSTEMCOMP"
SET WHATDONE=Activated 897
GOTO :END

:END
ECHO %WHATDONE%
pause

Yes, I realize that I will need to do some replacing for the next Tools Release.

UPDATE: Don’t forget about changing the JDE.INI file to set the correct ports:

[JDENET]
serviceNameListen=
serviceNameConnect=

I added lines similar to the following:

REN "C:\Windows\JDE.INI" "C:\Windows\JDE_897.INI"
REN "C:\Windows\JDE_896.INI" "C:\Windows\JDE.INI"

Tags: EnterpriseOne - General, jde, Microsoft, oneworld, peoplesoft, Tools Release, version, world

Parameterized URL: Using The URL To Pass UserID, Password & Environment

I have been working on an issue lately that we are having with our Employee Self-Service implementation.  I’ll explain the details of that in a future post.

Anyway, in researching that issue I stumbled upon a solution in the Oracle Customer Connection site that I thought was pretty interesting. It’s titled "Oracle Customer Connection - Environment as a parameter to the login screen" href=https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=WHITE%20PAPER&id=748331.1" target="_blank" style="text-decoration:line-through;">Environment as a parameter to the login screen".  The reason I thought that it was interesting is that we use "parameterized URLs" to send users directly to our custom Employee Self-Service screens.

The thought of creating our own login screen or possible authentication proxie was kind of intriguing.

Ok, all you have to do is pass each parameter in the URL like the example below:

http://server:port/jde/servlet/com.jdedwards.runtime.virtual.LoginServlet?User=guest&Password=guest&Environment=JPY7333

It also works to direct the users to a specific application.  In the following URL, the user "guest" will be directed to the application P550001, form W550001A & version VER001:

http://server:port/jde/HostedE1Servlet?User=guest&Password=guest&Environment=JPD811&
OID=P550001__W550001A_VER001&FormDSTmpl=&FormDSData=&
jdecloselink=http://server:port/&jdeCloseAppStacks=true

How do you use parameterized URLs?  Please leave a comment.

Tags: e1, enterpriseone, EnterpriseOne - JAS (Java Application Server), jde, oracle, peoplesoft, version

How To Change The Login Screen Image

We are finishing up a project for Employee Self-Service.  Essentially, that means that we are giving employees the option to view their payroll and benefit information online.

This is not new to most larger organizations, but it’s new to us.  Since it is new and there will be employees accessing EnterpriseOne who do not use it for their daily jobs, we wanted to make it look a little different.

One of the things that we wanted to change was the login screen.

The screen shot to the left is the standard login screen for EnterpriseOne 8.11 SP1 using Tools Release 8.96.1.5.

We really wanted to change the Oracle JD Edwards EnterpriseOne logo.  So, I did a little checking on Oracles Support site and found Solution ID: 201052190 (requires login). This solution doesn’t specifically address the login image but it does talk about the disclaimer text at the bottom of the page.  So, it gets you to the right files.

A summary of that solution is that there is a file called html4login.jsp in

[Websphere Install Directory]\installedApps\mdur-ets-ME1WEBNode01\EA_JS_87.ear\webclient.war\share.

That location may be different in your installation.  Also, remember that this is for Tools Release 8.96.1.5.  Anyway, this file has a variable in it called "companyLogoImageURL".  Just point this variable to your image.

Here is the new login screen.  Well, not really, but you get the idea.

Tags: e1, enterpriseone, EnterpriseOne - JAS (Java Application Server), jas, jd edwards, oracle, peoplesoft, Tools Release, websphere

EnterpriseOne & VMWare

I always thought that the way I had things setup wasn’t necessarily supported.  You see, I use VMWare for the two IBM Websphere JAS servers in our instances.  However, thanks to some insight from a fellow SysAdmin, I now know different.

Bob Plankers, The Lone SysAdmin, found an article on Oracles support site (200955472).

So, according to this, I think my next Deployment Server upgrade will also be on VMWare.

Thanks, Bob!

Tags: enterpriseone, EnterpriseOne - General, ibm, jas, oracle, peoplesoft, websphere

The JD Edwards Advisor Sheds Some Light On IOICC Documents

IOICC is the IBM/Oracle International Competency Center.  It is made up of full-time stafff from both organizations.

Our friends at The JD Edwards Advisor is republishing several documents that are of particular importance to JD Edwards World or EnterpriseOne customers.

Thanks guys for bringing those to our attention. 

Tags: cnc, e1, enterpriseone, EnterpriseOne - General, ibm, jd edwards, oneworld, oracle, peoplesoft, world

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. 

I’m not sure about the differences in user interfaces but we did find the resolution to the issue.  Apparently, there is a 10 record limit for html client grids (Oracle solution id: 200984292 / password is required).

In the jas.ini change the following entry:

[OWEB]
GlobalPageSize=100

I guess, I understand the limitation, but not the error. 

Why would the application error out rather than just allow you to page through the records?

Tags: cnc, e1, enterpriseone, EnterpriseOne - General, EnterpriseOne - JAS (Java Application Server), esu, jas, oracle, peoplesoft

Configuring Object Notification

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 notification… yet.

After going through the article and following the set-by-step instructions I configured the object notification to email me when ever a project status was changed from a 26 to a 28.  It was really easy and a great way to keep an eye on what the development staff was doing. 

Then, I tried to configure another notification to email me when a project status changed from a 21 to a 26.  I received the following error: Notification Already Exists.

According to the error, the "From Status" and the "To Status" fields should be included in the primary key of table F9829.  However, after looking at the table in Table Design Aid, I found that the field OMWOSS2 is not part of the key.

I also found that there isn’t an ESU to resolve this issue.  I submitted a case to Oracle EnterpriseOne Support, but I would assume that it will have a pretty low priority.

UPDATE: I have been notified by Oracle E1 Tech Support that SAR 8644652 (you must have an Oracle support ID to follow the link) addresses this issue.  Essentially, they know about it and has a status of: 17 – Plan or Research.  This SAR was entered on 10-22-2007.

Tags: e1, enterpriseone, EnterpriseOne - General, esu, jde, omw, oracle, oracle enterpriseone, peoplesoft

Next Page »