CUSTOM_TOP CREATION in R12: Creation of XVIJ_TOP
Application
Details :
Application Name : XVIJ Application
Base Path : $XVIJ_TOP
Schema Name : TTS
Tablespace Name (Data) :
XXVIJ_TS_TX_DATA
Tablespace Name (Index) :
XXVIJ_TS_TX_IDX
è Login
as database OS user to create TTS schema for XVIJ Application.
è Set
the environment. (if not set in Bash Profile)
è Login
into ‘sqlplus as sysdba’
è
Create
Tablespace for data for TTS Schema as XXVIJ_TS_TX_DATA
create
tablespace XXVIJ_TS_TX_DATA datafile
'/d01/R12DEMO/oracle/db01/db/apps_st/data/xvij_data1.dbf ' size 500M autoextend
on next 100m maxsize 1024m extent management local segment space management
auto;
Note: Can give tablespace size
based on our environment
è
Create
Tablespace for Index for TTS Schema
as XXVIJ_TS_TX_IDX.
è Create
Temporary tablespace for TTS Schema
as XXVIJ_TS_TX_TEMP
è Now Create schema named as TTS with
the below details:
Username:
TTS
Password:
tts
Default
Tablespace: XXVIJ_TS_TX_DATA
Temporary Tablespace : XXVIJ_TS_TX_TEMP
è Login
as OS application user.
è Set
the environment if it has not been set in Bash profile.
è Change
Directort to $APPL_TOP
è Make
the directory structure like below under $APPL_TOP
mkdir xvij
mkdir -p xvij/12.0.0
mkdir -p xvij/12.0.0/ bin
mkdir -p xvij/12.0.0/
out
mkdir -p
xvij/12.0.0/log
mkdir -p
xvij/12.0.0/admin
mkdir -p
xvij/12.0.0/html
mkdir -p
xvij/12.0.0/patch
mkdir -p
xvij/12.0.0/mds
mkdir -p
xvij/12.0.0/reports/US
mkdir -p
xvij/12.0.0/sql/ddl
mkdir -p
xvij/12.0.0/media
mkdir -p
xvij/12.0.0/java
mkdir -p
xvij/12.0.0/forms/US
mkdir -p
xvij/12.0.0/help
mkdir -p
xvij/12.0.0/lib
mkdir -p
xvij/12.0.0/mesg
è Change
the Directory to $INST_TOP/appl/admin
for .xml location and back up the .XML file.
è Edit
the original XML file and add the XVIJ top entry as below along with the
standard product list
<XVIJ_TOP
oa_var="s_xvijtop" oa_type="PROD_TOP"
oa_enabled="FALSE">/d01/R12DEMO/oracle/app01/apps/apps_st/appl/xvij/12.0.0</XVIJ_TOP>
è Change
Directory to $ADMIN_SCRIPTS_HOME and
execute
adautocfg.sh
apps/<apps_pwd>
è After
completed autoconfig successfully start the applications.
è Login
to applications as “sysadmin” user and select system administrator
responsibility.
è Now
register our custom application with below details:
Application Name : XVIJ Application
Short Name : XVIJ
Basepath : XVIJ_TOP
Description : XVIJ Application for custom
requirement
Navigation:
After login system administrator responsibility,
Application->Register
(click on Register and enter above details in the form and save it)
è Register the TTS
Schema in the applications. Navigate to
Security → ORACLE → Register
Add the Oracle Schema Details as below and save
the information
Database User name : TTS
Password : tts
Privilege : Enabled
Install Group : 1
Description : XVIS Application for custom
requirement.
è Now add
the Created application in the Standard Datagroup
Navigate
to Security → ORACLE → DataGroup
Now Query
the Data group as Standard.
Add the application details as below in the data
groups form
Application : XVIJ Application
Oracle ID
: Apps
Description:
XVIJ Application for custom requirement
è Create
the Custom Menu
Navigate
to Application->
Menu ( To → Create Custom Menu )
Create the Custom Menu with the following details as below
(Note : The Menu to be created is to provide the
facility to run and View Requests only )
Enter the following details and save:
Menu Name
: XXVIJ_CUSTOM_MENU
User Menu Name : XXVIJ Custom Menu
Description : XXVIJ Custom Menu For Custom Requirement
Seq = 100
Prompt = View Requests
Function = View All
Concurrent Requests
Description = View Requests
Seq = 110
Prompt = Run Requests
Function = Requests: Submit
Description = Submit Requests
After saving we got window like below:
Ensure that the menu has been compiled or not by
checking the request id has been completed normal.
è Create A Custom Request Group
Navigate to Security
->Responsibility-> Request
Note : Not required to add any reports to the request
group. Based on the requirements the reports can be added to the request group
only.
Create the new
custom request group as “XXVIJ
Request Group” with the
following
details:
Group
: XXVIJ Request Group
Application : XVIJ Application
Description : XXVIJ Request Group for Custom Requirement
---------Requests Tab can be left blank
è Create A Custom Responsibility for XVIJ
Application
Navigate
to Security->
Responsibility->Define
Create new custom responsibility as “XTTS Custom
Responsibility” with the details as below:
Responsibility
Name : XTTS Custom Responsibility
Application
Name : XVIJ Application
Responsibility
Key : XTTS_CUSTOM_RESP
Description : XTTS Custom Responsibility
Available
from : Oracle Applications
Datagroup
Name : Standard
Application : XVIJ Application
Menu : XXVIJ Custom Menu
Request
Group
Name : XXVIJ Request Group
Application
: XVIJ Application
è Create one user and assign this responsibility to
that particular user.
Navigate
to Security->User->Define
