Technology Document Oracle EBS Customization
--Web ADI
Author:
Johnson Huang(黄思镇)
Creation Date: 2011/02/18 Last Updated: 2011/03/23 Version:
备注：
本文档为free resource，仅作为促进技术交流使用；您可对文档的内容进行修改，及更新版本。
Copy Number 1.1
Oracle EBS Customization—Web ADI
1
1.1
QQ：886922
MSN：Johnson_hsz@hotmail.com
文件控管 Name
Position 变更记录 Date 2011/3/17 2011/6/14
Author Version Change Reference New Document 增加LOV实现的方式 Johnson Huang 1.0 Johnson Huang 1.1 检阅记录 Date
Location Position 发布记录 Copy No Name Location
Oracle EBS Customization—Web ADI
2
QQ：886922 MSN：Johnson_hsz@hotmail.com
Contents
Technology Document ..................................................................................................... 1 1. Web ADI介绍 ......................................................................................................................................... 5
1.1 What is Web ADI ......................................................................................................................... 5 1.2 What Web ADI can do ................................................................................................................ 5 1.3 How to use Web ADI .................................................................................................................. 5
2. 前置设定 ................................................................................................................................................... 5
2.1 浏览器设定 ...................................................................................................................................... 5 2.2 Excel设定 ....................................................................................................................................... 6 2.3 Responsibility设定 ....................................................................................................................... 8 2.4 开发权限设定 .................................................................................................................................. 8
3. 权限设定 ................................................................................................................................................... 9
3.1 Profile ........................................................................................................................................... 9 3.2 Form Function ........................................................................................................................... 11
4. Web ADI程式开发 ............................................................................................................................. 11
开发步骤 ............................................................................................................................................. 11 4.1 Create Database Object(Required) ........................................................................................ 11 4.2 Register Table and column(Required) ................................................................................... 12 4.3 Create Package(Required) ....................................................................................................... 13 4.4 Create Integrator(Required) ................................................................................................... 15 4.5 Associate Integrator and Function (Required) ..................................................................... 21 4.6 Define Layout(Required) ......................................................................................................... 23 4.7 Define Mapping(Optional) ...................................................................................................... 25 4.8 Modify Excel Prompt ............................................................................................................... 26
5. Web ADI程式使用 ............................................................................................................................. 27
5.1 下载Excel并Import数据 .............................................................................................................. 27
6. Web ADI程式开发-进阶 ................................................................................................................... 28
进阶开发包含 ...................................................................................................................................... 28 6.1 Defining Standalone Integrator Queries ............................................................................... 28 6.2 HR Maintain Standalone Query .............................................................................................. 30 6.3 创建Integrator快捷方式 ............................................................................................................. 30
Oracle EBS Customization—Web ADI
3
QQ：886922 MSN：Johnson_hsz@hotmail.com
7. 待解决问题 ............................................................................................................................................ 34
7.1 Excel显示Uploading the Document，但是Database已经有值 ............................................... 34
Open/Closed Issues .............................................................................................................................. 35
Open Issues ...................................................................................................................................... 35 Close Issues ...................................................................................................................................... 35
Oracle EBS Customization—Web ADI 4
QQ：886922 MSN：Johnson_hsz@hotmail.com
1. Web ADI介绍 1.1 What is Web ADI
WEB ADI全称是 WEB Application Development Integrator,原来是Oracle HRMS 模块提供的一个利用浏览器来进行存取的，在服务器段运行的self-service应用程序,后来经过不断地发展，现在基本可以用于一般模块的数据导入了。
Web ADI有两种，一种为Application Integrator，另一种为 Standalone Integrator。Application Integrator会与特定的Form相关联，User使用Form查询数据，使用Application Integrator Export数据。Standalone Integrator在建立时，指定其form name 为GENERAL，它不与任何Form相关联，而是通过Menu的方式执行。 在EBS 11环境中，Web ADI的职责名：Oracle Web ADI。 在EBS R12环境中，Web ADI的职责名：Desktop Integration
1.2 What Web ADI can do
利用Web ADI可以实现以下功能：
? 上传数据(upload data)，适用于数据来源为Excel的少量数据导入开发，支持从csv文件导入数据到Excel再上载
? 下载数据(download data)，类似于报表开发
? 更新数据(update or insert data),可以实现先下载数据，修改后更新，或者新增记录后再上载
一般在做Excel导入时，常用的做法是将Excel另存为csv档，然后将csv档上载到fnd_lobs，然后根据逗点去分割行，得到每一列。如果使用Web ADI，就不需要这么麻烦，直接请User在excel中维护数据，User点击Excel中的upload按钮，即可将数据上传至Form中，对与部分需求，方便又快捷。
1.3 How to use Web ADI
本文将介绍如何使用Web ADI实现常用的功能。
1.
2. 前置设定 2.1 浏览器设定
1. IE/Tools/Option/Security/Internet/自定义级别 把“对未标记为安全的ActivveX控件进行初始化和脚本
运行”设置为提示：
Oracle EBS Customization—Web ADI 5