E1 9.0 standalone language Release

Edelivery site released the new E1 9.0 standalone with language.

The download package with three zip file, also Database is support Oracle or MSSQL.

JD Edwards EnterpriseOne 9.0 Language Standalone-Oracle Local Database (Part 1 of 3)	V14265-01 Part 1 of 3	1.4G
JD Edwards EnterpriseOne 9.0 Language Standalone-Oracle Local Database (Part 2 of 3)	V14265-01 Part 2 of 3	1.5G
JD Edwards EnterpriseOne 9.0 Language Standalone-Oracle Local Database (Part 3 of 3)	V14265-01 Part 3 of 3	543M
JD Edwards EnterpriseOne 9.0 Language Standalone-Microsoft Local Database (Part 1 of 3)	V14475-01 Part 1 of 3	1.2G
JD Edwards EnterpriseOne 9.0 Language Standalone-Microsoft Local Database (Part 2 of 3)	V14475-01 Part 2 of 3	1.1G
JD Edwards EnterpriseOne 9.0 Language Standalone-Microsoft Local Database (Part 3 of 3)	V14475-01 Part 3 of 3	1.6G

The language install option is A,B,C on following:

Option A	Option B	Option C
English	English	English
Dutch	Arabic	Danish
French	Czech	Korean
German	Finnish	Traditional Chinese
Italian	Greek	Simplified Chinese
Japanese	Hungarian	Polish
Portuguese	Norwegian	Swedish
Spanish	Russian
	Turkish

Update: 1. Disk free space must more 10G with option C on SSE DB.
2. If you later need to change the group of languages to use, use Snapshot.exe to save off the existing Standalone Client installation,rerun the InstallManager.exe, select the desired language option, and finish the installation.

Also, the jdbj.ini on OC4J folder must modify the following value:
[JDBj-SPEC DATA SOURCE]
1. serverPort=3372 change to 1143
2.databaseInstance=JDELocal change to JDESSELocal

reference the later Blog: http://duaneduan.blogspot.com/2008/10/enterpriseone-90.html

E1 9.0 中文版发布下载

Standalone Version doesn't Install ASU OR ESU

