Thursday, March 13, 2008

How to create Custom Top in R12

Hi Readers,

Following are the common steps to create custom Top.
Step 1> Create the directory structure.
$ cd $APPL_TOP
$ mkdir xxxx
$ cd xxxx
$ mkdir 12.0.0
$ cd 12.0.0
$ mkdir admin
$ mkdir bin
$ mkdir froms
$ mkdir patch
$ mkdir reports
$ cd admin
$ mkdir sql
$ cd forms
$ mkdir US (for custom forms)
$ cd patch
$ mkdir 115
$ cd 115
$ mkdir import (for ldt files)
$ cd ..
$ cd reports
$ mkdir US (for your custom reports)

Step2>
Now create a tablespace and schema for custom top (xxxx)
sql>create tablespace xxxx datafile 'xxxx1.dbf' size 1000m;
sql>create user xxxx identified by xxxx default tablespace xxxx1.dbf;

Step 3>
Register and add datagroup of custom user and custom Application with Oracle application using system admin responsibility.
Security-->Oracle-->Register (register xxxx user)
Security-->Oracle-->DataGroup (add custom application under datagroup)
Application-->Register (register custom application)

Step 4>
Now add the custom top in environment file under $APPL_TOP.
set XXXX_TOP=$APPL_TOP/xxxx/12.0.0export XXXX_TOP

Step 5>
Open another session and login again using 'applmgr' and verify $ XXXX_TOP is working or not.

Now your custom top has created. Now functional and technical team will create custom reports(rdf's) and custom forms(fmb,fmx) and place into the custom Top directories respectively. After that they will create functions,menus,resposibilites,make executables etc. Till this point your custom top ,responsibility,forms,functions,executables,functions has done .Now the time to open custom responsibility and check whether everything working right.

Leave your commnets if this article helpful to you.
Regards
--Guru

1 comment:

Anonymous said...

thanx...this is really a good one