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