Oracle Apps DBA, Qatari Diar real Estate investment Company.: Creating a Custom Application in Applications 11i

Creating a Custom Application in Applications 11i

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.

1) Make the directory structure for your custom application files.

cd $APPL_TOP

mkdir mz

mkdir mz/11.5.0

mkdir mz/11.5.0/admin

mkdir mz/11.5.0/admin/sql

mkdir mz/11.5.0/admin/odf

mkdir mz/11.5.0/sql

mkdir mz/11.5.0/bin

mkdir mz/11.5.0/reports

mkdir mz/11.5.0/reports/US

mkdir mz/11.5.0/forms

mkdir mz/11.5.0/forms/US

mkdir mz/11.5.0/$APPLLIB

mkdir mz/11.5.0/$APPLOUT

mkdir mz/11.5.0/$APPLLOG

2) Add the custom module into the environment

Apply ADX.E.1 and add the entry to topfile.txt as a standard product top entry (follow the existing model in the file)

Customised environment variables can be added to AutoConfig by using the filename specificed by s_custom_file, which is then called from the APPSORA.env file.

If using Forms Listener Servlet, you may also need to add $CUSTOM_TOP to formsservlet.ini in $APACHE_TOP/Jserv/etc

3) Create new tablespace for database objects

create tablespace MZ datafile '/emea/oracle/visuk09/visuk09data/mz.dbf' size 10M default storage(initial 10k next 10k)

4) Create schema

create user mz identified by mz default tablespace mz

temporary tablespace temp quota unlimited on mz quota unlimited on temp;

grant connect, resource to mz;

5) Register your Oracle Schema.

Navigate to Application-->Register

Application = MZ Custom

Short Name = MZ

Basepath = MZ_TOP

Description = MZ Custom Application

6) Register Oracle User

Naviate to Security-->Oracle-->Register

Database User Name = MZ

Password = MZ

Privilege = Enabled

Install Group = 0

Description = MZ Custom Application User

7) Add Application to a Data Group

Navigate to Security-->Oracle-->DataGroup

Data Group = MZGroup

Description = MZ Custom Data Group

Click on "Copy Applications from" and pick Standard data Group, then add the following entry.

Application = MZ Custom

Oracle ID = APPS

Description = MZ Custom Application

8) 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-->responsbility-->Request

Group = MZ Request Group

Application = MZ Custom

Code = MZ

Description = MZ Custom Requests

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

9) 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 = MZ_CUSTOM_MENU

User Menu Name = MZ Custom Application

Menu Type =

Description = MZ 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 = MZ_CUSTOM_MENU_SSWA

User Menu Name = MZ Custom Application SSWA

Menu Type =

Description = MZ Custom Application Menu for SSWA

10) Create new responsibility.

One for Core Applications and One for Self Service (SSWA)

Navigate to Security-->Responsibility-->Define

Responsibility Name = MZ Custom

Application = MZ Custom

Responsibility Key = MZCUSTOM

Description = MZ Custom Responsibility

Available From = Oracle Applications

Data Group Name = mzGroup Data Group

Application = MZ Custom

Menu = MZ Custom Application

Request Group Name = MZ Request Group
Responsibility Name = MZ Custom SSWA

Application = MZ Custom

Responsibility Key = MZCUSTOMSSWA

Description = MZ Custom Responsibility SSWA

Available From = Oracle Self Service Web Applications

Data Group Name = mzGroup

Data Group Application = MZ Custom

Menu = MZ Custom Application SSWA

Request Group Name = MZ Request Group

11) Add responsibility to user

Navigate to Security-->User-->DefineAdd MZ Custom responsibility to users as required.

12) Other considerationsYou are now ready to create your database Objects, custom Reports, Forms, Packages, etc

Create the source code files in the MZ_TOP directory appropriate for the type of object. For example formswould be located in $MZ_TOP/forms/US or package source code in $MZ_TOP/admin/sql for example.

Database Objects, such as tables, indexes and sequences should be created in the MZ schema, then you need to

a) Grant all privilege from each custom data object to the APPS schema.

For example : logged in as MZ user

SQL> grant all privileges on myTable to apps;

b) Create a synonym in APPS for each custom data object For example : logged in as APPS user

create synonym myTable for mz.myTable;

Other database objects, such as views and packages should be created directly in the APPS schema.