How to Create Custom TOP in E-Business Suite

This is recommended to create your own Custom Top for all your custom needs hence it will make DBAs life easy while up-gradation of EBS.

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

 cd $APPL_TOP i.e /u01/appldev/apps/apps_st/appl

 mkdir xxaks
 mkdir xxaks/12.0.0
 mkdir xxaks/12.0.0/admin
 mkdir xxaks/12.0.0/admin/sql
 mkdir xxaks/12.0.0/admin/odf
 mkdir xxaks/12.0.0/sql
 mkdir xxaks/12.0.0/bin
 mkdir xxaks/12.0.0/reports
 mkdir xxaks/12.0.0/reports/US
 mkdir xxaks/12.0.0/forms
 mkdir xxaks/12.0.0/forms/US
 mkdir xxaks/12.0.0/$APPLLIB
 mkdir xxaks/12.0.0/$APPLOUT
 mkdir xxaks/12.0.0/$APPLLOG

2)  Add the custom module into the environment:

Add the entry in “Topfile.txt” as a standard product top entry (follow the existing model in the file)  

3) Customized environment variables needed to add in Source files.

Cd $APPL_TOP

vi customdev_dev.env or vi customprod_prod.env
XXAKS_TOP="/u01/appldev/apps/apps_st/appl/xxaks/12.0.0"
export XXAKS_TOP

SAVE THE FILE.

4) RUN AUTOCONFIG. ($INST_TOP - down apps services firsts then run on db tier then on apps tier)

Double check,

If you run $echo $XXAKS_TOP it should reflect the path if paths are set in profiles.

5)  Create new tablespace for database objects as sys or system user.

 Create tablespace xxaks datafile '/u01/oradev/db/apps_st/data/xxaks.dbf' size 500M   default storage(initial 10k next 10k)

6) Create schema

  Sql>create user xxaks identified by xxaks
  default tablespace xxaks
  temporary tablespace temp
  quota unlimited on xxaks
  quota unlimited on temp;

 sql>grant connect, resource to xxaks;

7)  Register your Oracle Schema.

 Login to Applications with System Administrator responsibility
 Navigate to Application-->Register
 Application             = xxaks Custom
 Short Name            = xxaks
 BasePath                = XXAKS_TOP
 Description             = xxaks Custom Application

8)  Register Oracle User

 Navigate to Security-->Oracle-->Register
 Database User Name  = xxaks
 Password                   = xxaks
 Privilege                     = Enabled
 Install Group              = 0
 Description                 = xxaks Custom Application User

9)  Add Application to a Data Group

 Navigate to Security-->Oracle-->DataGroup
 Query the” Data Group  = standard”

 Insert the following lines.

 Application = xxaks Custom
 Oracle ID   = APPS
 Description = xxaks Custom Application