没有合适的资源?快使用搜索试试~ 我知道了~
Oracle EBS form 开发
需积分: 0 0 下载量 52 浏览量
2023-11-30
15:22:30
上传
评论
收藏 3.5MB DOC 举报
温馨提示
试读
143页
Oracle EBS form 开发
资源推荐
资源详情
资源评论
Oracle ERP最佳技术实践
E-BUSINESS SUITE
ORACLE 核心应用技术
Forms开发指南
Author: 黄建华
Creation Date: October 16, 2006
Last Updated: July 21, 2021
Document Ref: <Document Reference Number>
Version: DRAFT 1A
Approvals:
<Approver 1>
<Approver 2>
Copy Number _____
2
Document Control
Change Record
5
Date
Author
Version
Change Reference
16-Oct-06
Jianhua.Huang
Draft 1a
No Previous Document
Reviewers
Name
Position
Distribution
Copy No.
Name
Location
1
Library Master
Project Library
2
Project Manager
3
4
Note To Holders:
If you receive an electronic copy of this document and print it out, please write your
name on the equivalent of the cover page, for document control purposes.
If you receive a hard copy of this document, please write your name on the front
cover, for document control purposes.
3
Contents
Document Control ...................................................................................................................ii
1. 开发背景与基础 ..........................................................................................................2
1.1. 读者基础要求 .......................................................................................................2
1.2. 用户和常用工具 ...................................................................................................2
1.3. AOL开发框架 ......................................................................................................2
1.4. 多组织支持 ...........................................................................................................6
1.5. 主要实例 ...............................................................................................................6
2. 基于EBS的Forms开发过程 ........................................................................................8
2.1. Form文件类型......................................................................................................8
2.2. Forms Builder安装..............................................................................................8
2.3. 下载Template相关文件 ....................................................................................12
2.4. 一个简单的例子.创建数据库对象 ....................................................................14
2.5. 一个简单的例子.从模版开始设计 ....................................................................25
2.6. 一个简单的例子.编写数据操作触发器 ............................................................32
2.7. 一个简单的例子.上传&编译 .............................................................................37
2.8. 一个简单的例子.在EBS中注册运行 .................................................................37
3. 参数、List、LOV、字段和记录控制、日历 .........................................................40
3.1. 例子:Parameter参数.......................................................................................40
3.2. 例子:List值列表 ..............................................................................................41
3.3. 例子:LOV窗口式值列表.................................................................................42
3.4. 例子:字段和记录控制 .....................................................................................44
3.5. 例子:日历 .........................................................................................................45
3.6. 上传&编译&运行...............................................................................................46
4. 行指示符、主从块、滚动条、Stacked&Tab画布、多行文本.............................47
4.1. 例子:销售订单行 .............................................................................................47
4.2. 例子:Master-Detail主从块.............................................................................49
4.3. 例子:滚动条 .....................................................................................................51
4.4. 例子:Stacked画布 ...........................................................................................52
4.5. 画布小结 .............................................................................................................57
4.6. 例子:Tab画布 ..................................................................................................59
4.7. 例子:控制Tab画布 ..........................................................................................62
4.8. 例子:多行文本框 .............................................................................................63
5. Lov查询、块查询、Button .....................................................................................65
5.1. 查询原理 .............................................................................................................65
5.2. 例子:Lov查询 ..................................................................................................65
5.3. 例子:块查询 .....................................................................................................67
4
5.4. 例子:Button .....................................................................................................69
6. 触发器层次关系、常用触发器编写规范 ................................................................70
6.1. 理解层次关系 .....................................................................................................70
6.2. 触发器原理 .........................................................................................................70
6.3. 基于EBS模版开发的触发器 ..............................................................................71
6.4. 一些触发器的理解 .............................................................................................72
7. 描述性弹性域、Key弹性域、Key弹性域查询 ......................................................74
7.1. 描述性弹性域开发步骤 .....................................................................................74
7.2. Key弹性域开发步骤 ..........................................................................................77
8. Folder、JTF Grid......................................................................................................80
8.1. Folder开发步骤(从头开始)..........................................................................80
8.2. Folder问题..........................................................................................................85
8.3. Folder开发步骤(基于模版)..........................................................................85
8.4. JTF Grid开发步骤..............................................................................................88
9. 多语言开发 ................................................................................................................92
9.1. 国际化支持 .........................................................................................................92
9.2. Form自身的多语言版本....................................................................................92
9.3. 数据多语言开发步骤 .........................................................................................92
9.4. EBS启用新语言时的考虑 ................................................................................100
10. 附件开发 ..................................................................................................................102
10.1. 关于附件 ...........................................................................................................102
10.2. 标准附件设置 ...................................................................................................102
11. Javabean ..................................................................................................................107
11.1. Form与Java......................................................................................................107
11.2. 例子:Hello World.........................................................................................109
11.3. 例子:执行PC本地命令..................................................................................112
11.4. 例子:读取PC文本文件..................................................................................115
11.5. 例子:CSV通用导入 .......................................................................................118
12. Form个性化.............................................................................................................122
12.1. Form个性化原理..............................................................................................122
12.2. 例子:修改字段Prompt..................................................................................123
12.3. 例子:有条件显示消息 ...................................................................................124
12.4. 例子:调用数据库Package.............................................................................125
12.5. 例子:添加菜单 ...............................................................................................125
12.6. 例子:打开功能 ...............................................................................................126
12.7. 例子:执行查询 ...............................................................................................127
12.8. 例子:Instance间迁移 ....................................................................................129
13. 技巧、常用代码 ......................................................................................................130
13.1. Form中的变量..................................................................................................130
13.2. 初始值、格式掩码 ...........................................................................................130
13.3. 消息处理 ...........................................................................................................131
13.4. Special菜单.......................................................................................................131
13.5. 库存组织访问 ...................................................................................................131
13.6. MFG_ORGANIZATION_ID相关问题.........................................................132
13.7. 常用内置过程 ...................................................................................................133
13.8. 待续 ...................................................................................................................133
5
附录:我开始学习Form时的笔记1,仅供参考,未必100%正确....................................134
附录:我开始学习Form时的笔记2,仅供参考,未必100%正确....................................137
14. Open and Closed Issues for this Deliverable.....................................................140
Open Issues....................................................................................................................140
Closed Issues .................................................................................................................140
剩余142页未读,继续阅读
资源评论
神经865
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功