Friday, 4 July 2014

Register Custom Application In Oracle Applications

As a standard practice when ever you need to write custom code/forms/reports in Oracle Applications you must put then under custom application TOP. This is to avoid impact of patching on custom objects. If we put custom object under stand TOP it might create issue and after patching it may start malfunctioning. If we have all custom code at one place it easy to maintain as we know exactly how many custom objects we have and where they are.
Before staring you need to first decide what should be your application name and short name. Here we go ....
SCHEMA NAME    : C_APPS
TOP NAME       : C_APPS_TOP
Application    : Custom Application
Data Group     : Standard
Request Group  : Custom Request Group
#1 – Create directory under application top
  • Login to Application Server and Source the environment variable. 
    login as: oracle
oracle@192.168.56.200's password:
Last login: Sun Feb  2 12:53:38 2014 from 192.168.56.1
[oracle@ebsapp ~]$ 
[oracle@ebsapp ~]$ pwd
/home/oracle
[oracle@ebsapp ~]$ . /u01/E-BIZ/apps/apps_st/appl/APPSVIS_ebsapp.env
[oracle@ebsapp ~]$ cd $APPL_TOP
[oracle@ebsapp appl]$ pwd
/u01/E-BIZ/apps/apps_st/appl
[oracle@ebsapp appl]$
  • Create following directories under APPL_TOP
    mkdir c_apps 
mkdir c_apps/12.0.0 
mkdir c_apps/12.0.0/admin 
mkdir c_apps/12.0.0/admin/sql 
mkdir c_apps/12.0.0/admin/odf 
mkdir c_apps/12.0.0/sql 
mkdir c_apps/12.0.0/bin 
mkdir c_apps/12.0.0/reports 
mkdir c_apps/12.0.0/reports/US 
mkdir c_apps/12.0.0/forms 
mkdir c_apps/12.0.0/forms/US 
mkdir c_apps/12.0.0/lib 
mkdir c_apps/12.0.0/out 
mkdir c_apps/12.0.0/log
#2 – Create an entry to the application tier Context File
  • Modify Context File as Follows
    Sample Entry
<AD_TOP oa_var="s_adtop" oa_type="PROD_TOP" oa_enabled="TRUE">/u01/E-BIZ/apps/apps_st/appl/ad/12.0.0</AD_TOP>
New Entry
<C_APPS_TOP oa_var="s_asftop" oa_type="PROD_TOP" oa_enabled="FALSE">/u01/E-BIZ/apps/apps_st/appl/c_apps/12.0.0</C_APPS_TOP>
#3 – Stop Application Services
  • Execute the script - adstpall.sh
    [oracle@ebsapp appl]$ cd $ADMIN_SCRIPTS_HOME
[oracle@ebsapp scripts]$ sh adstpall.sh apps/apps

You are running adstpall.sh version 120.10.12010000.4

The logfile for this session is located at /u01/E-BIZ/inst/apps/VIS_ebsapp/logs/appl/admin/log/adstpall.log
Executing service control script:
/u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/jtffmctl.sh stop
****************************************************
Executing service control script:
/u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adcmctl.sh stop
****************************************************
You are running adcmctl.sh version 120.17.12010000.5

Shutting down concurrent managers for VIS ...
ORACLE Password:
Submitted request 5821348 for CONCURRENT FND SHUTDOWN
adcmctl.sh: exiting with status 0
****************************************************
Executing service control script:
/u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adoafmctl.sh stop

*********
*********
*********
All enabled services on this node are stopped.

adstpall.sh:Exiting with status 0
adstpall.sh: check the logfile /u01/E-BIZ/inst/apps/VIS_ebsapp/logs/appl/admin/log/adstpall.log for more information ...

[oracle@ebsapp scripts]$
#4 – Run Autoconfig
  • Execute the script adautocfg.sh
    [oracle@ebsapp scripts]$ sh adautocfg.sh
Enter the APPS user password:

The log file for this session is located at: /u01/E-BIZ/inst/apps/VIS_ebsapp/admin/log/02021607/adconfig.log

AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
 Using CONFIG_HOME location : /u01/E-BIZ/inst/apps/VIS_ebsapp
 Classpath                  : /u01/E-BIZ/apps/apps_st/comn/java/lib/appsborg2.zip:/u01/E-BIZ/apps/apps_st/comn/java/classes
 Using Context file         : /u01/E-BIZ/inst/apps/VIS_ebsapp/appl/admin/VIS_ebsapp.xml

