Problems Deleting An EnterpriseOne (E1) Custom Object

I ran into an issue the other day…


One of our developers had a few objects that he wanted deleted. So, I went to OMW and was able to delete all of the objects…except one (a “P” object). I did everything:

  • I deleted it locally
  • I deleted it from the SAVE location
  • I marked it to delete from transfer locations and then promoted it all the way to a 38 and back to a 21

Finally, I figured maybe I could just delete it from the database…NOT A GOOD IDEA!!!!

After a bunch of digging in all our developer’s projects, I found that there were 3 versions of that object that had been created. I deleted the versions and was then able to delete the object.

How FRUSTRATING!!!!!! You would think that that would be a fairly simple error message to display:

Technorati Tags: e1,enterpriseone,erp,peoplesoft,oracle,jde,jd edwards

After 642-901 and 642-812 students who do their N10-003 are usually fully qualified to teach 70-431.

How To Get A Date… Out Of E1 Part 2

Don’t worry, this still is not a dating service!

My last post dealt with dates in E1. Well, there is another way that dates are stored…

The number of seconds since January 1, 1970.

This isn’t too uncommon in programming languages such as C++, but it sure is a pain in the rear-end when looking in a database.

I have included a conversion tool on my E1 Dates page.

***NOTE: the dates calculation page has been updated***

Updated:

Here is a very simple way to convert the date using SQL:

date(char(DATEFIELD+1900000))

Example:

select date(char(SCSECLST+1900000)) from sy811/f98owsec

Technorati Tags: e1,enterpriseone,erp,peoplesoft,oracle,jde,jd edwards

How To Get A Date… Out Of E1

No this is not a dating service!

Today we will cover the proprietary date format that is used in most of the files in E1.

Well, let’s just dive in…

Today’s date is 4-5-2007. In E1-land that is 107095.

Here’s the breakdown:

  • E1 Date: 107095
    • Year: 1900 + 107 = 2007
    • Date: 095
      • The 95th day of the year (2007) = April 5th
    • Complete Date: April 5th 2007

Hey! What about the time?

  • E1 Time: 90154
    • 9:01:54 AM
  • E1 Time: 210154
    • 21:01:54 = 9:01:54 PM

Here is a page I put together that uses javascript to retrieve the dates.

Technorati Tags: e1,enterpriseone,erp,peoplesoft,oracle,jde,jd edwards

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 simple SQL that I run once in a while to clean up my OMW:

DELETE FROM sy811/f98221
WHERE PUOMWUSER = 'userid'
AND PUOMWPRJID LIKE 'JJ%'

Of course the syntax will need to be adjusted if using a database other than an IBM iSeries.

Technorati Tags: e1,enterpriseone,erp,peoplesoft,oracle,jde,jd edwards

E1 Command Line Install

I hate installing “fat” clients. That’s right hate. With our E1 installations, I have between 6-9 fat clients that need to be updated when deploying a full package. Of those, 1 is my eGen PC that gets every package installed to it. Ok, that’s not a very big amount, but it’s still a pain.

It’s not that the package install process is hard, but just time consuming. I mean what the heck takes so long when the screen shows those disks flying around?

Anyway, we did simplify the process a little by virtualizing the development PCs using VMWare. It’s really slick.

That made it a little easier because it wasn’t the developer’s PCs and they didn’t have to do the actual install (complaints from developers about install times was starting to get tiring).

Then, I decided to try and make it easier on myself and research some command line options. I found a great solution on Oracles support site (ID: 626265.1). Below is the syntax and parameters:
[sourcecode]Usage: Setup.exe -d -p [-v|-s] [-e] [-t] [-r]No args Starts the interactive gui installation
-v verbose installation – installation is shown on the screen
-s silent installation – installation is not shown on the screen.
-d the drive and path for the installation
-p package to install
-t install type: -t Typical or -t Compact
Typical to install development objects or Compact to install
production objects only. If not specified, development
objects are installed.
-r remove the previous installation
-e to generate error log.
H – All
I – Informational
W – Warnings
E – Errors[/sourcecode]
I have a BAT file that I use so all I have to do is give it the package name. I think I commented it fairly well below. Please note that this copies some files just so that I make sure I get all the right ones:
[sourcecode]@ECHO off
GOTO :GETPKG

:GETPKG
: Prompt the user for a package name
ECHO Enter package name:
SET /P pkg=
:If the package is blank, ask again
IF “%pkg%”==”” GOTO :GETPKG
GOTO :GETTYPE

:GETTYPE
ECHO Is this a FULL package (y/n):
SET /P t=
SET typ=””
IF “%t%”==”” GOTO :GETTYPE
IF “%t%”==”y” SET typ=Typical
IF “%t%”==”Y” SET typ=Typical
IF “%t%”==”n” SET typ=Compact
IF “%t%”==”N” SET typ=Compact
GOTO :INSTALL

:INSTALL
ECHO Begining Install of %pkg%…
“\\\e811\OneWorld Client Install\Setup.exe” -s -d c:\e811 -p %pkg% -t %typ%
ECHO Completed %typ% Install of %pkg%
IF “%s%”==”y” GOTO :COPYFILES
IF “%s%”==”Y” GOTO :COPYFILES
GOTO :END

:END
PAUSE[/sourcecode]
I get prompted for the package name and that’s it. It usually takes between 15-20 minutes per install, but I can connect and get them started and leave them alone until they are done.

This could be made even easier. You could use something like psexec from MS Sysinternals and run another BAT file to run this on those PCs remotely.

Well, fairly basic stuff but pretty handy.

Have fun!

Technorati Tags: e1,enterpriseone,erp,peoplesoft,oracle,jde,jd edwards