My EOne Encounter

JD Edwards EnterpriseOne Documentation Library

2008-02-14T17:24:00.001+08:00

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

http://www.oracle.com/technology/documentation/jdedent.html

eGenerator Issues and Solutions

2008-01-19T21:31:00.000+08:00

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

Solution:
On your web generator machine go to the following path and edit the jas.ini:
c:\e812\system\OC4J\j2ee\home\applications\webclient.ear\webclient\WEB-INF\classes\jas.ini

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

Ex.
[OWWEB]
PathCodes=('DV812','PY812','PD812')

Notes:
Make sure there is no space in between the commas.

Web or Windows Application Flag Settings in EnterpriseOne.

2008-01-15T11:49:00.000+08:00

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 - ???

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

Disabling RTE (Real-Time Events) in EnterpriseOne

2008-01-09T21:44:00.000+08:00

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.

Notes:
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.

Differentiate JDE environments by changing the logo images.

2008-01-08T17:53:00.000+08:00

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.

LOGIN PAGE LOGO:
C:\OraHome_1\j2ee\JasOC4J\applications\jasapp\webclients\share\images\login\Oracle_JDEE1.gif

LOGO ABOVE THE MENU:
C:\OraHome_1\j2ee\JasOC4J\applications\jasapp\webclients\share\images\jdelogo-onwhite.gif

Now that's more like it!

Convert JULIAN to standard date using SQL.

2008-01-08T16:00:00.001+08:00

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:

TO_CHAR(TO_DATE(XXXXXX+1900000,'YYYYDDD'),'MM-DD-YYYY')

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

Or

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!

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

2008-01-05T19:47:00.000+08:00

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

example:
SELECT owner, table_name, column_name
FROM DBA_TAB_COLUMNS
WHERE column_name like '%ADDJ'
ORDER BY owner, table_name

EnterpriseOne System Codes

2008-01-03T18:51:00.000+08:00

I couldn't find a documentation from Oracle or the web in regards to a list of system codes found in EnterpriseOne. So I created my own the hard way :(

These system codes are usefull in filtering a group of ESU's (Electronic Software Packages) in the Change Assistant application.

Download a text file from this link here.

FINANCIAL MANAGEMENT
00 - GENERAL BACK OFFICE
01 - ADDRESS BOOK
03 - ACCOUNTS RECEIVABLE
03B - ENHANCED ACCOUNTS RECEIVABLE
04 - ACCOUNTS PAYABLE
09 - ACCOUNTING AND FINANCIALS
09E - EXPENSE MANAGEMENT
11 - FOREIGN CURRENCY/CASH BASIS
11C - CASH BASIS ACCOUNTING
12 - FIXED ASSETS
14 - PLAN/BUDGET/ALLOCATIONS
15 - REAL ESTATE MANAGEMENT
15L - ADVANCE REAL ESTATE FORECASTING
16 - EPS/PROFIT MANAGEMENT
48 - WORK ORDER PROCESSING
48S - SERVICE BILLING
51 - JOB COST ACCOUNTING
52 - CONTRACT BILLING/JOB COST BILLING
53 - CHANGE MANAGEMENT
70 - MULTI-NATIONAL PROCESSING

HUMAN CAPITAL MANAGEMENT
05 - TIME ACCOUNTING
05A - HR & PR FOUNDATION
05T - TIME ENTRY
05U - HR & PR FOUNDATION US
07 - PAYROLL
08 - HUMAN RESOURCES
08A - RECRUITMENT SELF SERVICE
08B - BENEFITS ADMIN
08C - HUMAN RESOURCES CANADIAN
08H - HEALTH AND SAFETY
18 - TIMECARD AUTOMATION
77 - CANADIAN PAYROLL

MANUFACTURING
13 - EQUIPMENT MANAGEMENT
17 - CUSTOMER SERVICE MANAGEMENT
30 - PRODUCT DATA MANAGEMENT
30A - PRODUCT COSTING
31 - SHOP FLOOR CONTROL
31A - MANUFACTURING ACCOUNTING
31B - BLEND MANAGEMENT
31P - ENGINEERING PROJECT MANAGEMENT
32 - CONFIGURATION PROCESSING
33 - CAPACITY REQUIREMENTS PLANNING
34 - DRP/MPS/MRP
34A - APS INTEGRATION
37 - QUALITY MANAGEMENT
F30L - DFM LINE DESIGM
F31 - LEAN TRANSACTIONS
F31K - DFM KANBAN MANAGEMENT
F34R - DFM RESOURCE MANAGEMENT

DISTRIBUTION AND LOGISTICS
38 - AGREEMENT MANAGEMENT
39 - ADVANCED STOCK VALUATION
40 - INVENTORY/OP BASE
40G - GROWER MANAGEMENT
40R - DEMAND SCHEDULING EXECUTION
41 - INVENTORY MANAGEMENT
41B - BULK INVENTORY MANAGEMENT
42 - SALES ORDER PROCESSING
42B - OW SALES ORDER ENTRY
42S - CUSTOMER SELF SERVICE
43 - PURCHASE ORDER PROCESSING
43A - PURCHASE ORDER RECEIPT/ROUTING
43B - VOUCHER MATCH AND LANDED COST
43C - GROWER PRICING AND PAYMENTS
43E - REQUISITION SELF SERVICE
43Q - OPERATIONAL SOURCING
43S - SUPPLIER SELF SERVICE
44H - HOMEBUILDER MANAGEMENT
45 - ADVANCED PRICE ANALYSIS
46 - WAREHOUSE MANAGEMENT
46L - LICENSE PLATING
49 - TRANSPORTATION/LOAD AND DELIVERY
80D - PLANT MANAGER DASHBOARD

TOOLS AND TECHNOLOGY
89 - CONVERSION PROGRAMS
H95 - TECH RESOURCES/APPLICATIONS

LOCALIZATION
74A - AUSTRIA
74P - POLAND
74U - UNITED KINGDOM
74R - RUSSIAN FEDERATION
75A - AUSTRALIA
75I - INDIA
75Z - NEW ZEALAND
76B - BRAZIL

UNKNOWN
07S -
07Y -
13E -
13R -
17C - CRM SERVICE MAINTENANCE REQUEST
77Y -
90CA - CRM FOUNDATION
90CB - SALES FORCE AUTOMATION
90CD - CRM SERVICE MANAGEMENT
90CE - CRM SERVICE SOLUTION ADVISOR
90CF - CRM SERVICE BRANCH SCRIPTING
90CG - CRM SERVICE CASE MANAGEMENT
H96U -
H99P -