PTIAN EBS FORM开发（一）之环境配置-CSDN博客

本文链接：https://blog.csdn.net/pan_tian/article/details/7638111

本文档详细介绍了PTIAN EBS FORM开发的环境配置步骤，包括FORMS_PATH的设置，确保无中文路径并包含必要的pll文件，TNS配置中的TNS_ADMIN设置和tnsnames.ora文件的编辑，以及创建DEMO数据的五张表的过程。

摘要由CSDN通过智能技术生成

PTIAN EBS FORM开发（一）之环境配置

OS:Windows XP

Form Builder:Version 10.1.2.0.2

FORMS_PATH

FORMS_PATH是用于Form Builder找到attached libraries (.pll)文件的路径

注册表>HKEY_LOCAL_MACHINE>Software>Oracle>KEY_DevSuiteHome1>FORMS_PATH

注：FORMS_PATH路径中最好不要有中文，另外你fmb所在的路径也不要有中文，否则可能会遇到Error "FRM-10043: Cannot open file. "

并且要把基本的pll文件放置到FORMS_PATH下，基础的pll包括APPCORE.pll, APPCORE2.pll, APPDAYPK.pll, APPFLDR.pll, CUSTOM.pll, FNDSQF.pll, FV.pll, GHR.pll, GLOBE.pll, GMS.pll, HRKPI.pll, IGILUTIL.pll, IGILUTIL2.pll, JA.pll, JE.pll, JL.pll, OPM.pll, PQH_GEN.pll, PSA.pll, PSAC.pll, PSB.pll, VERT.pll, VERT1.pll, VERT2.pll, VERT3.pll, VERT4.pll, VERT5.pll

从$AU_TOP/forms/US下载缺失的fmb文件。
从$AU_TOP/resource下载缺失的pll文件。

如果打开form的时候还是报文件找不到之类的错误（FRM-10102，FRM-18108...）,那索性就把所有的$AU_TOP/forms/US和$AU_TOP/resource都考到$FORMS_PATH再试试。

TNS配置

设置TNS_ADMIN

TNS_ADMIN用于Forms Builder找到你的TNSNAMES.ora和SQLNET.ora文件

设置tnsnames.ora

TNS_ADMIN对应目录下的tnsnames.ora增加目标instance，这样Form就可以通过TNS连接instance

创建DEMO数据

1.创建5张表

dem_sales_reps（sales representative，销售员表）
dem_customers（客户表）
dem_products（产品表）
dem_orders（订单）
dem_order_lines（订单行）

drop table dem_sales_reps;

create table dem_sales_reps
(sales_rep_id           number(15)      not null,
 last_update_date       date            not null,
 last_updated_by        number(15)      not null,
 creation_date          date            not null,
 created_by             number(15)      not null,
 last_update_login      number(15)      not null,
 last_name              varchar2(50)    not null,
 first_name             varchar2(50)    not null,
 start_date             date,
 commission_plan_code   varchar2(1),
 attribute_category     varchar2(30),
 attribute1             varchar2(150),
 attribute2             varchar2(150),
 attribute3             varchar2(150),
 attribute4             varchar2(150),
 attribute5             varchar2(150),
 attribute6             varchar2(150),
 attribute7             varchar2(150),
 attribute8             varchar2(150),
 attribute9             varchar2(150),
 attribute10            varchar2(150));

create unique index dem_sales_reps_u1
on dem_sales_reps (sales_rep_id);
        
insert into dem_sales_reps
(sales_rep_id, last_update_date, last_updated_by, creation_date,
 created_by, last_update_login, last_name, first_name,
 start_date, commission_plan_code)
values 
(1001, '23-JUN-95', 1, '23-JUN-95', 1, 1, 
       'Magee', 'Colin', '14-MAY-90', 'A');
insert into dem_sales_reps
(sales_rep_id, last_update_date, last_updated_by, creation_date,
 created_by, last_update_login, last_name, first_name,
 start_date, commission_plan_code)
values 
(1002, '23-JUN-95', 1, '23-JUN-95', 1, 1, 
       'Giljum', 'Henry', '18-JAN-92', 'A');
insert into dem_sales_reps
(sales_rep_id, last_update_date, last_updated_by, creation_date,
 created_by, last_update_login, last_name, first_name,
 start_date, commission_plan_code)
