Oracle Apps R12 Custom Top Creation

login as: root

Access denied

root@172.19.0.26's password:

Last login: Wed Jul 24 11:23:17 2013 from 172.19.0.77

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

[root@server2 ~]# su - applvr12

[applvr12@server2 ~]$ mkdir XXUL

[applvr12@server2 ~]$ cd $APPL_TOP

[applvr12@server2 appl]$ mkdir xxul

[applvr12@server2 appl]$ mkdir xxul/12.0.0

[applvr12@server2 appl]$ mkdir xxul/12.0.0/admin

[applvr12@server2 appl]$ mkdir xxul/12.0.0/admin/sql

[applvr12@server2 appl]$ mkdir xxul/12.0.0/admin/odf

[applvr12@server2 appl]$ mkdir xxul/12.0.0/sql

[applvr12@server2 appl]$ mkdir xxul/12.0.0/bin

[applvr12@server2 appl]$ mkdir xxul/12.0.0/reports

[applvr12@server2 appl]$ mkdir xxul/12.0.0/reports/US

[applvr12@server2 appl]$ mkdir xxul/12.0.0/forms

[applvr12@server2 appl]$ mkdir xxul/12.0.0/forms/US

[applvr12@server2 appl]$ mkdir xxul/12.0.0/lib

[applvr12@server2 appl]$ mkdir xxul/12.0.0/out

[applvr12@server2 appl]$ mkdir xxul/12.0.0/log

2) Add the custom module into the environment

[applvr12@server2 ~]$ cd $APPL_TOP

[applvr12@server2 appl]$ echo "XXUL_TOP=/vr12/d01/oracle/vr12/apps/apps_st/appl/xxul/12.0.0" > customvr12_server2.env

[applvr12@server2 ~]$ echo "export XXUL_TOP" >> customvr12_server2.env

[applvr12@server2 ~]$ vi $CONTEXT_FILE

<AU_TOP oa_var="s_autop" oa_type="PROD_TOP" oa_enabled="FALSE">/vr12/d01/oracle/vr12/apps/apps_st/appl/au/12.0.0</AU_TOP>

Copy the above shown line and change it according to your custom_top. Below is an example

 <XXUL_TOP oa_var="s_xxultop" oa_type="PROD_TOP" oa_enabled="FALSE">/vr12/d01/oracle/vr12/apps/apps_st/appl/xxul/12.0.0</XXUL_TOP>

[applvr12@server2 appl]$ cd $APPL_TOP

[applvr12@server2 appl]$ vi admin/topfile.txt

Enter the following line at the end of the file

xxul    /vr12/d01/oracle/vr12/apps/apps_st/appl

[applvr12@server2 ~]$ echo $XXUL_TOP

/vr12/d01/oracle/vr12/apps/apps_st/appl/xxul/12.0.0

[applvr12@server2 appl]$ exit

Logout

3) Create a Tablespace

[root@server2 ~]# su - oravr12

[oravr12@server2 ~]$ sqlplus '/as sysdba'

SQL> create tablespace XXUL datafile '/vr12/d02/oracle/vr12/db/apps_st/data/XXUL01.dbf' size 1g;

Tablespace created.

SQL> create user XXUL identified by XXUL

2  temporary tablespace temp

3  quota unlimited on XXUL;

User altered.

SQL> grant connect, resource to XXUL;

Grant succeeded.

4) Register your Oracle Schema.

Login to Applications with System Administrator responsibility

Navigate to Application-->Register

Application = XXUL Custom Application

Short Name = XXUL

Basepath = XXUL_TOP

Description = XXUL Custom Application

5) Register Oracle User

Naviate to Security-->Oracle-->Register

Database User Name = XXUL

Password = XXUL

Privilege = Enabled

Install Group = 0

Description = XXUL Custom Application User

6) Add Application to a Data Group

Navigate to Security-->Oracle-->DataGroup

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 = XXUL Request Group

Application = XXUL Custom

Code = XXUL

Description = XXUL Custom Requests

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

now if required.

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 = XXUL_CUSTOM_MENU

User Menu Name = XXUL Custom Application

Menu Type =

Description = XXUL 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

9) Create new responsibility. Navigate to Security-->Responsibility-->Define

Responsibility Name = XXUL Custom

Application = XXUL Custom

Responsibility Key = XXULCUSTOM

Description = XXUL Custom Responsibility

Available From = Oracle Applications

Data Group Name = XXULGroup

Data Group Application = XXUL Custom

Menu = XXUL Custom Application

Request Group Name = XXUL Request Group

10) Add responsibility to user

Navigate to Security-->User-->Define

Add XXUL Custom responsibility to users as required.