Oracle EBS R12注册客户化模块-以FTBP为例

Creating a CustomApplication in Oracle E-Business Suite Release 12.2 (Doc ID 1577707.1)
Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2 (Doc ID 1577661.1)

su - oravis
sqlplus /nolog
conn / as sysdba
select file_name from dba_data_files where tablespace_name='SYSTEM';
/u01/VIS121/db/apps_st/data/system01.dbf
/u01/VIS121/db/apps_st/data/system02.dbf

create tablespace FTBP_TS_TX_DATA datafile '/u01/VIS121/db/apps_st/data/ftbp_ts_tx_data01.dbf' size 10m autoextend on maxsize 8192m;
alter tablespace FTBP_TS_TX_DATA add datafile '/u01/VIS121/db/apps_st/data/ftbp_ts_tx_data02.dbf' size 10m autoextend on maxsize 8192m;

create tablespace FTBP_TS_TX_IDX datafile '/u01/VIS121/db/apps_st/data/ftbp_ts_tx_idx01.dbf' size 10m autoextend on maxsize 8192m;
alter tablespace FTBP_TS_TX_IDX add datafile '/u01/VIS121/db/apps_st/data/ftbp_ts_tx_idx02.dbf' size 10m autoextend on maxsize 8192m;

set lines 200 pages 50000
col file_name for a60
col TABLESPACE_NAME for a30
select file_id,file_name,tablespace_name,autoextensible,BYTES/1024/1024,MAXBYTES/1024/1024,status from dba_data_files order by 1;
select file_id,file_name,tablespace_name,autoextensible,BYTES/1024/1024,MAXBYTES/1024/1024,status from dba_temp_files order by 1;

create user FTBP identified by Ftbp2019_Bk default tablespace FTBP_TS_TX_DATA;
alter user FTBP quota unlimited on FTBP_TS_TX_DATA;
alter user FTBP quota unlimited on FTBP_TS_TX_IDX;
GRANT CONNECT TO FTBP;
GRANT RESOURCE TO FTBP;
alter user FTBP default tablespace FTBP_TS_TX_DATA;

select segment_name from dba_segments where tablespace_name like 'FTBP%';
no rows selected

1、下载补丁3636980，拷贝3636980\izu\admin目录下3个.txt文件到/tmp目录下进行修改
如：izuprod.txt改名为ftbpprod.txt
izuterr.txt改名为ftbpterr.txt

2、修改newprods.txt内容
product=izu
base_product_top=*APPL_TOP*
oracle_schema=izu
sizing_factor=100
main_tspace=USER_DATA
index_tspace=USER_IDX
temp_tspace=TEMP
default_tspace=USER_DATA

以上为newprods.txt内容，修改为所要注册模块对应值，如：
product=ftbp
base_product_top=*APPL_TOP*
oracle_schema=ftbp
sizing_factor=100
main_tspace=FTBP_TS_TX_DATA
index_tspace=FTBP_TS_TX_IDX
temp_tspace=TEMP
default_tspace=FTBP_TS_TX_DATA

注意：文件中izu修改为ftbp，IZU修改为FTBP

3、修改ftbpprod.txt文件
替换文件中izu为ftbp，替换prodid 278为ftbp的唯一number
注意：文件中izu修改为ftbp，IZU修改为FTBP

如下SQL，可检查想要设置的prodid是否被占用
select decode(count,0, 'Selected number is Available', 'Selected number already in use') Status,&&enter_custom_applID selected_number
from
(
select count(*) as count from
(
select 'x' from fnd_oracle_userid
where oracle_id= &&enter_custom_applID
union
select 'x' from fnd_application
where application_id=&&enter_custom_applID
)
);
运行上述SQL，输入想要设置的prodid

4、修改ftbpterr.txt文件
替换文件中izu为ftbp，修改Oracle_Support_Diagnostic_Tools为ftbp_custom_app
注意：文件中izu修改为ftbp，IZU修改为FTBP

5、拷贝上述三个.txt文件到$APPL_TOP/admin下

6、运行adsplice命令
adsplice必须在$APPL_TOP/admin下运行
运行adsplice
当遇到如下提示时，默认回车
The defaultdirectory is [/u01/VIS121/apps/apps_st/appl/admin] :
Please enter thename of your AD Splicer control file [newprods.txt] :
Do you wish toregenerate your environment file [Yes] ?

7、确认客户化模块是否在数据库中创建
查看fnd_application中是否有FTBP记录
select * fromfnd_application where application_short_name = 'FTBP';

通过application_id查看fnd_product_installations中是否有记录
select * fromfnd_product_installations where APPLICATION_ID = 5001;
查看数据库用户是否创建成功
select * fromdba_users where username = 'FTBP';

[applvis@ebs admin]$ sqlplus ftbp/ftbp

重新应用环境变量，确认$FTBP_TOP
[applvis@ebs ~]$echo $FTBP_TOP
/u01/VIS121/apps/apps_st/appl/ftbp/12.0.0

[applvis@ebs ~]$ ls$FTBP_TOP
admin log mesg out sql

注意：如果之前使用fnd_oracle_user_pkg.lod_row API注册过模块，因为这些注册的密码将会被加密，注册后运行adpatch、adsplice将出错。

需要使用FNDCPASS来修改密码

如果应用使用shared APPL_TOP那么，只需要在剩余节点运行autoconfig
如果应用使用的是非shared APPL_TOP那么，需要在剩余节点重复上述5、6、7三步操作

以下步骤依据需求操作
1、创建客户化对象
在$FTBP_TOP中，

a)可以为form创建$FTBP_TOP/forms/US和$FTBP_TOP/forms/ZHS目录
b)可以为package创建$FTBP_TOP/admin/sql目录
c)可以为report创建$FTBP_TOP/reports/US和$FTBP_TOP/reports/ZHS
.
.
.

2、将所有客户化data object权限授予APPS用户
SQL> grant all privileges on myTable to apps;

APPS用户下创建相关同义词
SQL>create synonym myTable for FTBP.myTable;>

问题：
1、当下一次使用adop打补丁时，在prepare阶段，将会同步adsplice的操作到另一套FS
如果在同步过程失败，日志$APPL_TOP/admin/$TWO_TASK/log/adsplicelog出现
UPDATEFND_ORACLE_USERID SET READ_ONLY_FLAG = 'A' WHERE ORACLE_ID

解决方法：应用Patch18815526:R12.AD.C，重启prepare phase

The following arecurrently known issues:

 1、If you are anupgrade customer with a custom product top in the context file but have not runadsplice, you must remove the relevant entry from the FND_OAM_CONTEXT_CUSTOMtable and then run AutoConfig on all nodes.

2、The same approach needs to be taken ifyou have any custom context variables with more than eight characters, as acustom schema abbreviation cannot exceed eight charcters.

 After performing either of the above steps,you should run adsplice to add/register the custom product (after applying thelatest AD-TXK RUP).

注册应用
	进入“应用登记”界面，建立客户化应用。
	职责    ：系统管理员
	菜单路径：\主菜单\应用产品\注册。

应用系统中注册Oracle数据库帐户
	进入“数据库帐户登记”，在应用系统中注册Oracle帐户
	职责    ：系统管理员
	菜单路径：\主菜单\安全性\ORACLE\注册。

添加数据组至标准数据组
	职责    ：系统管理员
	菜单路径：\主菜单\安全性\ORACLE\数据组。
	查找标准数据组，添加客户化应用至标准数据组

select * from fnd_application where application_short_name = 'FTBP';
select * from fnd_product_installations where APPLICATION_ID = 30000;
select * from dba_users where username = 'FTBP';