EBS R12.1 注册客户化应用的步骤

1. 创建客户化应用目录

登录成 applxxx 用户   -- applxxx 改成所需用户名 # 以标准INV模块作为客户化应用目录的模板 cd $APPL_TOP mkdir -p  cust cp -r inv cust/template cd cust # 删除template 目录下的文件，只保留目录结构 cd $APPL_TOP/cust for rm_list in `find . -type f`    do rm $rm_list done # 复制客户化应用目录 cd $APPL_TOP/cust cp -r  template cap cp -r  template car cp -r  template cce cp -r  template ccm cp -r  template cfa cp -r  template cfnd cp -r  template cgl cp -r  template cinv cp -r  template cnv cp -r  template cpa cp -r  template cper cp -r  template cpo cp -r  template if # 修改客户化应用目录版本号 cd $APPL_TOP/cust for a in `ls` do echo $a mv $a/12.0.0 $a/1.0.0 done # 删除template目录 cd $APPL_TOP/cust rm -rf template

1. 创建客户化表空间

登录成 oraxxx 用户   -- oraxxx 改成所需用户名 sqlplus '/ as sysdba' # 创建CUST_GENERAL_D存放客户化数据 create tablespace CUST_GENERAL_D datafile '/datavg36/TFDEV/db/apps_st/data/cust_general_d01.dbf' size 10m ; alter  tablespace CUST_GENERAL_D add datafile '/datavg36/TFDEV/db/apps_st/data/cust_general_d02.dbf' size 10m ; alter  tablespace CUST_GENERAL_D add datafile '/datavg36/TFDEV/db/apps_st/data/cust_general_d03.dbf' size 10m ; alter  tablespace CUST_GENERAL_D add datafile '/datavg36/TFDEV/db/apps_st/data/cust_general_d04.dbf' size 10m ; alter  tablespace CUST_GENERAL_D add datafile '/datavg36/TFDEV/db/apps_st/data/cust_general_d05.dbf' size 10m ; # 创建CUST_GENERAL_X存放客户化索引 create tablespace CUST_GENERAL_X datafile '/datavg36/TFDEV/db/apps_st/data/cust_general_x01.dbf' size 10m ; alter  tablespace CUST_GENERAL_X add datafile '/datavg36/TFDEV/db/apps_st/data/cust_general_x02.dbf' size 10m ; alter  tablespace CUST_GENERAL_X add datafile '/datavg36/TFDEV/db/apps_st/data/cust_general_x03.dbf' size 10m ; alter  tablespace CUST_GENERAL_X add datafile '/datavg36/TFDEV/db/apps_st/data/cust_general_x04.dbf' size 10m ; alter  tablespace CUST_GENERAL_X add datafile '/datavg36/TFDEV/db/apps_st/data/cust_general_x05.dbf' size 10m ; # 把CUST_GENERAL_D和CUST_GENERAL_X数据文件改为自动扩展，并且设置最大扩展容量为2G。 select 'alter database datafile '||file_id||' autoextend on maxsize 2000m;' from dba_data_files where tablespace_name like 'CUST_GENERAL%'; # 执行以上生成的动态 ‘alter database datafile’ 语句

1. 创建客户化应用的用户帐号

登录成 oraxxx 用户   -- oraxxx 改成所需用户名 sqlplus '/ as sysdba' create user CAP identified by CAP default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CAR identified by CAR default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CCE identified by CCE default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CCM identified by CCM default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CFA identified by CFA default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CFND identified by CFND default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CGL identified by CGL default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CINV identified by CINV default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CNV identified by CNV default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CPA identified by CPA default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CPER identified by CPER default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user CPO identified by CPO default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x; create user IF identified by IF default tablespace cust_general_d temporary tablespace temp quota unlimited on cust_general_d quota unlimited on cust_general_x;

1. 授权客户化应用的用户帐号基本权限

