Custom Top in Oracle Application - Creation & Registering

CUSTOM TOP (Registering Custom Application)
Balaji R S

These are all the steps to register a custom top and custom application with Oracle Apps
Create xxncm as custom top, user, schema, application name....

Steps:
Created the directory structure for your custom application files under $APPL_TOP/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

SQL> create user xxncm identified by xxncm default tablespace xxncm
temporary tablespace temp quota unlimited on xxncm quota unlimited on temp;

SQL> 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