CUSTOM_TOP creation in Oracle e-Business Suite

CUSTOM_TOP Creation :-

1) Create Read only user (appldev) on os level

2) appldev user id should be member of appldev group
   applmgr need to be secondary member of appldev group
  
ex:
id applmgr
uid=504(applmgr) gid=501(dba) groups=501(dba),503(appldev)


3) Create following structure with Developer userid (appldev) at home location(/home/appldev) at   OS level:

Step 1> Create the directory structure.
mkdir -p XXCUS
mkdir -p XXCUS/12.0.0/admin/sql
mkdir -p XXCUS/12.0.0/admin/odf
mkdir -p XXCUS/12.0.0/sql
mkdir -p XXCUS/12.0.0/bin
mkdir -p XXCUS/12.0.0/reports/US
mkdir -p XXCUS/12.0.0/forms/US
mkdir -p XXCUS/12.0.0/lib
mkdir -p XXCUS/12.0.0/out
mkdir -p XXCUS/12.0.0/log
mkdir -p XXCUS/12.0.0/java/classes


4) Create a soft link using the following command(Login as applmgr user and go to $APPL_TOP)

 ln -s /home/appldev/XXCUS XXCUS



5) Login to oracle user and connect to database,Now create a tablespace and schema for custom top (XXCUS).

create tablespace XXCUS datafile '/u01/oracle/VIS/db/apps_st/data/XXCUS01.dbf' size 1000m;
create user XXCUS identified by XXCUS default tablespace XXCUS;
grant connect, resource to XXCUS;

6) Register and add datagroup of custom user and custom Application with Oracle application using system admin responsibility.

Security-->Oracle-->Register (register XXCUS user)
Naviate to Security-->Oracle-->Register
Database User Name = XXCUS
Password = XXCUS
Privilege = Enabled
Install Group = 0
Description = XXCUS Custom Application User

Application-->Register (register custom application)
Navigate to Application-->Register
Application = XXCUS Custom Application
Short Name = XXCUS
Basepath = XXCUS_TOP
Description = XXCUS Custom Application

Security-->Oracle-->DataGroup (add custom application under datagroup)
Navigate to Security-->Oracle-->DataGroup
search for "standard" data group.
add new entry and search for the application name ->XXCUS Custom Application
Oracle ID->APPS


7) ADD the custom top entry in enviromnet file of applmgr

XXCUS_TOP="/u01/oracle/VIS/apps/apps_st/appl/XXCUS/12.0.0"
  export XXCUS_TOP

8) Login as APPLMGR os user and run following

chmod 755 $ORACLE_HOME/bin/sqlplus
chmod 755 $ORACLE_HOME/sqlplus
chmod 755 $ORACLE_HOME/sqlplus/mesg
chmod 755 $ORACLE_HOME/sqlplus/mesg/sp1us.msb
chmod 755 $ORACLE_HOME/nls
chmod 755 $ORACLE_HOME/nls/data
chmod 755 $ORACLE_HOME/nls/data/lx1boot.nlb
chmod 755 $ORACLE_HOME/oracore
chmod 755 $ORACLE_HOME/oracore/zoneinfo
chmod 755 $ORACLE_HOME/oracore/zoneinfo/timezlrg.dat
chmod -R 777 $ORACLE_HOME/forms/admin/terminal

9) Login as appldev user and edit bash_profile with the environment details of applmgr