登录成 oraxxx 用户   -- oraxxx 改成所需用户名 sqlplus '/ as sysdba' grant resource to cap; grant connect to cap; grant create table to cap; grant create view to cap; grant create procedure to cap; grant create synonym to cap; grant create sequence to cap; grant resource to car; grant connect to car; grant create table to car; grant create view to car; grant create procedure to car; grant create synonym to car; grant create sequence to car; grant resource to cce; grant connect to cce; grant create table to cce; grant create view to cce; grant create procedure to cce; grant create synonym to cce; grant create sequence to cce; grant resource to ccm; grant connect to ccm; grant create table to ccm; grant create view to ccm; grant create procedure to ccm; grant create synonym to ccm; grant create sequence to ccm; grant resource to cfa; grant connect to cfa; grant create table to cfa; grant create view to cfa; grant create procedure to cfa; grant create synonym to cfa; grant create sequence to cfa; grant resource to cfnd; grant connect to cfnd; grant create table to cfnd; grant create view to cfnd; grant create procedure to cfnd; grant create synonym to cfnd; grant create sequence to cfnd; grant resource to cgl; grant connect to cgl; grant create table to cgl; grant create view to cgl; grant create procedure to cgl; grant create synonym to cgl; grant create sequence to cgl; grant resource to cinv; grant connect to cinv; grant create table to cinv; grant create view to cinv; grant create procedure to cinv; grant create synonym to cinv; grant create sequence to cinv; grant resource to cnv; grant connect to cnv; grant create table to cnv; grant create view to cnv; grant create procedure to cnv; grant create synonym to cnv; grant create sequence to cnv; grant resource to cpa; grant connect to cpa; grant create table to cpa; grant create view to cpa; grant create procedure to cpa; grant create synonym to cpa; grant create sequence to cpa; grant resource to cper; grant connect to cper; grant create table to cper; grant create view to cper; grant create procedure to cper; grant create synonym to cper; grant create sequence to cper; grant resource to cpo; grant connect to cpo; grant create table to cpo; grant create view to cpo; grant create procedure to cpo; grant create synonym to cpo; grant create sequence to cpo; grant resource to if; grant connect to if; grant create table to if; grant create view to if; grant create procedure to if; grant create synonym to if; grant create sequence to if;

1. 为客户化应用的用户帐号创建APPS_DDL和APPS_ARRAY_DDL存储过程

登录成 applxxx 用户   -- applxxx 改成所需用户名 # 执行命令如下 # 格式：sqlplus apps/<apps pwd> @$AD_TOP/patch/115/sql/<AD script> <system pwd> <custom schema name> <custom schema pwd> sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddls.pls manager cap cap sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddls.pls manager cap cap sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddlb.pls manager cap cap sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddlb.pls manager cap cap sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddls.pls manager car car sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddls.pls manager car car sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddlb.pls manager car car sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddlb.pls manager car car sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddls.pls manager cce cce sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddls.pls manager cce cce sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddlb.pls manager cce cce sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddlb.pls manager cce cce sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddls.pls manager ccm ccm sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddls.pls manager ccm ccm sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddlb.pls manager ccm ccm sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddlb.pls manager ccm ccm sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddls.pls manager cfa cfa sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddls.pls manager cfa cfa sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddlb.pls manager cfa cfa sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddlb.pls manager cfa cfa sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddls.pls manager cfnd cfnd sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddls.pls manager cfnd cfnd sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddlb.pls manager cfnd cfnd sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddlb.pls manager cfnd cfnd sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddls.pls manager cgl cgl sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddls.pls manager cgl cgl sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddlb.pls manager cgl cgl sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddlb.pls manager cgl cgl sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddls.pls manager cinv cinv sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddls.pls manager cinv cinv sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddlb.pls manager cinv cinv sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddlb.pls manager cinv cinv sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddls.pls manager cnv cnv sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddls.pls manager cnv cnv sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddlb.pls manager cnv cnv sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddlb.pls manager cnv cnv sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddls.pls manager cpa cpa sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddls.pls manager cpa cpa sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddlb.pls manager cpa cpa sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddlb.pls manager cpa cpa sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddls.pls manager cper cper sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddls.pls manager cper cper sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddlb.pls manager cper cper sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddlb.pls manager cper cper sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddls.pls manager cpo cpo sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddls.pls manager cpo cpo sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddlb.pls manager cpo cpo sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddlb.pls manager cpo cpo sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddls.pls manager if if sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddls.pls manager if if sqlplus apps/apps @$AD_TOP/patch/115/sql/adaddlb.pls manager if if sqlplus apps/apps @$AD_TOP/patch/115/sql/adaaddlb.pls manager if if

