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
- 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
- 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>
- 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]$
- 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]$
- 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]$
- 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 ~]$
- 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>
- 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>
- Navigate to System Administrator –> Application –> Register
- Application : Custom Application
- Shot Name : C_APPS
- Basepath : C_APPS_TOP
#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.
#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.
#12 – Create Request Group
- Navigate to System Administrator –> Responsibility –> Request
- Group : Custom Request Group
- Application : Custom Application
- Code : C_APPS
- Description : Custom Request Group
This comment has been removed by the author.
ReplyDelete