EBS增加客制应用CUX：Custom Application

1. 创建数据库文件和帐号

[root@ebs12vis oracle]# su - oracle
[oracle@ebs12vis ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Sun May 24 10:13:48 2015

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create tablespace CUX_DATA datafile ‘/d01/oracle/VIS/db/apps_st/data/cux_data01.dbf‘ size 200M reuse autoextend on next 100M;

Tablespace created.

SQL> create tablespace CUX_INDEX datafile ‘/d01/oracle/VIS/db/apps_st/data/cux_index01.dbf‘ size 200M reuse autoextend on next 100M;

Tablespace created.

SQL> create temporary tablespace CUX_TEMP tempfile ‘/d01/oracle/VIS/db/apps_st/data/cux_temp01.dbf‘ size 200M;

Tablespace created.

SQL> create user cux identified by cux default tablespace CUX_DATA temporary tablespace CUX_TEMP;

User created.

SQL> grant resource to cux;

Grant succeeded.

SQL> grant connect to cux;

Grant succeeded.

SQL> grant create table to cux;

Grant succeeded.

SQL> grant create view to cux;

Grant succeeded.

SQL> grant create package to cux;
grant create package to cux
      *
ERROR at line 1:
ORA-00990: missing or invalid privilege

SQL> grant create synonym to cux;

Grant succeeded.

SQL> grant create sequence to cux;

Grant succeeded.

2. 创建客制应用文件目录结构（参考INV_TOP）

[root@ebs12vis ~]# su - applmgr
[applmgr@ebs12vis ~]$ cd $APPL_TOP/inv
[applmgr@ebs12vis inv]$ find . -type d -exec mkdir -p $APPL_TOP/cux/{} \;
[applmgr@ebs12vis inv]$ cd ..
[applmgr@ebs12vis appl]$ cd cux
[applmgr@ebs12vis cux]$ du
8       ./12.0.0/help/US
8       ./12.0.0/help/ZHS
24      ./12.0.0/help
8       ./12.0.0/html
8       ./12.0.0/reports/US
8       ./12.0.0/reports/ZHS
24      ./12.0.0/reports
8       ./12.0.0/log
8       ./12.0.0/lib
8       ./12.0.0/out
8       ./12.0.0/patch/115/import/US
8       ./12.0.0/patch/115/import/ZHS
24      ./12.0.0/patch/115/import
8       ./12.0.0/patch/115/odf
8       ./12.0.0/patch/115/xdf
8       ./12.0.0/patch/115/irep/patch/115/import/US
16      ./12.0.0/patch/115/irep/patch/115/import
8       ./12.0.0/patch/115/irep/patch/115/odf
8       ./12.0.0/patch/115/irep/patch/115/sql
40      ./12.0.0/patch/115/irep/patch/115
48      ./12.0.0/patch/115/irep/patch
8       ./12.0.0/patch/115/irep/java/ebi/item/server
16      ./12.0.0/patch/115/irep/java/ebi/item
24      ./12.0.0/patch/115/irep/java/ebi
32      ./12.0.0/patch/115/irep/java
88      ./12.0.0/patch/115/irep
8       ./12.0.0/patch/115/xml/US
8       ./12.0.0/patch/115/xml/ZHS
24      ./12.0.0/patch/115/xml
8       ./12.0.0/patch/115/driver
8       ./12.0.0/patch/115/publisher/templates/US
8       ./12.0.0/patch/115/publisher/templates/ZHS
24      ./12.0.0/patch/115/publisher/templates
8       ./12.0.0/patch/115/publisher/defs
40      ./12.0.0/patch/115/publisher
8       ./12.0.0/patch/115/sql
216     ./12.0.0/patch/115
224     ./12.0.0/patch
8       ./12.0.0/java/make
8       ./12.0.0/java/jar
24      ./12.0.0/java
8       ./12.0.0/xml/orc115
16      ./12.0.0/xml
8       ./12.0.0/forms/US
8       ./12.0.0/forms/ZHS
24      ./12.0.0/forms
8       ./12.0.0/mds/lov/webui/ZHS
16      ./12.0.0/mds/lov/webui
8       ./12.0.0/mds/lov/consign/webui/ZHS
16      ./12.0.0/mds/lov/consign/webui
24      ./12.0.0/mds/lov/consign
48      ./12.0.0/mds/lov
8       ./12.0.0/mds/wshtxn/server/ZHS
16      ./12.0.0/mds/wshtxn/server
24      ./12.0.0/mds/wshtxn
8       ./12.0.0/mds/consign/webui/ZHS
16      ./12.0.0/mds/consign/webui
24      ./12.0.0/mds/consign
8       ./12.0.0/mds/rcv/server/ZHS
16      ./12.0.0/mds/rcv/server
24      ./12.0.0/mds/rcv
8       ./12.0.0/mds/attributesets/ZHS
16      ./12.0.0/mds/attributesets
8       ./12.0.0/mds/txnui/webui/ZHS
16      ./12.0.0/mds/txnui/webui
8       ./12.0.0/mds/txnui/lotDetails/webui/ZHS
16      ./12.0.0/mds/txnui/lotDetails/webui
24      ./12.0.0/mds/txnui/lotDetails
8       ./12.0.0/mds/txnui/serialDetails/webui/ZHS
16      ./12.0.0/mds/txnui/serialDetails/webui
24      ./12.0.0/mds/txnui/serialDetails
72      ./12.0.0/mds/txnui
216     ./12.0.0/mds
8       ./12.0.0/bin
8       ./12.0.0/mesg
8       ./12.0.0/admin/driver
8       ./12.0.0/admin/sql
24      ./12.0.0/admin
8       ./12.0.0/sql
640     ./12.0.0
648     .

3. 增加客制应用到自动配置文件

[root@ebs12vis ~]# su - applmgr
[applmgr@ebs12vis ~]$ cd $APPL_TOP
[applmgr@ebs12vis appl]$ find . -name "*.env"
./ad/12.0.0/admin/template/APPSORA_ux.env
./ad/12.0.0/admin/template/adiasnt.env
./ad/12.0.0/admin/template/ad80nt.env
./ad/12.0.0/admin/template/install/template/db/ad8idbux.env
./ad/12.0.0/admin/template/install/template/db/ad8idbnt.env
./ad/12.0.0/admin/template/APPLSYS_nt.env
./ad/12.0.0/admin/template/APPLSYS_ux.env
./ad/12.0.0/admin/template/adovars_nt.env
./ad/12.0.0/admin/template/adiasux.env
./ad/12.0.0/admin/template/APPSORA_nt.env
./ad/12.0.0/admin/template/adovars_ux.env
./ad/12.0.0/admin/template/ad80ux.env
./asg/12.0.0/admin/template/asgovars_nt.env
./asg/12.0.0/admin/template/asgovars_ux.env
./fnd/12.0.0/fndenv.env
./fnd/12.0.0/usrxit/devenv.env
./APPSVIS_ebs12vis.env
./VIS_ebs12vis.env
./admin/adovars.env
[applmgr@ebs12vis appl]$ vi VIS_ebs12vis.env

#!/bin/sh
#
# $Header: APPLSYS_ux.env 120.29.12010000.3 2009/01/11 17:35:23 mmanku ship $
#
# ###############################################################
#
# This file is automatically generated by AutoConfig.  It will be read and
# overwritten.  If you were instructed to edit this file, or if you are not
# able to use the settings created by AutoConfig, refer to Metalink Note
# 387859.1 for assistance.
#
# ###############################################################

#

############################
# Set the variables required
############################

AFJSMARG="-server -Xmx384m -XX:NewRatio=2 -XX:+UseSerialGC -Doracle.apps.fnd.common.Pool.leak.mode=stderr:off -verbose:
gc"
export AFJSMARG

AFJCPARG="-client"
export AFJCPARG

APPLRGF="/d01/applmgr/VIS/inst/apps/VIS_ebs12vis/logs/appl/rgf"
export APPLRGF

CNTL_BREAK="ON"
export CNTL_BREAK

ORACLE_TERM="vt220"
export ORACLE_TERM

/CONTEXT_FILE
# Define APPS_JDBC_URL
######################

APPS_JDBC_URL="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOS
T=ebs12vis.oracle.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=VIS)))"
export APPS_JDBC_URL