Context Value Management will now update the Context file
        Updating Context file...COMPLETED
        Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
        Configuring AD_TOP........COMPLETED
        Configuring FND_TOP.......COMPLETED
        Configuring ICX_TOP.......COMPLETED
        Configuring MSC_TOP.......COMPLETED
        Configuring IEO_TOP.......COMPLETED
        Configuring BIS_TOP.......COMPLETED
        Configuring AMS_TOP.......COMPLETED
        Configuring CCT_TOP.......COMPLETED
        Configuring WSH_TOP.......COMPLETED
        Configuring CLN_TOP.......COMPLETED
        Configuring OKE_TOP.......COMPLETED
        Configuring OKL_TOP.......COMPLETED
        Configuring OKS_TOP.......COMPLETED
        Configuring CSF_TOP.......COMPLETED
        Configuring IGS_TOP.......COMPLETED
        Configuring IBY_TOP.......COMPLETED
        Configuring JTF_TOP.......COMPLETED
        Configuring MWA_TOP.......COMPLETED
        Configuring CN_TOP........COMPLETED
        Configuring CSI_TOP.......COMPLETED
        Configuring WIP_TOP.......COMPLETED
        Configuring CSE_TOP.......COMPLETED
        Configuring EAM_TOP.......COMPLETED
        Configuring FTE_TOP.......COMPLETED
        Configuring ONT_TOP.......COMPLETED
        Configuring AR_TOP........COMPLETED
        Configuring AHL_TOP.......COMPLETED
        Configuring OZF_TOP.......COMPLETED
        Configuring IES_TOP.......COMPLETED
        Configuring CSD_TOP.......COMPLETED
        Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.
[oracle@ebsapp scripts]$
#5 – Start Application Services
  • Execute the script adstrtal.sh
    [oracle@ebsapp scripts]$ sh adstrtal.sh apps/apps

You are running adstrtal.sh version 120.15.12010000.3

The logfile for this session is located at /u01/E-BIZ/inst/apps/VIS_ebsapp/logs/appl/admin/log/adstrtal.log
Executing service control script:
/u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adopmnctl.sh start

****************************************************
/u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adalnctl.sh start
****************************************************
/u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adapcctl.sh start
****************************************************
/u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adoacorectl.sh start
****************************************************
/u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adformsctl.sh start
****************************************************
/u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adoafmctl.sh start
****************************************************
/u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adcmctl.sh start
****************************************************
/u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/jtffmctl.sh start


All enabled services for this node are started.

adstrtal.sh: Exiting with status 0

adstrtal.sh: check the logfile /u01/E-BIZ/inst/apps/VIS_ebsapp/logs/appl/admin/log/adstrtal.log for more information ...

[oracle@ebsapp scripts]$
#6 – Validate The Directory
  • Logout from the current session and log back in. Validate if the directory is created or not.
    login as: oracle
oracle@192.168.56.200's password:
Last login: Sun Feb  2 15:24:22 2014 from 192.168.56.1
[oracle@ebsapp ~]$ . /u01/E-BIZ/apps/apps_st/appl/APPSVIS_ebsapp.env
[oracle@ebsapp ~]$ echo $C_APPS_TOP
/u01/E-BIZ/apps/apps_st/appl/asf/12.0.0
[oracle@ebsapp ~]$
#7 – Create Tablespace
  • Login as SYSTEM / SYSDBA to create tablespace. You can also use any other user who has grant to create tablespace.
    Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 
Connected as SYSTEM
SQL> 
SQL> create tablespace C_APPS datafile '/u01/E-BIZ/db/apps_st/data/c_apps.dbf'
  2  size 10M
  3  autoextend on next 10M
  4  maxsize 100M
  5  ;
Tablespace created
SQL>
#8 – Create Schema
  • Schema Creation
    SQL> 
SQL> create user c_apps identified by c_apps
  2  default tablespace C_APPS
  3  temporary tablespace temp
  4  quota unlimited on C_APPS;
User created
SQL> grant connect, resource to C_APPS;
Grant succeeded
SQL>
#9 – Register Custom Schema in Application
  • Navigate to System Administrator –> Application –> Register
  • Application : Custom Application
  • Shot Name : C_APPS
  • Basepath : C_APPS_TOP
Image 024 Image 025
#10 – Register Oracle User in Application
  • Navigate to System Administrator –> Security –> Oracle –> Register
  • Database User Name : C_APPS (Name of the database user, Should be same user that we create earlier)
  • Password : c_apps (Password for database user, must be same password as we set while creation of user)
  • Privilege : Select valid privilege from LOV
    • Enabled : An enabled ORACLE username has full privileges (insert, query, update, and delete) to the database tables.
    • Restricted : A restricted ORACLE username has only query privileges to the database tables.
    • Disabled : No privileges to access database tables.
  • Install Group : Represent group of installation where 1 represent first group of installation , 2 represent second group of installation.. For custom application this field for reference only, currently not used any where.
Image 026 Image 028
#11 – Adding Application to Data Group
  • Navigate to System Administrator –> Security –> Oracle –> Data Group
  • Query for ‘Standard’ Data Group
  • Add the Custom Application and associate with APPS user.
Image 029 Image 030
#12 – Create Request Group
  • Navigate to System Administrator –> Responsibility –> Request
  • Group : Custom Request Group
  • Application : Custom Application
  • Code : C_APPS
  • Description : Custom Request Group
Image 031 Image 032
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)