EBS客户化标准及多组织应用.docx

1、AIMMD070 PROGRAMMER TRAININGEBS客户化标准及多组织应用 Author: 梁贤院Creation Date: October 16, 2011Last Updated: 二月 14, 2014Document Ref: Version: V1.0Approvals:Copy Number _EBS客户化标准及多组织应用 File Ref: Ae493eaa99b053f1957166c2d30137ea.pdf (V1.0 )Company Confidential - For internal use only二月 14, 2014Document Control

2、 Document ControlChange Record10Date Author Version Change Reference16-Oct-11 SandyLiang 1.0 No Previous DocumentReviewersName PositionDistributionCopy No. Name Location1234Note To Holders:If you receive an electronic copy of this document and print it out, please write your name on the equivalent o

3、f the cover page, for document control purposes.If you receive a hard copy of this document, please write your name on the front cover, for document control purposes.EBS客户化标准及多组织应用 File Ref: Ae493eaa99b053f1957166c2d30137ea.pdf (V1.0 )Company Confidential - For internal use only二月 14, 2014Document C

4、ontrol ContentsDocument Control .ii环境 .ivEBS 环境 .iv本地环境 .iv新建客户化应用 .v客户化应用 EBS配置 .v客户化 UNIX配置 .vii客户化应用数据库配置 .viii客户化多组织应用 .10MO配置文件.10客户化应用多组织注册.10客户化表多组织注册.11OAF中多组织应用.12请求中多组织应用.14表单中多组织应用.15多组织应用常用 SQL.16VPD技术的继续探讨.17Open and Closed Issues for this Deliverable.19Open Issues.19Closed Issues.19EBS

5、客户化标准及多组织应用 File Ref: Ae493eaa99b053f1957166c2d30137ea.pdf (V1.0 )Company Confidential - For internal use only二月 14, 2014环境 环境EBS 环境R12本地环境EBS客户化标准及多组织应用 File Ref: Ae493eaa99b053f1957166c2d30137ea.pdf (V1.0 )Company Confidential - For internal use only二月 14, 2014新建客户化应用 新建客户化应用客户化应用 EBS配置系统管理员 应用产品

6、注册Vanke Custom XVK XVK_TOP系统管理员- 安全性 Oracle 注册EBS客户化标准及多组织应用 File Ref: Ae493eaa99b053f1957166c2d30137ea.pdf (V1.0 )Company Confidential - For internal use only二月 14, 2014新建客户化应用 XVK XVK 启用 1 Vanke Custom Application User系统管理员- 安全性 Oracle DataGroupEBS客户化标准及多组织应用 File Ref: Ae493eaa99b053f1957166c2d301

7、37ea.pdf (V1.0 )Company Confidential - For internal use only二月 14, 2014新建客户化应用 标准 Vanke Custom APPSMultiple Reporting CurrenciesVanke Custom XVK客户化 UNIX配置cd $APPL_TOPmkdir xvkcd xvkmkdir 12.0.0cd 12.0.0mkdir adminmkdir binmkdir formsmkdir graphsEBS客户化标准及多组织应用 File Ref: Ae493eaa99b053f1957166c2d30137

8、ea.pdf (V1.0 )Company Confidential - For internal use only二月 14, 2014新建客户化应用 mkdir helpmkdir htmlmkdir installmkdir importmkdir jarmkdir javamkdir libmkdir logmkdir mdsmkdir mediamkdir mesgmkdir outmkdir patchmkdir reportsmkdir resourcemkdir sqlcd formsmkdir USmkdir ZHScd .cd reportsmkdir USmkdir ZH

9、S在 ENV 文件中 增加环境变量 XVK_TOP=“/app/applprod/prodappl/xvk/12.0.0“export XVK_TOP增加 CONTEXT_FILE 配置echo $CONTEXT_FILE1.打开$CONTEXT_FILE（即/ebs12/VIS/inst/apps/VIS_erp/appl/admin/VIS_erp.xml）找到GL_TOP子句，在它后面加上/ebs12/VIS/apps/apps_st/appl/xvk/12.0.02.到$ADMIN_SCRIPTS_HOME（即apache脚本运行目录：/ebs12/VIS/inst/apps/VIS_

10、erp/admin/scripts），重新配置adautocfg.sh客户化应用数据库配置建立数据库文件(数据文件大小根据业务增加)CREATE TABLESPACE XVK_DATA DATAFILE /u01/orauat/uatdata/XVK_DATA.dbf SIZE 4096M;CREATE TABLESPACE XVK_IDX DATAFILE /u01/orauat/uatdata/XVK_IDX.dbf SIZE 1024M;创建数据库用户CREATE USER XVKIDENTIFIED BY “XVK“DEFAULT TABLESPACE XVK_DATATEMPORAR

11、Y TABLESPACE TEMPPROFILE DEFAULTQUOTA UNLIMITED ON XVK_DATAQUOTA UNLIMITED ON XVK_IDXQUOTA UNLIMITED ON APPS_TS_ARCHIVEQUOTA UNLIMITED ON APPS_TS_INTERFACEQUOTA UNLIMITED ON APPS_TS_MEDIAQUOTA UNLIMITED ON APPS_TS_NOLOGGINGQUOTA UNLIMITED ON APPS_TS_QUEUESQUOTA UNLIMITED ON APPS_TS_SEEDQUOTA UNLIMIT

12、ED ON APPS_TS_SUMMARYQUOTA UNLIMITED ON APPS_TS_TX_DATAQUOTA UNLIMITED ON APPS_TS_TX_IDX;GRANT EXECUTE ON AD_DDL TO XVK;GRANT ALTER ANY OUTLINE TO XVK;GRANT ALTER SESSION TO XVK;EBS客户化标准及多组织应用 File Ref: Ae493eaa99b053f1957166c2d30137ea.pdf (V1.0 )Company Confidential - For internal use only二月 14, 20

13、14新建客户化应用 GRANT ANALYZE ANY TO XVK;GRANT CREATE ANY OUTLINE TO XVK;GRANT CREATE CLUSTER TO XVK;GRANT CREATE DATABASE LINK TO XVK;GRANT CREATE SEQUENCE TO XVK;GRANT CREATE SESSION TO XVK;GRANT CREATE SNAPSHOT TO XVK;GRANT CREATE TABLE TO XVK;GRANT CREATE ANY INDEX TO XVK;GRANT CREATE TRIGGER TO XVK;GRANT CREATE TYPE TO XVK;GRANT DROP ANY OUTLINE TO XVK;GRANT QUERY REWRITE TO XVK;