Creating a Custom Application in Oracle Applications R12

E-Business Suite 11i & R12, Sysadmin, Unix

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.Customizations can therefore be preserved when applying patches or upgrades to your environment

Step1: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

Step2: Add the custom module into the environment:
 

Go to $APPL_TOP,Create a customPROD_erp.env and make the following entry in customPROD_erp.env.

applprod@erp appl]$ cat customPROD_erp.env
XX_TOP=/d02/PROD/apps/apps_st/appl/xx_top/12.0.0
export XX_TOP
applprod@erp 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">
/d02/PROD/apps/apps_st/appl/xx_top/12.0.0</XX_TOP>

Step3:Create new tablespace for database objects and Schema:

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

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

SQL>grant connect, resource to custusr;

Step4: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

Step5:Register Oracle User:

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

Step6: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

Step7: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

Step8: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

Step9: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

Step10:Add responsibility to user

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

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