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.
