STEP 1:
This document gives the clear steps to create the DQA_TOP (CUSTOM_TOP) in R12 Oracle Application. The following need to be created in R12 Oracle Application for DQA_TOP (CUSTOM_TOP).
SCHEMA NAME: DQA
TOP NAME: DQA_TOP
Application: DQA Custom Application
Data Group: DQA Group
Request Group: DQA Request Group
Menu: DQA_CUSTOM_MENU
Responsibility: DQA Custom
STEP 2:
Make the directory structure for your DQA_TOP (CUSTOM_TOP) custom application files.
i) Login as user applmgr in linux,
ii) Write a shell script program with following lines for directory creation,
[applmgr@dqa shell_script]$ vi dqa_top_creation.sh
cd $APPL_TOP
mkdir dqa
mkdir dqa/12.0.0
mkdir dqa/12.0.0/admin
mkdir dqa/12.0.0/admin/sql
mkdir dqa/12.0.0/admin/odf
mkdir dqa/12.0.0/sql
mkdir dqa/12.0.0/bin
mkdir dqa/12.0.0/reports
mkdir dqa/12.0.0/reports/US
mkdir dqa/12.0.0/forms
mkdir dqa/12.0.0/forms/US
mkdir dqa/12.0.0/lib
mkdir dqa/12.0.0/out
mkdir dqa/12.0.0/log
Run the Shell script program as following,
[applmgr@dqa shell_script]$ dqa_top_creation.sh
Now the directory structure was created by the above shell script program.
Screenshot:
STEP 3:
Put the Entry for DQA_TOP (CUSTOM_TOP) in $CONTEXT_FILE as following,
[applmgr@dqa appl]$ echo $CONTEXT_FILE
/u01/oracle/VIS/inst/apps/VIS_dqa/appl/admin/VIS_dqa.xml
[applmgr@dqa appl]$ vi $CONTEXT_FILE
Put the Entry as following and Save the $CONTEXT_FILE,
<AU_TOP oa_var=”s_autop” oa_type=”PROD_TOP” oa_enabled=”FALSE”>/u01/oracle/VIS/apps/apps_st/appl/au/12.0.0</AU_TOP>
<DQA_TOP oa_var=”s_dqatop” oa_type=”PROD_TOP” oa_enabled=”FALSE”>/u01/oracle/VIS/apps/apps_st/appl/dqa/12.0.0</DQA_TOP>
Screenshot:
STEP4:
Stop all middle tier services in R12 Oracle Application.
[applmgr@dqa appl]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@dqa scripts]$ adstpall.sh apps/apps
Database and Listener should be in up status, then Run the Autoconfig as following,
[applmgr@dqa appl]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@dqa scripts]$ adautocfg.sh apps/apps
Screenshot:
Once this autoconfig completed successfully we need to check whether environment variable set correctly for $DQA_TOP. Open the new terminal and check the $DQA_TOP (CUSTOM_TOP) as following,
[oracle@dqa ~]$ su – applmgr
Password:
[applmgr@dqa ~]$ echo $DQA_TOP
/u01/oracle/VIS/apps/apps_st/appl/dqa/12.0.0
After this, Start all middle tier services by executing following,
[applmgr@dqa appl]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@dqa scripts]$ adstrtal.sh apps/apps
STEP5:
Create Tablespace for DQA_TOP through sqlplus as sys user by following,
SQL> create tablespace DQA datafile ‘/u01/oracle/VIS/db/apps_st/data/DQA01.dbf’ size 500M;
Tablespace created.
STEP6:
Create new Database user for DQA_TOP through sqlplus as sys user by following,
SQL> create user DQA identified by dqa default tablespace DQA temporary tablespace temp1 quota unlimited on DQA;
User created.
Grant the following privileges to DQA user,
SQL> grant connect, resource to DQA;
Grant succeeded.
Connect the DQA user and check the User as following,
SQL> connect dqa/dqa
Connected.
STEP7:
Oracle database user need to be registered in Oracle Application, do the following for Oracle database user Registration,
Naviate to Security–>Oracle–>Register
Database User Name = DQA
Password = DQA
Privilege = Enabled
Install Group = 0
Description = DQA Custom Application User
Screenshot:
STEP8:
Oracle Schema need to be registered in Oracle Application, do the following for Schema Registration,
Login to Applications with System Administrator responsibility
Navigate to Application–>Register
Application = DQA Custom Application
Short Name = DQA
Basepath = DQA_TOP
Description = DQA Custom Application
Screenshot:
STEP9:
Add Application to a Data Group as following,
Navigate to Security–>Oracle–>DataGroup
Data Group = DQA Group
Description = DQA Custom Data Group
Click on “Copy Applications from” and pick Standard data Group, then add the following entry.
Application = DQA Custom Application
Oracle ID = APPS
Description = DQA Custom Application
Screenshot:
STEP10:
Create custom request group.
This will act as a placeholder for any custom reports we wish to make available for the Custom Responsibility.
Navigate to Security–>responsbility–>Request
Group = DQA Request Group
Application = DQA Custom
Code = DQA
Description = DQA Custom Requests
We will not define any requests to add to the group at this stage, but you can add some now if required.
Screenshot:
STEP11:
Create custom menu.
This will act as a placeholder for any menu items we wish to make available for the Custom Responsibility. We will create two menus, one for Core Applications and one for Self Service.
Navigate to Application–>Menu
Menu = DQA_CUSTOM_MENU
User Menu Name = DQA Custom Application
Menu Type =
Description = DQA Custom Application Menu
Seq = 10
Prompt = Submit Concurrent
Submenu = Concurrent
Function = Description = Submit Concurrent
Seq = 20
Prompt = Concurrent
Submenu = Concurrent Menu – Application Developer GUI
Function =
Description = Concurrent
Screenshot:
**********************************************************
Menu = DQA_CUSTOM_MENU_SSWA
User Menu Name = DQA Custom Application SSWA
Menu Type =
Description = DQA Custom Application Menu for SSWA
Seq = 10
Prompt = Oracle Application Manager
Submenu = OAM Workflow Manager
Function =
Description =
Screenshot:
STEP12:
Create new responsibility. One for Core Applications and One for Self Service (SSWA)
Navigate to Security–>Responsibility–>Define
Responsibility Name = DQA Custom
Application = DQA Custom
Responsibility Key = DQACUSTOM
Description = DQA Custom Responsibility
Available From = Oracle Applications
Data Group Name = DQA Group
Data Group Application = DQA Custom
Menu = DQA Custom Application
Request Group Name = DQA Request Group
Screenshot:
**************************************************************************
Responsibility Name = DQA Custom SSWA
Application = DQA Custom
Responsibility Key = DQACUSTOMSSWA
Description = DQA Custom Responsibility SSWA
Available From = Oracle Self Service Web Applications
Data Group Name = DQA Group
Data Group Application = DQA Custom
Menu = DQA Custom Application SSWA
Request Group Name = DQA Request Group
Screenshot:
STEP13:
Now you can add responsibility to user
Navigate to Security–>User–>Define
Screenshot:
Add DQA Custom responsibility to users as required.
STEP14:
Other considerations:
You are now ready to create your database Objects, custom Reports, Forms, Packages, etc.
Create the source code files in the DQA_TOP directory appropriate for the type of object. For example forms would be located in $DQA_TOP/forms/US or package source code in $DQA_TOP/admin/sql
For example,
Database Objects, such as tables, indexes and sequences should be created in the DQA schema, and then you need to
a) Grant all privilege from each custom data object to the APPS schema.
For example:
login as DQA user
grant all privileges on myTable to apps;
b) Create a synonym in APPS for each custom data object
For example:
login as APPS user
create synonym myTable for DQA.myTable;
***********************************************************************************************************************
[download id=”13″]
Author : Lingesan.J (dataQapps Technologies)