ORACLE EBS R12
—OAF开发笔记
Author:
Jarwang(王重东)
Create Date: November 12, 2010
Update Date:
Control No:
Current Edition:
1.0
声明:本文可以任意免费转载、复制、传播。但您务必保持其完整性!
If you copy this document,you ought to keep the document completely.
Author:JarWang (王重东) QQ:jarwang@sina.com Copyright(R):Jarwang
1
Document Control
Modify Record
Approved
Distribute
日期
作者
版本
更改参考
November 12, 2010
jarwang
1.0
姓名
职位
签字
编码
姓名
地点和位置
1
2
3
4
Author:JarWang (王重东) QQ:jarwang@sina.com Copyright(R):Jarwang
2
Content
Document Control..............................................................................................................2
Modify Record.............................................................................................................2
Approved ......................................................................................................................2
Content...............................................................................................................................3
Preface................................................................................................................................5
Getting Start.......................................................................................................................6
Download Jdeveloper ................................................................................................6
Configure Jdeveloper .................................................................................................6
Configure EBS—OAF Environment................................................................................ 6
Verify EBS—OAF Environment ...................................................................................... 8
OAF Concept ................................................................................................................... 10
OAF & ADF .............................................................................................................. 10
OAF Objects Concept............................................................................................... 11
OAF Objects Naming ............................................................................................... 12
JSR168&JSR227 ......................................................................................................... 12
JSR168.............................................................................................................................. 13
JSR227.............................................................................................................................. 13
OAF Development .......................................................................................................... 15
OAF—Import Excel.................................................................................................. 15
Create OA Project ........................................................................................................... 15
Set Run Options in OA Project Settings........................................................................ 16
Create Data Table............................................................................................................ 17
Create the AM Object ..................................................................................................... 17
Create the VO Object...................................................................................................... 17
Add VO Object to AM.................................................................................................... 19
Create the Page ............................................................................................................... 19
Installation Thirty Jar...................................................................................................... 22
Create the Java Class for xls........................................................................................... 23
Create the Java Class for csv.......................................................................................... 23
Create the CO Object...................................................................................................... 24
Create Methods in AM................................................................................................... 29
Run PG ............................................................................................................................ 31
Deploying OAF............................................................................................................... 32
OAF—OATrainBean ................................................................................................ 35
Create Data Table............................................................................................................ 35
Create two EO Object ..................................................................................................... 36
Create the AO Object...................................................................................................... 38
Create two VO Object..................................................................................................... 39
Create the VL Object....................................................................................................... 42
Create the AM Object ..................................................................................................... 42
Add VO Objects to AM .................................................................................................. 43
Add two Method to AM for Header............................................................................. 43
Create the Page for Header............................................................................................ 44
Create the CO Object for Header................................................................................... 46
Run PG for Header......................................................................................................... 47
Create the Page for Lines ............................................................................................... 47
Add a Method to AM for Lines..................................................................................... 50
Create the CO Object for Lines ...................................................................................... 51
Implement the Currency Poplist for Lines ................................................................... 51
Add table button for Lines............................................................................................. 53
Run PG for Lines ............................................................................................................ 54
Create two VO for Preview............................................................................................ 54
Create the Page for Preview........................................................................................... 55
Create the CO Object for Preview ................................................................................. 58
Run PG for Preview........................................................................................................ 59
Create the OATrain ........................................................................................................ 59
Add OATrain to PG ....................................................................................................... 60
Add the PageButtons...................................................................................................... 61
Author:JarWang (王重东) QQ:jarwang@sina.com Copyright(R):Jarwang
3
Create the CO Object for ExpenseTrainFooterRN........................................................ 64
Run................................................................................................................................... 65
OAF—OATree .......................................................................................................... 66
Create OA Project ........................................................................................................... 66
Create Data Table............................................................................................................ 66
Create the VO Object...................................................................................................... 67
Create the AM Object ..................................................................................................... 67
Create the VL Object....................................................................................................... 68
Create the Page ............................................................................................................... 69
Create the CO Object...................................................................................................... 70
Run................................................................................................................................... 71
Personalization OAF ....................................................................................................... 72
Close OAF Personalization...................................................................................... 72
Clear OAF Cache...................................................................................................... 73
Extending OAF................................................................................................................ 74
OAF &JSP......................................................................................................................... 75
Delopy JSP................................................................................................................. 75
Delopy Servlet .......................................................................................................... 76
AutoLogin................................................................................................................. 77
Other Notes...................................................................................................................... 78
Author:JarWang (王重东) QQ:jarwang@sina.com Copyright(R):Jarwang
4
Preface
Oracle E-Business Suit R12终于全面升级11i古老的开发工具,并且全面将Java靠拢。OAF开发工具也不例外,
升级到JDeveloper10g。本文涉及OAF的中高级开发技巧,OAF的开发基础篇,请参考:
http://www.itpub.net/thread-1236269-1-1.html
本文参考文档:Oracle Application Framework Developer’s Guide Release 12.1.2
Author:JarWang (王重东) QQ:jarwang@sina.com Copyright(R):Jarwang
5
Getting Start
Download Jdeveloper
首先,得确认EBS所对应的OAF的版本。点击任意OAF页面的“About Page”链接。
到Metalink docID:787209.1。
Identify the OA Framework version in your instance by activating diagnostics and click the
"About This Page" from any OAF page. Click the "Technology Components" tab. The OA
Framework version in the top row of the table can then be matched to the JDeveloper Patch.
Configure Jdeveloper
Configure EBS—OAF Environment
1. 解压文件,得到jdevbin、 jdevdoc、jdevhome三个目录。
<特别注意:解压的目录不能含有空格、中文等。如:解压到C:\Program Files就不行啦。>
2. 为 \jdevbin\jdeveloper.exe创建一个桌面快捷方式。
3.1. 设置环境变量:JDEV_USER_HOME
3.2 获取*.dbc文件。登陆应用层的$FND_SECURE目录,下载*.dbc文件至
Author:JarWang (王重东) QQ:jarwang@sina.com Copyright(R):Jarwang
6
\dbc_files\secure目录。
3.3 分配职责:OA Framework ToolBox Tutorial、OA Framework ToolBox Tutorial Labs
3.4 启动Jdeveloper,并打开toolbox.jws工程。
3.5 设置DBC file
Author:JarWang (王重东) QQ:jarwang@sina.com Copyright(R):Jarwang
7
注:检查一下*.dbc文件是否使用了域名。
4. 配置数据库连接。
配置好连接参数(略)
4.1 将配置好的DB连接后,赋给tutorial工程。
Verify EBS—OAF Environment
配置好后,下面就开始测试配置是否正确啦?
1. 点击Tutorial工程,选择右键菜单的Rebuild。会出错很Warning,但不会出错ERROR。同时
会在JDEV_USER_HOME目录下自动生成一个oc4j实例。
2. 展开Tutorial.jpr工程的HTML Sources目录。选择test_fwktutorial.jsp,然后 选择 Run > Run
test_fwktutorial.jsp。很不幸,出现错啦:
oracle.apps.fnd.framework.OAException:
Application: FND, Message Name: SYSTEM-
ERROR. Tokens: MESSAGE = Io 8: The
Network Adapter could not establish the connection; (Could not lookup message because
there is no database connection)
Author:JarWang (王重东) QQ:jarwang@sina.com Copyright(R):Jarwang
8