Creating a Custom Application in R12

Custom Applications are required if you are creating new forms, reports, etc.This allows you to segregate your custom written files from the standard seeded functionality that Oracle Applications provide. Customization can therefore be preserved when applying patches or upgrades to your environment

Step 1: Make the directory structure for your custom application files:

cd $APPL_TOP
mkdir xx_top
mkdir xx_top/12.0.0
mkdir xx_top/12.0.0/admin
mkdir xx_top/12.0.0/admin/sql
mkdir xx_top/12.0.0/admin/odf
mkdir xx_top/12.0.0/admin/template
mkdir xx_top/12.0.0/admin/driver
mkdir xx_top/12.0.0/html
mkdir xx_top/12.0.0/mds
mkdir xx_top/12.0.0/mesg
mkdir xx_top/12.0.0/patch
mkdir xx_top/12.0.0/help
mkdir xx_top/12.0.0/java
mkdir xx_top/12.0.0/media
mkdir xx_top/12.0.0/sql
mkdir xx_top/12.0.0/bin
mkdir xx_top/12.0.0/reports
mkdir xx_top/12.0.0/reports/US
mkdir xx_top/12.0.0/forms
mkdir xx_top/12.0.0/forms/US
mkdir xx_top/12.0.0/$APPLLIB
mkdir xx_top/12.0.0/$APPLOUT
mkdir xx_top/12.0.0/$APPLLOG

Step 2: Add the custom module into the environment:

Go to $APPL_TOP,Create a custom_name.env and make the following entry in custom_name.env.
appsPROD@ssg appl]$ cat custom_name.env
XX_TOP=/u02/PROD/apps/apps_st/appl/xx_top/12.0.0
export XX_TOP

appsPROD@ssg appl]$
Go to the contextfile location INST_TOP/appl/admin/PROD_erp.xml and add the custom entry where all top paths are located.
<XX_TOP oa_var="s_xxtop" oa_type="PROD_TOP"
oa_enabled="FALSE">
/u02/PROD/apps/apps_st/appl/xx_top/12.0.0</XX_TOP>

Step 3: Create new tablespace for database objects and Schema:

SQL>create tablespace custom datafile
'/u01/PROD/db/apps_st/data/xxcustom.dbf' size 1024M;

SQL>create user custuser identified by custuser
default tablespace custom temporary tablespace temp;

SQL>grant connect, resource to custuser;

Step 4: Register your Oracle Schema:

Login to Applications with System Administrator responsibility
Navigate to Application-->Register
Application = xx_custom
Short Name = xx
Basepath = XX_TOP
Description = xx Custom Application

Step 5: Register Oracle User:

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

Step 6: Add Application to a Data Group:

Navigate to Security-->Oracle-->DataGroup
Data Group = XX_GROUP
Description = XX Custom Data Group
Click on “Copy Applications from” and pick Standard data Group, then add the following entry.
Application = xx_custom
Oracle ID = APPS
Description = XX Custom Application

Step 7: 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 = XX_Request_Group
Application = xx_custom
Code = xx
Description = xx 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 8: 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 = XX_CUSTOM_MENU
User Menu Name = XX Custom Application
Menu Type =Standard
Description = XX 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

Menu = XX_CUSTOM_MENU_SSWA
User Menu Name = xx Custom Application SSWA
Menu Type =
Description = XX Custom Application Menu for SSWA

Step 9: Create new responsibility. One for Core Applications and One for Self Service (SSWA)

Navigate to Security-->Responsibility-->Define
Responsibility Name = XX Custom
Application = xx_custom
Responsibility Key = XXCUSTOM
Description = XX Custom Responsibility
Available From = Oracle Applications
Data Group Name = XX_GROUP
Data Group Application = xxcustom
Menu = xx Custom Application
Request Group Name = xx Request Group

Responsibility Name = XX Custom SSWA
Application = xx_custom
Responsibility Key = XXCUSTOMSSWA
Description = XX Custom Responsibility SSWA
Available From = Oracle Self Service Web Applications
Data Group Name = XXGROUP
Data Group Application = xx_custom
Menu = xx Custom Application SSWA
Request Group Name = XX Request Group

Step 10: Add responsibility to user

Navigate to Security-->User-->Define
Add XX Custom responsibility to users as required

Finally Source the custom_name.env and Run Autoconfig on AppsTier.Now You are  ready to create your database Objects, custom Reports, Forms, Packages, etc.