Create Custom Top/Application in Oracle R12

Agenda:

Create custom top/application in E-Business Suite R12.

Steps to be followed:

SCHEMA NAME : XXNEW
TOP NAME : XXNEW_TOP
Application : XXNEW Custom Application
Data Group : Standard
Request Group : XXNEW Request Group
Menu : XXNEW_CUSTOM_MENU
Responsibility : XXNEW Custom

Step-1

Create a Tablespace XXNEW in the Database for custom schema.

create tablespace XXNEW datafile '/u01/oradata/XXNEW01.dbf'
size 50M;

Step-2

Create Schema XXNEW in the database.

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

Step-3

Grants Connect and Resource to schema XXNEW.

grant connect, resource to XXNEW;

Step-4

Make the directory structure for your custom application files.

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

Step-5

Create custom environment file in APPL_TOP location.

Step-6

Edit custom environment file and insert new custom top information in it.

export XXNEW_TOP=/u01/appluat/UAT/apps/apps_st/appl/XXNEW/12.0.0

Step-7

Edit the default environment file (default.env) located at cd $ORACLE_CONFIG_HOME/forms/server

Open default.env and add the new custom top information at the last line.

XXNEW_TOP=/u01/appluat/UAT/apps/apps_st/appl/XXNEW/12.0.0

Step-8

Register your Oracle Schema.
Login to Applications with System Administrator responsibility
Navigate to Application–>Register
Application = XXNEW Custom Application
Short Name = XXNEW
Basepath = XXNEW_TOP
Description = XXNEW Custom Application

Step-9

Register Oracle User
Naviate to Security–>Oracle–>Register
Database User Name = XXNEW
Password = XXNEW
Privilege = Enabled
Install Group = 0
Description = XXNEW Custom Application User

Step-10

Add Application to a Data Group
Navigate to Security–>Oracle–>DataGroup
Application -> XXNEW Application
In Oracle ID -> APPS

Step-11

Create custom request group
This will act as a placeholder for any custom reports we wish to make available for the Custom Responsibility (which is defined at a later stage)

Navigate to Security–>responsibility–>Request
Group = XXNEW Request Group
Application = XXNEW Custom
Code = XXNEW
Description = XXNEW Custom Requests

We will not define any requests to add to the group at this stage, but you can add some now if required.

Step-12

Create custom menu
This will act as a placeholder for any menu items we wish to make available for the
Custom Responsibility (which is defined at a later stage). We will create two menus, one for Core Applications and one for Self Service.

Navigate to Application–>Menu
Menu = XXNEW_CUSTOM_MENU
User Menu Name = XXNEW Custom Application
Menu Type =
Description = XXNEW Custom Application Menu
Seq = 100
Prompt = View Requests
Submenu =
Function = View All Concurrent Requests
Description = View Requests
Seq = 110
Prompt = Run Requests
Submenu =
Function = Requests: Submit
Description = Submit Requests

Step-13

As we have edited default.env we need to bounce the opmn.

cd $ADMIN_SCRIPTS_HOME
sh adopmnctl.sh stopall

Rest the Application ENvironment and start OPMN
sh adopmnctl.sh startall