我的另一个博客，以英文为主，主要介绍OBIEE APPS与JDE的结合，欢迎大家点击。
http://jde-bi.blogspot.com/
2012年2月7日星期二
后台查看报表的数据选择
我们经常需要去检查提交服务器的报表, 查看其数据选择, 处理选项等等, 需要一个一个点菜单进去查看, 以下这个脚本可以帮助你在数据库后台查看这些数据
SELECT A.JCUSER,A.JCJOBNBR, JDAUDINFO,B.JCPID,B.JCVERS,A.JCJOBSTS,
A.JCENHV,A.JCFNDFUF2,B. JCSTDTIM,B.JCETDTIM,
JDEXEHOST,JDJOBNBR FROM SVM900.F986110 A
left join SVM900.F986114 B ON A.JCJOBNBR=B.JCJOBNBR
LEFT JOIN SVM900.F986114A C ON A.JCJOBNBR=C.JDJOBNBR
WHERE
JDEXEHOST = 'JDEDB' AND JDJOBNBR = 5296.000000 AND JDAUDTYP = '02' ;
备注:
1. 我所在的JDE环境中SVM900是存储提交报表的信息的OWNER, 你可以替换成你所需要.
2. 在Where条件段中, JDJOBNBR是服务器的报表NUMBER, 是唯一的.
3. 字段JDAUDTYP=’02‘ 是数据选择, '01':处理选项 , '03':排序, '04':报表关联,'05':相关的SQL脚本
4. 可以使用例如pl/sql developer等工具去执行查看结果 , 因为这个字段是 NCLOB.，所以需要点击JDAUDINFO栏位查看明细。
5. 可以灵活使用条件，做数据检查，可以加入时间段，或报表ID等条件去查看结果。
SELECT A.JCUSER,A.JCJOBNBR, JDAUDINFO,B.JCPID,B.JCVERS,A.JCJOBSTS,
A.JCENHV,A.JCFNDFUF2,B. JCSTDTIM,B.JCETDTIM,
JDEXEHOST,JDJOBNBR FROM SVM900.F986110 A
left join SVM900.F986114 B ON A.JCJOBNBR=B.JCJOBNBR
LEFT JOIN SVM900.F986114A C ON A.JCJOBNBR=C.JDJOBNBR
WHERE
JDEXEHOST = 'JDEDB' AND JDJOBNBR = 5296.000000 AND JDAUDTYP = '02' ;
备注:
1. 我所在的JDE环境中SVM900是存储提交报表的信息的OWNER, 你可以替换成你所需要.
2. 在Where条件段中, JDJOBNBR是服务器的报表NUMBER, 是唯一的.
3. 字段JDAUDTYP=’02‘ 是数据选择, '01':处理选项 , '03':排序, '04':报表关联,'05':相关的SQL脚本
4. 可以使用例如pl/sql developer等工具去执行查看结果 , 因为这个字段是 NCLOB.，所以需要点击JDAUDINFO栏位查看明细。
5. 可以灵活使用条件，做数据检查，可以加入时间段，或报表ID等条件去查看结果。
2009年7月2日星期四
2009年5月7日星期四
E1 Application Failure Records (p95400)
E1 Tools 8.98 程序p95400，可以对应用程序交易失败的记录进行查看，帮助客户管理失败的交易，如果JAS 是启动的，JAS将会检测交易的失败并且保存交易的数据在数据库中，通过emai通知系统管理员和最终用户，用户上线后，可以查看到保存的数据并可以重新提交这个交易。
这支增强程序提供机会给用户恢复交易数据在交易提交之前，或是程序崩溃，或是服务器反应慢，或是JAS与Enterprise Server之间的网络原因
数据保存以XML的格式保存在表F95400中，对于交易界面，所有的可视控制与数据栏位都保持下来了，对于浏览器界面，没有数据保存。
用户可以设置邮件提醒当交易失败的时候，然后用户会收到一个快捷方式指向P95400 .
E1 9.0 Demo (Oracle DB) Installed
My laptop environment:
Windows XP professional SP3 (English); 2G memory; For JDE disk space:20G
install step:
1. Download three files include language with oracle db from edeliver.oracle.com
V14265-01_1of3.zip : 1.33G, V14265-01_2of3.zip : 1.50G,V14265-01_3of3.zip : 543M
2. Unzip three file in a folder d:\standalone900\oracle\
3. Create a folder in JDE install folder g:\Oracle
4. Run d:\standalone900\oracle\InstallManager.exe
5. First setup the oracle db environment, next will pop you to restart you computer when finish install oracle db.
6. reRun d:\standalone900\oracle\InstallManager.exe
7. Install the JDK (1.5 u 6)
8. copy the four folders(bin; jre ;include; lib) from the JDK instll folder to G:\E900\SYSTEM\JDK
The disk space expense16.8 G after install oracle&jde.
The Oracle DB standalone include several Language.
English:
Korean
French
Spainish
Japanese
Russian
Chinese - Simplified
Chinese-traditional
The OC4J Application server manager console web site is
http://localhost:8888/em/
user:oc4jadmin password:oc4jadmin
Windows XP professional SP3 (English); 2G memory; For JDE disk space:20G
install step:
1. Download three files include language with oracle db from edeliver.oracle.com
V14265-01_1of3.zip : 1.33G, V14265-01_2of3.zip : 1.50G,V14265-01_3of3.zip : 543M
2. Unzip three file in a folder d:\standalone900\oracle\
3. Create a folder in JDE install folder g:\Oracle
4. Run d:\standalone900\oracle\InstallManager.exe
5. First setup the oracle db environment, next will pop you to restart you computer when finish install oracle db.
6. reRun d:\standalone900\oracle\InstallManager.exe
7. Install the JDK (1.5 u 6)
8. copy the four folders(bin; jre ;include; lib) from the JDK instll folder to G:\E900\SYSTEM\JDK
The disk space expense16.8 G after install oracle&jde.
The Oracle DB standalone include several Language.
English:
Arabic
Korean
French
Spainish
Japanese
Russian
Chinese - Simplified
Chinese-traditional
The OC4J Application server manager console web site is
http://localhost:8888/em/
user:oc4jadmin password:oc4jadmin
2009年3月12日星期四
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.
The language install option is A,B,C on following:
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 中文版发布下载
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 中文版发布下载
2009年3月5日星期四
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. :(
2009年3月2日星期一
A Hot New Book for JDE CNC
A Hot Book for JDE CNC
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 : 0071598731MAKER : 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
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 workbenchBOOK 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
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
2009年2月26日星期四
2009年2月23日星期一
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:
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):
Version:1.0
Latest Update: 2/9/2009
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
http://www.patwel.com/downloads/index.htm
Objects View(APPL,BL,BSFN,BSVW,DSTR,GT,TABLE,UBE):
Test UBE
Test BSFN:
BSFN Specification(View Attachment):
2009年2月22日星期日
MENU:G80D
2009年2月5日星期四
Inter company sales Report
Report ID:R4210IC, The data can be filter in following:
BC Date -Actual Ship Date (F4211) is equal toNull (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 Inter Branch Sales (F4211) is not equal to "2" And (DD:SO01)
BC Inter Branch Sales (F4211) is not equal to "4" (DD:SO01)
BC Date -Actual Ship Date (F4211) is equal to
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 toZero (DD:SONE)
BC Units - Future Quantity Committed (F4211) is not equal to
BC Inter Branch Sales (F4211) is not equal to "2"
订阅：
博文 (Atom)
博文