The DEMO or Standalone version have not a Planner environment to install an ASU or an ESU. :(

A Hot New Book for JDE CNC

A Hot Book for JDE CNC

JD Edwards EnterpriseOne The Complete Reference Nov 2008

Implement and maintain a fully integrated, SOA-based ERP framework across your entire corporation. JD Edwards EnterpriseOne: The Complete Reference explains how to install and administer JD Edwards EnterpriseOne, store BI information in data marts and warehouses, manage servers and portals, and develop customized applications and kernel processes. You also learn how to create and distribute packages, use the security workbench,optimize performance, and apply the latest JD Edwards EnterpriseOne updates and tools releases.

BOOK RELEASE INFORMATiON

TiTLE : JD Edwards EnterpriseOne: The Complete Reference

AUTHOR : Allen Jacot , Joseph Miller , Michael Jacot , John Stern

PUBLISHER : McGraw-Hill Osborne Media

iSBN : 0071598731 MAKER : Team DDU

PAGES : 960 Pages PACKAGER : Team DDU

EDiTiON : November 19, 2008 SUPPLiER : Team DDU

LANGUAGE : ENGLISH FORMAT : PDF

RLS DATE : 02/15/09 SiZE : 29.3 MB

Download:
http://rapidshare.com/files/200695823/.JD.Edwards.EnterpriseOne.The.Complete.Reference.Nov.2008.rar

more information view:
http://www.amazon.com/exec/obidos/tg/detail/-/0071598731/#reader

This is a terrible week

A terrible Week in my life! and a unhappy birthday.

Free tool for viewing/testing JDE Objects

JDE Objects Browse
Author:Craig Welton
Version:1.0
Latest Update: 2/9/2009

Object Browser for XE through E90. Examine and test JDE objects from a simple, intuitive framework.
Current Features:

• Updated user interface with dockable panes
• Business Function testing
  • Paste parameters from clipboard (copied from jdedebug.log)
  • Save/Load parameters to/from a file
• Data Browser for tables and business views
• UBE Launcher with report interconnect values
• Data Structure spec browsing
• Table spec browsing
• Business View spec browsing
• Integrated Data Dictionary property tool

Download site:
http://www.patwel.com/downloads/index.htm

Objects View(APPL,BL,BSFN,BSVW,DSTR,GT,TABLE,UBE):
Data Browse

Test UBE
Test BSFN:
BSFN Specification(View Attachment):

EnterpriseOne PMD Data Process Flow

MENU:G80D

Inter company sales Report

Report ID:R4210IC, The data can be filter in following:
BC Date -Actual Ship Date (F4211) is equal to Null (DD:ADDJ) OR
BC Status Code -Next (F4211) is equal to "999" (DD:NXTR) OR
BC Document - Original (F4211) is not equal to Zero (DD:ODOC) OR
BC Sales Order Status 15 (F4211) is equal to "1" (DD:SO15) OR

BC Other Quantity (1/2) (F4211) is equal to "1,2" (DD:OTQY) OR
BC Units - Future Quantity Committed (F4211) is not equal to Zero (DD:SONE)

BC Inter Branch Sales (F4211) is not equal to "2" And (DD:SO01)
BC Inter Branch Sales (F4211) is not equal to "4" (DD:SO01)

How to change the date that defaults into Effective Thru on Bills of Materials?

The Effective Thru ( EFFT ) date is in some fields, like BOM Effective Date, Lot Effective Date,Etc...
default value is 2010/12/31, Now you can change it in DD:Century Change Year(CENTCHG). set it's default value to 30 or 40, 50. The Effective Thru Date can be to 2030/12/31,2040/12/31,2050/12/31.

E1 9.0 STANDALONE INSTALLED ON VISTA

Several days ago, i installed the E1 9.0 standalone on Windows Vista home version. The database is SSE(Sql Server Express)

The process of install is successful, but pop-up an error message box when i login in the JDE, the message is "unable to locate Security server".

Through lots of testing, analysis the log file, close the firewall and UAC(User Account Control), change the StartAppServer=ONDEMAND on section [LOCALWEB] in the JDE.INI, Etc, It's failed.

Finally I ready to leave, when I start the firewall , and login in again , The Solution Explorer appeared, It's OK, after start the UAC, the error message still pop-up.

SO, if u will installed the E1 on Vista, you must close the UAC, and start the firewall.

怎样更改WEB中网格显示的记录数

在JDE系统中web端的查询结果的默认记录数为10, 如果想改其他的数量，可以找到JAS.INI文件，在demo 812系统中路径为： \E812\system\OC4J\j2ee\home\applications\webclient.ear\webclient\WEB-INF\classes

找到[OWWEB]段
加入或更改 GlobalPageSize=xx 行，XX为所希望显示的记录数 。

例如:
GlobalPageSize=50

注意这个设置是需要在TOOLS 8.94以上才有效。

E812 APP RUN AT FAT CLIENT

E812以后的版本，控制了应用程序的运行方式，大部分P程序都只能在WEB下运行，除了部分管理程序，其控制的表为JDEOL812..F9860,字段为SIANSIF, W for Web, C for Client (Windows) or B for Both.如果想让其在FAT CLIENT下运行，可以修改此字段。

以下是DEMO812的更新F9860的sql例句：
UPDATE JDEOL812..F9860 SET SIANSIF='B' WHERE SIOBNM LIKE 'P%' AND SIANSIF='W'

这样的话就可以在Fat client端运行P程序了，但是报表还得在FAT client端运行。

E1 9.0 Standalone Oracle Local Database Login

login to JDE local Oracle database can with
login: JDEDATA900
password: JDEDATA900
host string: E1Local

Also use JDESY900, JDECTL900, etc