R12-Custom Top Creation

1)

Make the directory structure for your custom application files.

cd $APPL_TOP
mkdir xxtest
mkdir xxtest/12.0.0
mkdir xxtest/12.0.0/admin
mkdir xxtest/12.0.0/admin/sql
mkdir xxtest/12.0.0/admin/odf
mkdir xxtest/12.0.0/sql
mkdir xxtest/12.0.0/bin
mkdir xxtest/12.0.0/reports
mkdir xxtest/12.0.0/reports/US
mkdir xxtest/12.0.0/forms
mkdir xxtest/12.0.0/forms/US
mkdir xxtest/12.0.0/lib
mkdir xxtest/12.0.0/out
mkdir xxtest/12.0.0/log

2)

Add the custom module into the application context file

vi $CONTEXT_FILE
<au_top oa_enabled="FALSE" oa_type="PROD_TOP" oa_var="s_autop">/u01/TEST/apps/apps_st/appl/au/12.0.0</au_top>
<xxtest_top oa_enabled="FALSE" oa_type="PROD_TOP" oa_var="s_xxtesttop">/u01/TEST/apps/apps_st/appl/xxtest/12.0.0</xxtest_top>

3)
Stop the application and run autoconfig

cd $ADMIN_SCRIPTS_HOME
sh adstpall.sh apps/apps
sh adautocfg.sh
sh adstrtal.sh apps/apps

Log out from the session and login and verify whether custom top is viewable

$echo $XXTEST_TOP
/u01/TEST/apps/apps_st/appl/xxtest/12.0.0

4)

Create Tablespace for Custom top

SQL>create tablespace XXTEST
datafile '/u01/TEST/db/apps_st/data/>01.dbf' size 2048M
autoextend on next 256M maxsize 20480M;

5)

Create User for Custom top

create user XXTEST
identified by XXTEST
default tablespace XXTEST
temporary tablespace TEMP
quota unlimited on XXTEST;

User created.

SQL> grant connect,resource to XXTEST;

6)