How to create Custom Top in R12

1) Make the directory structure for your custom application files.

cd $APPL_TOP

mkdir CUSTAPP

mkdir CUSTAPP/12.0.0

mkdir CUSTAPP/12.0.0/admin

mkdir CUSTAPP/12.0.0/admin/sql

mkdir CUSTAPP/12.0.0/admin/odf

mkdir CUSTAPP/12.0.0/sql

mkdir CUSTAPP/12.0.0/bin

mkdir CUSTAPP/12.0.0/reports

mkdir CUSTAPP/12.0.0/reports/US

mkdir CUSTAPP/12.0.0/forms

mkdir CUSTAPP/12.0.0/forms/US

mkdir CUSTAPP/12.0.0/lib

mkdir CUSTAPP/12.0.0/out

mkdir CUSTAPP/12.0.0/log

2) Make the changes in context file in application tier

cd ../oracle/inst/apps/VIS_vision/appl/admin/VIS_vision.xml

In above VIS is SID

add

<CUSTAPP_TOP oa_var="s_custapptop" oa_type="PROD_TOP" oa_enabled="FALSE">/opt/oracle/apps/apps_st/appl/custapp/12.0.0</CUSTAPP_TOP>

3) Run the adautocfg.sh

run /opt/oracle/PROD/inst/apps/PROD_taebsa01/admin/scripts/adautocfg.sh

4) Create the table spaces as under from system user

create tablespace CUSTAPP datafile '/opt/oracle/PROD/db/apps_st/data/custapp01.dbf' size 500M;

create tablespace CUSTAPP datafile '/data/oracle/db/apps_st/data/custapp.dbf' size 500M;

create user CUSTAPP identified by CUSTAPP default tablespace CUSTAPP temporary tablespace temp quota unlimited on CUSTAPP;

grant connect, resource to CUSTAPP;

grant create session to CUSTAPP;

grant DBA to CUSTAPP;

GRANT ALL PRIVILEGES to custapp WITH ADMIN OPTION;

5) Register the Application

Login to Applications with System Administrator responsibility

Navigate to Application-->Register

6)

Navigate to Security-->Oracle-->Register

7)

Navigate to Security-->Oracle-->Data Group

You have to bounce the middle tier services after this.

Reference: http://appsdba.info/docs/oracle_apps/sysadmin/R12/CREATECUSTOMTOPINR12.pdf