values 
(1003, '23-JUN-95', 1, '23-JUN-95', 1, 1, 
       'Sedeghi', 'Yasmin', '18-FEB-91', 'A');
insert into dem_sales_reps
(sales_rep_id, last_update_date, last_updated_by, creation_date,
 created_by, last_update_login, last_name, first_name,
 start_date, commission_plan_code)
values 
(1004, '23-JUN-95', 1, '23-JUN-95', 1, 1, 
       'Nguyen', 'Mai', '22-JAN-92', 'A');
insert into dem_sales_reps
(sales_rep_id, last_update_date, last_updated_by, creation_date,
 created_by, last_update_login, last_name, first_name,
 start_date, commission_plan_code)
values 
(1006, '23-JUN-95', 1, '23-JUN-95', 1, 1, 
       'Dumas', 'Andre', '09-OCT-91', 'A');
insert into dem_sales_reps
(sales_rep_id, last_update_date, last_updated_by, creation_date,
 created_by, last_update_login, last_name, first_name,
 start_date, commission_plan_code)
values 
(1005, '23-JUN-95', 1, '23-JUN-95', 1, 1, 
       'Jones', 'Robert', '23-JUN-95', 'B');
insert into dem_sales_reps
(sales_rep_id, last_update_date, last_updated_by, creation_date,
 created_by, last_update_login, last_name, first_name,
 start_date, commission_plan_code)
values 
(1007, '23-JUN-95', 1, '23-JUN-95', 1, 1, 
       'Lee', 'Vicki', '10-OCT-92', 'A');
insert into dem_sales_reps
(sales_rep_id, last_update_date, last_updated_by, creation_date,
 created_by, last_update_login, last_name, first_name,
 start_date, commission_plan_code)
values 
(1008, '23-JUN-95', 1, '23-JUN-95', 1, 1, 
       'Stratton', 'Ruth', '27-JUN-93', 'B');

rem ******************************************************************
rem Create Customers table and populate it
rem ******************************************************************

drop table dem_customers;

create table dem_customers
(customer_id            number(15)      not null,
 last_update_date       date            not null,
 last_updated_by        number(15)      not null,
 creation_date          date            not null,
 created_by             number(15)      not null,
 last_update_login      number(15)      not null,
 name                   varchar2(50)    not null,
 phone                  varchar2(25),
 address                varchar2(400),
 city                   varchar2(30),
 state_code             varchar2(20),
 country                varchar2(30),
 postal_code            varchar2(75),
 credit_rating          varchar2(9),
 sales_rep_id           number(15),
 region_id              number(15),
 comments               varchar2(255),
 attribute_category     varchar2(30),
 attribute1             varchar2(150),
 attribute2             varchar2(150),
 attribute3             varchar2(150),
 attribute4             varchar2(150),
 attribute5             varchar2(150),
 attribute6             varchar2(150),
 attribute7             varchar2(150),
 attribute8             varchar2(150),
 attribute9             varchar2(150),
 attribute10            varchar2(150));

create unique index dem_customers_u1
on dem_customers (customer_id);

insert into dem_customers
(customer_id, last_update_date, last_updated_by, creation_date,
 created_by, last_update_login, name, phone, address,
 city, state_code, postal_code, country, credit_rating, sales_rep_id,
 region_id, comments)
values 
(201, '23-JUN-95', 1, '23-JUN-95', 1, 1, 'Unisports', 
'55-2066101', '72 Mill Water','Milpitas', 'CA', '95035', 'USA', 'EXCELLENT', 
1001, 2, 'Brother of owner!');

insert into dem_customers
(customer_id, last_update_date, last_updated_by, creation_date,
 created_by, last_update_login, name, phone, address,
 city, state_code, postal_code, country, credit_rating, sales_rep_id,
 region_id, comments)
values 
(202, '23-JUN-95', 1, '23-JUN-95', 1, 1, 'Womansport', 
'1-206-104-0103', '3281 King Street','Seattle', 'WA', '98101', 'USA', 'GOOD', 
1001, 2, '');

insert into dem_customers
(customer_id, last_update_date, last_updated_by, creation_date,
 created_by, last_update_login, name, phone, address,
 city, state_code, postal_code, country, credit_rating, sales_rep_id,
 region_id, comments)
values 
(203, '23-JUN-95', 1, '23-JUN-95', 1, 1, 'Tornado Sports', 
'1-913-661-9699', '11629 We