1. 添加客户化应用的环境变量

登录成 applxxx 用户   -- applxxx 改成所需用户名 cp -p $CONTEXT_FILE $CONTEXT_FILE.bak.<yymmdd> vi $CONTEXT_FILE # 搜索AU_TOP字眼，在AU_TOP下面增加如下客户化应用的路径，然后保存文件 <CAP_TOP oa_var="s_captop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/cap/1.0.0</CAP_TOP> <CAR_TOP oa_var="s_cartop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/car/1.0.0</CAR_TOP> <CCE_TOP oa_var="s_ccetop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/cce/1.0.0</CCE_TOP> <CCM_TOP oa_var="s_ccmtop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/ccm/1.0.0</CCM_TOP> <CFA_TOP oa_var="s_cfatop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/cfa/1.0.0</CFA_TOP> <CFND_TOP oa_var="s_cfndtop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/cfnd/1.0.0</CFND_TOP> <CGL_TOP oa_var="s_cgltop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/cgl/1.0.0</CGL_TOP> <CINV_TOP oa_var="s_cinvtop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/cinv/1.0.0</CINV_TOP> <CNV_TOP oa_var="s_cnvtop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/cnv/1.0.0</CNV_TOP> <CPA_TOP oa_var="s_cpatop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/cpa/1.0.0</CPA_TOP> <CPER_TOP oa_var="s_cpertop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/cper/1.0.0</CPER_TOP> <CPO_TOP oa_var="s_cpotop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/cpo/1.0.0</CPO_TOP> <IF_TOP oa_var="s_iftop" oa_type="PROD_TOP" oa_enabled="FALSE">/datavg36/TFDEV/apps/apps_st/appl/cust/if/1.0.0</IF_TOP> # 修改default.env内容，增加客户化应用的路径，然后保存文件 cp -p $INST_TOP/ora/10.1.2/forms/server/default.env $INST_TOP/ora/10.1.2/forms/server/default.env.bak.<yymmdd> vi $INST_TOP/ora/10.1.2/forms/server/default.env # 搜索AU_TOP字眼，在AU_TOP下面增加如下客户化应用的路径，然后保存文件 CAP_TOP=/datavg36/TFDEV/apps/apps_st/appl/cust/cap/1.0.0 CAR_TOP=/datavg36/TFDEV/apps/apps_st/appl/cust/car/1.0.0 CCE_TOP=/datavg36/TFDEV/apps/apps_st/appl/cust/cce/1.0.0 CCM_TOP=/datavg36/TFDEV/apps/apps_st/appl/cust/ccm/1.0.0 CFA_TOP=/datavg36/TFDEV/apps/apps_st/appl/cust/cfa/1.0.0 CFND_TOP=/datavg36/TFDEV/apps/apps_st/appl/cust/cfnd/1.0.0 CGL_TOP=/datavg36/TFDEV/apps/apps_st/appl/cust/cgl/1.0.0 CINV_TOP=/datavg36/TFDEV/apps/apps_st/appl/cust/cinv/1.0.0 CNV_TOP=/datavg36/TFDEV/apps/apps_st/appl/cust/cnv/1.0.0 CPA_TOP=/datavg36/TFDEV/apps/apps_st/appl/cust/cpa/1.0.0 CPER_TOP=/datavg36/TFDEV/apps/apps_st/appl/cust/cper/1.0.0 CPO_TOP=/datavg36/TFDEV/apps/apps_st/appl/cust/cpo/1.0.0 IF_TOP=/datavg36/TFDEV/apps/apps_st/appl/cust/if/1.0.0 # 必须退出applxxx 用户，重新登录，使新的客户化变量定义生效 # 重启应用服务 cd $INST_TOP/admin/scripts adstpall.sh apps/<apps pwd>  -- 确认所有应用进程完全停下 adstrtal.sh apps/<apps pwd>

