Oracle+EBS+Forms开发指南（中级）

信息技术最佳实践 ORACLE核心应用技术 E-BUSINESS SUITE Forms开发指南

Author: Creation Date: Last Updated: Document Ref: Version:

Approvals:

黄建华

October 16, 2006 March 24, 2013

DRAFT 1A

Copy Number _____

信息技术最佳实践 Doc Ref:

February 21, 2009

Document Control

Change Record

4

Date Author Version Change Reference 16-Oct-06 Jianhua.Huang Draft 1a No Previous Document

Reviewers

Name Position

Distribution

Copy No. Name Location 1 2 3 4 Library Master Project Library Project Manager

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.

Forms开发指南

File Ref: 614684.doc (v. DRAFT 1A )

Company Confidential - For internal use only

Document Control ii

信息技术最佳实践 Forms开发指南

File Ref: 614684.doc (v. DRAFT 1A )

Doc Ref:

February 21, 2009

Contents

Document Control .................................................................................................................. ii 1.

Folder、JTF Grid ...................................................................................................... 2

1.1.

Folder开发步骤（从头开始） ........................................................................... 2 1.2. Folder问题 .......................................................................................................... 7 1.3. Folder开发步骤（基于模版） ........................................................................... 7 1.4. JTF Grid开发步骤 ............................................................................................. 10 2.

多语言开发 ............................................................................................................... 14

2.1. 国际化支持 ........................................................................................................ 14 2.2. Form自身的多语言版本 ................................................................................... 14 2.3. 数据多语言开发步骤 ........................................................................................ 14 2.4. EBS启用新语言时的考虑 ................................................................................. 22 3.

附件开发 ................................................................................................................... 24

3.1. 关于附件 ............................................................................................................ 24 3.2. 标准附件设置 .................................................................................................... 24 4.

Javabean ................................................................................................................... 29

4.1. Form与Java ....................................................................................................... 29 4.2. 例子：Hello World .......................................................................................... 31 4.3. 例子：执行PC本地命令 ................................................................................... 34 4.4. 例子：读取PC文本文件 ................................................................................... 37 4.5. 例子：通用导入 ................................................................................................ 39 5.

Form个性化 .............................................................................................................. 41

5.1. Form个性化概述 ............................................................................................... 41

5.2. 例子：修改字段Prompt ................................................................................... 42 5.3. 例子：有条件显示消息 .................................................................................... 43 5.4. 例子：调用数据库Package .............................................................................. 44 5.5. 例子：添加菜单 ................................................................................................ 44 5.6. 例子：打开功能 ................................................................................................ 45 5.7. 例子：执行查询 ................................................................................................ 46 5.8. 例子：其他应用 ................................................................................................ 47 5.9. 例子：Instance间迁移 ..................................................................................... 48 6.

技巧、常用代码 ....................................................................................................... 49

6.1. Form中的变量................................................................................................... 49 6.2. 初始值、格式掩码 ............................................................................................ 49 6.3. 消息处理 ............................................................................................................ 50 6.4. Special菜单 ....................................................................................................... 50 6.5.

库存组织访问 .................................................................................................... 50

Document Control iii

Company Confidential - For internal use only

信息技术最佳实践 Doc Ref:

February 21, 2009

6.6. 6.7. 6.8. 7.

MFG_ORGANIZATION_ID相关问题 .......................................................... 51 常用内置过程 .................................................................................................... 52 待续 .................................................................................................................... 52 Open and Closed Issues for this Deliverable ...................................................... 53

Open Issues ..................................................................................................................... 53 Closed Issues .................................................................................................................. 53 Forms开发指南

File Ref: 614684.doc (v. DRAFT 1A )

Company Confidential - For internal use only

Document Control iv

信息技术最佳实践 Doc Ref:

February 21, 2009

1. Folder、JTF Grid

1.1. Folder开发步骤（从头开始）

本节标题说明：标准指做Folder都要做而且是一样的步骤，可以考虑做个模版了；普通指和做普通Form一样；特殊指做Folder都要做但需要根据实际内容作修改。 1.1.1.

什么是Folder

Folder不是Form的标准功能，而是Oracle自己在EBS开发中总结出来的“动态界面”：不同用户可以根据自己的需要，设置块中哪些字段需要显示以及顺序；而开发人员则免于被布局折腾的痛苦。

对于开发来说，要做的事情就是用“遵循Folder规范”换取“布局零工作量”。 1.1.2.

拷贝标准Folder对象

标准

打开APPSTAND.fmb，把对象组“STANDARD_FOLDER”拖到我们自己的Form中，并选择“Subclass”而非“Copy”，这个和前面讲的查询块不同。

这样会自动产生一系列用于Folder的对象：块、画布、Lov/记录组、参数、Property Classes、Window，这些都不用修改。 1.1.3.

引用Folder的PLL库

标准

选中Attached Libraries，点击“+”，选择APPFLDR.pll，如果本地没有请先从服务器下载。

点击Attach后选择“Yes”移除绝对路径。 1.1.4.

创建数据库对象

普通

创建数据库对象，没有任何特殊之处：

-- Create table

create table SCF.CUX_FLODER_DEMO (

FLODER_DEMO_ID NUMBER not null, NUMBER_FIELD1 NUMBER not null, NUMBER_FIELD2 NUMBER, NUMBER_FIELD3 NUMBER, NUMBER_FIELD4 NUMBER,

DATE_FIELD1 DATE NOT NULL, DATE_FIELD2 DATE, Forms开发指南

File Ref: 614684.doc (v. DRAFT 1A )

Company Confidential - For internal use only

Folder、JTF Grid 2 of 56

本文来源：https://www.bwwdw.com/article/rxxa.html