INTEGRATING R12 WITH CUSTOM APPLICATION

Lets learn on how to create a custom application with Oracle applications R12.
Pre-requisite :
1) Access to Database as a SYSDBA User or a user that has admin privileges
2) Access to application as SYSADMIN user or System Administrator responsibiity
3) Custom top name

Steps :
a) Create a schema in the database

$sqlplus "/as sysdba"
CREATE USER xxtest IDENTIFIED BY xxtest DEFAULT tablespace TEST;
GRANT CONNECT,resource TO xxtest;
</code lang="sql">
b) CREATE a directory UNDER Appl Top
<code>
$cd $APPL_TOP
$mkdir XXTEST
mkdir XXTEST/12.0.0
mkdir XXTEST/12.0.0/admin
mkdir XXTEST/12.0.0/admin/SQL
mkdir XXTEST/12.0.0/admin/odf
mkdir XXTEST/12.0.0/SQL
mkdir XXTEST/12.0.0/bin
mkdir XXTEST/12.0.0/reports
mkdir XXTEST/12.0.0/reports/US
mkdir XXTEST/12.0.0/forms
mkdir XXTEST/12.0.0/forms/US
mkdir XXTEST/12.0.0/lib
mkdir XXTEST/12.0.0/OUT
mkdir XXTEST/12.0.0/log

c) Add the new top name to the enviroment file and xml file

$cd $APPL_TOP
$vi SID_hostname.env
XXTEST_TOP="/u01/erp/oracle/apps/apps_st/appl/xxtest/12.0.0"
export XXTEST_TOP
$vi SID_hostname.xml
&lt;XXTEST_TOP oa_var="s_xxerptop" oa_type="VIS_TOP"
oa_enabled="FALSE"&gt;/u01/erp/oracle/VIS/apps/apps_st/appl/XXTEST/12.0.0&lt;/XXTEST_TOP&gt;

Source the environment file

. APPS&lt;SID&gt;_hostname.env

d) Login to the application as SYSADMIN user

Register your Oracle Schema.
Navigate to Application--&gt;Register
Application = XXTEST Custom Application
Short Name = XXTEST
Basepath = XXTEST_TOP
Description = XXTEST Custom Application

e) Register Oracle User

Naviate to Security--&gt;Oracle--&gt;Register
Database User Name = XXTEST
Password = XXTEST
Privilege = Enabled
Install Group = 0
Description = XXTEST Custom Application

f) Add Application to a Data Group

Navigate to Security--&gt;Oracle--&gt;DataGroup
Go to any line and the below details
Application : XXTEST Custom Application
ORACLE ID : APPS

g) Create custom request group

Navigate to Security--&gt;responsibility--&gt;Request
Group = XXTEST Request Group
Application = XXTEST Custom
Code = XXTEST
Description = XXTEST Custom Requests
Add a line
Type : Program
Program : Active users
Application : Application Object Library

NOTE : You can add your custom requests or any other requests that you like.
h) Create custom menu

Navigate to Application--&gt;Menu
Menu = XXTEST_CUSTOM
User Menu Name = XXTEST Custom Application
Menu Type =
Description = XXTEST Custom Application Menu
Seq = 100
Prompt = Monitor Users
Submenu =
Function = Monitor Users
Description = Monitor Users

Create a new responsibility and add the application , menu and request group to it and finally attach a responsibility to a USER.
Login as the user and you should see the custom responsibility with your custom application details.

Share →
0 comments
Skip to toolbar