1. 注册客户化应用

登录应用前台sysadmin 进入: 应用开发员> 应用产品> 注册 应用 简称 基本路径 说明 CMCC Alert Customization CCM CCM_TOP CMCC Alert Customization CMCC Application Object Library Customization CFND CFND_TOP CMCC Application Object Library Customization CMCC Assets Customization CFA CFA_TOP CMCC Assets Customization CMCC Cash Management Customization CCE CCE_TOP CMCC Cash Management Customization CMCC Conversion Program CNV CNV_TOP CMCC Conversion Program CMCC General Ledger Customization CGL CGL_TOP CMCC General Ledger Customization CMCC Human Resource CPER CPER_TOP CMCC Human Resource CMCC Interface Customization IF IF_TOP CMCC Interface Customization CMCC Inventory Customization CINV CINV_TOP CMCC Inventory Customization CMCC Payables Customization CAP CAP_TOP CMCC Payables Customization CMCC Project Accounting Customization CPA CPA_TOP CMCC Project Accounting Customization CMCC Purchasing Customization CPO CPO_TOP CMCC Purchasing Customization CMCC Receivables Customization CAR CAR_TOP CMCC Receivables Customization

1. 注册Oracle用户

登录应用前台sysadmin 进入: 系统管理员> 安全性> ORACLE> 注册 数据库用户名 口令 权限 安装组 说明 CCM ccm 启用 0 CMCC Alert Customization CFND cfnd 启用 0 CMCC Application Object Library Customization CFA cfa 启用 0 CMCC Assets Customization CCE cce 启用 0 CMCC Cash Management Customization CNV cnv 启用 0 CMCC Conversion Program CGL cgl 启用 0 CMCC General Ledger Customization CPER cper 启用 0 CMCC Human Resource IF if 启用 0 CMCC Interface Customization CINV cinv 启用 0 CMCC Inventory Customization CAP cap 启用 0 CMCC Payables Customization CPA cpa 启用 0 CMCC Project Accounting Customization CPO cpo 启用 0 CMCC Purchasing Customization CAR car 启用 0 CMCC Receivables Customization

1. 定义数据组

登录应用前台sysadmin 进入: 系统管理员> 安全性> ORACLE> 数据组 数据组：标准 说明：Standard Data Group 应用 Oracle标识 说明 CMCC Alert Customization APPS CMCC Application Object Library Customization APPS CMCC Assets Customization APPS CMCC Cash Management Customization APPS CMCC Conversion Program APPS CMCC General Ledger Customization APPS CMCC Human Resource APPS CMCC Interface Customization APPS CMCC Inventory Customization APPS CMCC Payables Customization APPS CMCC Project Accounting Customization APPS CMCC Purchasing Customization APPS CMCC Receivables Customization APPS

1. 定义预警客户化应用

登录应用前台sysadmin 进入: 预警系统管理器> System> Installations 应用 Oracle用户名 状态 CMCC Alert Customization CCM 自定义 CMCC Application Object Library Customization CFND 自定义 CMCC Assets Customization CFA 自定义 CMCC Cash Management Customization CCE 自定义 CMCC Conversion Program CNV 自定义 CMCC General Ledger Customization CGL 自定义 CMCC Human Resource CPER 自定义 CMCC Interface Customization IF 自定义 CMCC Inventory Customization CINV 自定义 CMCC Payables Customization CAP 自定义 CMCC Project Accounting Customization CPA 自定义 CMCC Purchasing Customization CPO 自定义 CMCC Receivables Customization CAR 自定义