Thursday, February 14, 2008

JD Edwards EnterpriseOne Documentation Library

If your new to Oracle's JD Edwards EnterpriseOne and need something to read and can start downloading or viewing online the systems implementation and tools-guide documentation via this link:

Saturday, January 19, 2008

eGenerator Issues and Solutions

Using Direct Generation to connect the eGenerator on any environment (on sample is PD) you'll be stump by an error saying:

On your web generator machine go to the following path and edit the jas.ini:

On the [OWWEB] section, add the necessary environment in the PathCodes setting.


Make sure there is no space in between the commas.

Tuesday, January 15, 2008

Web or Windows Application Flag Settings in EnterpriseOne.

There's a flag used by EnterpriseOne that dictates if the application can be run as web client or windows-mode (fat client).

The field used is SIANSIF in table OL812.F9860 (Object Librarian Master Table).

It has the following settings used:
blank - both Web and (fat) Client
W - Web only
C - (fat) Client only
R - ???

- This is an undocumented setting in EnterpriseOne and changes are unsupported by Oracle.

Wednesday, January 9, 2008

Disabling RTE (Real-Time Events) in EnterpriseOne

This is my updated instruction on disabling RTE (Real-Time Events) in EnterpriseOne 8.12 as the instruction on the knowledge garden is targeted only for 8.11 SP1:

1. Determine the RTE event errors found in call object kernel log inside SAW Enterprise. Look for "Failed to get event definition for event XXXXXX. Please check is event definition correct?"

2. From the solutions explorer, open P90701A (Event Definition Workbench).

3. Click on Find and see if the event XXXXXX is already present, if not add the event. Use the "JD Edwards EnterpriseOne Application Real-Time Events 8.12 Implementation Guide" in adding the necessary fields.

4. From the Form Exit bar (Click on Preferences >> Exit Bar menu if hidden) click on the "Event Activation".

5. Click on Find and see if the event XXXXXX is already present, if not add the event. On the environment use the J prefix environment e.g. JPD812.

6. After adding, click on Find again to refresh the grid. On the Event Status make sure it's "NA", if not Use the Row Exit bar to change status.

7. Restart the JDE Service to effect the changes.

The documentation on "JD Edwards EnterpriseOne Application Real-Time Events 8.12 Implementation Guide" (April 2006) is not written correctly.

Event Entry Application fields:
Event Type - refers to Event Name in the guide.
Event Category - refers to Event Type in the guide.
Event Aggregate - refers to Event Category in the guide.

Tuesday, January 8, 2008

Differentiate JDE environments by changing the logo images.

EnterpriseOne Tools 8.96 currently doesn't have a facility for web users to help them identify what environment they are currently logon. Given the standard environments on a default install of DV, PY and PD, there's no easy way to automatically distinguish each from one another.

Editing the following image on the JAS would do the trick! We used the stop light colors of green, yellow and red.



Now that's more like it!

Convert JULIAN to standard date using SQL.

EnterpriseOne stores dates in Julian using the following format CYYDDD ("C" is the century, "YY" is the year and "DDD" is the number of days since the start of the year).

To convert a julian date to a standard (gregorian) date format:


- where XXXXXX is the column name to convert.
- this only works on 19th century onwards.


You can download this QuikDates! "freeware" windows application that can convert julian to standard and vice-versa. It's a handy tool (no need to install) that you can place on your desktop.
Download here!

Saturday, January 5, 2008

Obtaining a list of tables for a specific column in Oracle DB.

DBA_TAB_COLUMNS is a view that will help us obtain a list of tables for a specific column in Oracle database.

SELECT owner, table_name, column_name
WHERE column_name like '%ADDJ'
ORDER BY owner, table_name