##########################################
# Define AD_APPS_JDBC_URL for AD Utilities
##########################################

TEMP_APPS_JDBC_URL="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp
)(HOST=ebs12vis.oracle.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=VIS)))"
AD_APPS_JDBC_URL=`echo $TEMP_APPS_JDBC_URL | cut -d "@" -f2`
export AD_APPS_JDBC_URL

####################################################################
# The CONTEXT_FILE variable stores the location of the context file.
####################################################################

CONTEXT_FILE="/d01/applmgr/VIS/inst/apps/VIS_ebs12vis/appl/admin/VIS_ebs12vis.xml"
export CONTEXT_FILE

####################################################################
# The CONTEXT_NAME variable stores the value for the current context
####################################################################

CONTEXT_NAME="VIS_ebs12vis"
export CONTEXT_NAME

########################################################
# The APPLFENV variable is the filename of this file.
# If you rename this file, you should change this value.
########################################################
[applmgr@ebs12vis ~]$ cd $INST_TOP/appl/admin
[applmgr@ebs12vis appl]$ vi VIS_ebs12vis.xml

<AU_TOP oa_var="s_autop" oa_type="PROD_TOP" oa_enabled="FALSE">/d01/applmgr/VIS/apps/apps_st/appl/au/12.0.0</AU_TOP>
<CUX_TOP oa_var="s_cuxtop" oa_type="PROD_TOP" oa_enabled="FALSE">/d01/applmgr/VIS/apps/apps_st/appl/cux/12.0.0</CUX_TOP>
<GWYUID oa_var="s_gwyuid">APPLSYSPUB/PUB</GWYUID>

Application Developer ==> Application ==> Register

System Administrator ==> Security ==> ORACLE ==> Register

System Administrator ==> Security ==> ORACLE ==> DataGroup

Alter Manager ==> System ==> Installations

4. 客制应用CUX下应用APPS_DDL, APPS_ARRAY_DDL

SQL> @$AD_TOP/admin/sql/adaaddls.pls system_pword custom_schema custom_schema_pword
SQL> @$AD_TOP/admin/sql/adaaddlb.pls system_pword custom_schema custom_schema_pword

5. 重启EBS应用层服务