Ausy E1 Tools

Now these are AWESOME!

We have been using just 2 of the tools that Alexander Pastuhov has available.

What are those 2 products?

• Boomerang
• We have 2 separate instances for 2 different business units so we use Boomerang to quickly and easily transfer objects from one to the other. It’s a VERY slick product. In a previous installation of OneWorld Xe we created data sources and transfer activity rules to accommodate this need, but with Boomerang we were able to keep our installation as vanilla as possible.
• Update Queue Names In Versions
• Yeah, it’s a long name, but man is it a time saver. When you consider the time that it would take you to change the job queue in the hundreds of versions that we had to split up our batch processing, it probably saved a good week of tech time.

Thanks Alex for providing such easy to use specialized products!

Tags: e1, enterpriseone, EnterpriseOne - General, jd edwards, jde, oneworld, oracle, peoplesoft, version, versions, world, xe

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:

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

Tags: e1, enterpriseone, EnterpriseOne - General, jd edwards, jde, omw, oracle, peoplesoft, version, versions

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

Tags: e1, enterpriseone, EnterpriseOne - General, EnterpriseOne - SQLs, jd edwards, jde, oracle, peoplesoft, sql, version

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.

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