网站导航
> 文章列表 > EBS R12.1 注册客户化应用的步骤

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

网友: 文章列表 2024-03-22 02:44:54

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

自定义

网络标签：

相关问题