OracleEBS12.2注册客制化应用
一、Oracle APP和DB的基本信息
创新互联建站专注于企业成都全网营销推广、网站重做改版、吴兴网站定制设计、自适应品牌网站建设、H5高端网站建设、电子商务商城网站建设、集团公司官网建设、外贸网站建设、高端网站制作、响应式网页设计等建站业务，价格优惠性价比高，为吴兴等各大城市提供网站开发制作服务。
1、应用和数据库环境：
Application Node in Linux7.3
Database Node on Linux 7.3
2、Oracle EBS 应用版本：
R12.2.6 on Linux7.3 x_86(64bit)
3、数据库信息：
Oracle Database R12.1.0.2 on Linux 7.3 x_86(64bit)
二、实现步骤
1、在数据库中创建cux用户，并授权。相关命令如下：
--（1）创建cux用户 CREATE USER CUX IDENTIFIED BY CUX DEFAULT TABLESPACE APPS_TS_TX_DATA TEMPORARY TABLESPACE TEMP1 PROFILE DEFAULT ACCOUNT UNLOCK; --(2）给出现用户授权 GRANT CONNECT, RESOURCE TO CUX; GRANT CREATE ANY CONTEXT TO CUX; GRANT CREATE ANY TYPE TO CUX; GRANT CREATE CLUSTER TO CUX; GRANT CREATE DATABASE LINK TO CUX; GRANT CREATE DIMENSION TO CUX; GRANT CREATE INDEXTYPE TO CUX; GRANT CREATE LIBRARY TO CUX; GRANT CREATE MATERIALIZED VIEW TO CUX; GRANT CREATE OPERATOR TO CUX; GRANT CREATE PROCEDURE TO CUX; GRANT CREATE PUBLIC SYNONYM TO CUX; GRANT CREATE SEQUENCE TO CUX; GRANT CREATE SYNONYM TO CUX; GRANT CREATE TABLE TO CUX; GRANT CREATE TRIGGER TO CUX; GRANT CREATE TYPE TO CUX; GRANT CREATE VIEW TO CUX; 2、在Oracle官方网站下载3636980补丁，补丁为p3636980_R12_GENERIC.zip。 3、解压补丁p3636980_R12_GENERIC.zip，并将一下三个文件从p3636980_R12_GENERIC\3636980\izu\admin 下copy到当前用户的desktop/ 下。文件如下： izuprod.txt izuterr.txt newprods.txt 4、izupord.txt重命名为cuxprod.txt,izuterr.txt 重命名为cuxterr.txt。相关命令如下： mv izupord.txt cuxprod.txt mv izuterr.txt cuxterr.txt 5、使用文本编辑器打开cuxprod.txt文件，将izu替换为cux,将IZU替换为CUX . %%% Splicer control file format 12.0.A # # $Header: newprods.txt 120.1 2006/09/20 12:57:45 jaobrien noship $ # # # Section for Oracle Support Diagnostic Tools product=cux base_product_top=*APPL_TOP* oracle_schema=cux sizing_factor=100 main_tspace=APPS_TS_TX_DATA index_tspace=APPS_TS_TX_IDX temp_tspace=TEMP1 default_tspace=APPS_TS_TX_DATA # end of Oracle Support Diagnostic Tools 6、使用文本编辑器打开cuxprod.txt，完成一下操作： （1）将cuxprod.txt文档中所有的izu替换为cux,IZU替换为CUX。 （2）修改产品的applID，将278修改为50000以上没有被使用的APPLID。检查APPLID 的SQL语句如下：
SQL>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) ); 如果想将278修改为50303，那么就在enter_custom_applID输入50303。若出现Selected number is Available 表示50303可用。
7、使用文本编辑器打开cuxterr.txt，执行如下操作：
（1）将izu替换为cux,将IZU替换为CUX 。
（2）将 Oracle_Support_Diagnostic_Tools 修改为 abcd_custom_appl
8、将以下三个文件拷贝到$APPL_TOP/admin 目录下。
cuxprod.txt
cuxterr.txt
newprods.txt
9、切换到$APPL_TOP/admin目录下，执行如下命令
$ adsplice Copyright (c) 2002, 2012 Oracle Corporation Redwood Shores, California, USA AD Splicer Version 12.2.0 NOTE: You may not use this utility for custom development unless you have written permission from Oracle Corporation. Your default directory is '/home/oraebs/apps/PROD/fs1/EBSapps/appl'. Is this the correct APPL_TOP [Yes] ? AD Splicer records your AD Splicer session in a text file you specify. Enter your AD Splicer log file name or press [Return] to accept the default file name shown in brackets. Your default directory is '/u01/app/oracle/fs1/EBSapps/appl'. Is this the correct APPL_TOP [Yes] ? Filename [adsplice.log] : adsplice_xxont.log You are about to install or upgrade Oracle E-Business Suite product tables in your ORACLE database 'D599' using ORACLE executables in '/u01/app/oracle/fs1/EBSapps/10.1.2'. Is this the correct database [Yes] ? Enter the password for your 'SYSTEM' ORACLE schema: Enter the ORACLE password of Application Object Library [APPS] : Please enter the directory where your AD Splicer control file is located. The default directory is [/u01/app/oracle/fs1/EBSapps/appl/admin] : Please enter the name of your AD Splicer control file [newprods.txt] : Do you wish to regenerate your environment file [Yes] ? Checking if AutoConfig is enabled.... Running AutoConfig on : All products ...
11、通过以下SQL语句，检查 adsplice 和 autoconfig 执行后的结果。
select * from fnd_application where application_short_name = 'CUX'; select * from fnd_product_installations where APPLICATION_ID = 50303; select * from dba_users where username = 'CUX';
登录用户节点，检查系统环境。
$ env|grep XXONT XXONT_TOP=/u01/app/oracle/fs1/EBSapps/appl/xxont/12.0.0 $ ls $XXONT_TOP admin log mesg out sql
如果您正在使用共享的APPL_TOP，则需要在其中一个节点上执行所有这些过程，然后在其他节点上运行 autoconfig。你不必重新运行adsplice。如果APPL_TOP未共享，请重复步骤8,9,10和11。
网页名称：OracleEBS12.2注册客制化应用
浏览路径：http://cdiso.cn/article/pgocsi.html
