Custom TOP creation and registering.. in Oracle Applications

Please find the steps to create a custom top (XXNCM_TOP) in oracle applications 11i.

Created the directory structure for your custom application files under APPLTOP/xxncm

cd $APPL_TOP

mkdir xxncm

mkdir xxncm/11.5.0

mkdir xxncm/11.5.0/admin

mkdir xxncm/11.5.0/admin/sql

mkdir xxncm/11.5.0/admin/odf

mkdir xxncm/11.5.0/sql

mkdir xxncm/11.5.0/bin

mkdir xxncm/11.5.0/reports

mkdir xxncm/11.5.0/reports/US

mkdir xxncm/11.5.0/forms

mkdir xxncm/11.5.0/forms/US

mkdir xxncm/11.5.0/$APPLLIB

mkdir xxncm/11.5.0/$APPLOUT

mkdir xxncm /11.5.0/$APPLLOG


Added entry XXNCM_TOP=/apps/oracle/

visappl/xxncm in Enviornment file.

export XXNCM_TOP

You can source all the environment files before proceeding.

Create new tablespace for database objects

create tablespace xxncm datafile '/apps/oracle/visdata/xxncm.dbf' size 10M;

Create schema

create user xxncm identified by xxncm default tablespace xxncm

temporary tablespace temp quota unlimited on xxncm quota unlimited on temp;

grant connect, resource to xxncm;

Register your Oracle Schema

Login to Applications with System Administrator responsibility

Navigate to Application–>Register

Application = Custom Application

Short Name = xxncm

Basepath = xxncm_TOP

Description = Custom Application

Register Oracle User

Naviate to Security–>Oracle–>Register

Database User Name = XXNCM

Password = XXNCM

Privilege = Enabled

Install Group = 0

Description = Custom