Register Custom Application In Oracle Applications 11i and R12

-


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 custom 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

#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


Comments

Post a Comment

Popular posts from this blog

Workflow Agent Listener Service WF_DEFERRED + Business Event not processing

-
Workflow Agent Listener Service WF_DEFERRED Will Not Start, Mailer May Be Down To implement the solution, please execute the following steps: 1.  Use this query to identify any remaining items in wf_deferred queue: SQL> select corrid, decode(state, 0, '0 = Ready', 1, '1 = Delayed', 2, '2 = Retained', 3, '3 = Exception', to_char(state)) State, count(*) COUNT from wf_deferred group by corrid, state; 2. Items with the APPS corrid will not dequeue from agent listener via service container.  This runs the deferred listener from the command lin e . Make sure that the listener and workflow service components - including the mailer - are down before you run this . This is not intended to be a substitute for the normal operation of this service container from the OAM console. Use this only during this cleanup operation. One will have to run this script manually: begin wf_log_pkg.wf_debug_flag := TRUE; wf_event...
Read more

Output Post Processor - EBS 12.2.4 Troubleshoot

-
Output Post Processor TroubleShooting Issue 1 Output Post Processor is Down with Actual Process is 0 And Target Process is 1 1. Shutdown Concurrent Managers 2. To ensure concurrent manager down; check there is no FNDLIBR process running. ps -ef | grep FNDLIBR 3. Run adadmin to relink FNDSVC executable. a. Invoke adadmin from command prompt b. Choose option 2 (2. Maintain Applications Files menu) c. Choose option 1 (1. Relink Applications programs ) d. Then type FND When prompted; ( Enter list of products to link (all for all products) [all] : FND ) e. Ensure adrelink is exiting with status 0 4. Start Concurrent Managers 5. Check the Output Post Processor Issue 2 Concurrent Processing  R12 Output Post Processor Service Not Coming Up Reason : If Service Manager for the node is not running.  Possible cause might be service manager definition is missing under Concurrent ->Manager ->Define form. If the Service Manager is not pr...
Read more

How to Diagnose Workflow Notification Mailer Issue

-
Outbound Notification Emails : 1. Check if the notification is present in the recipient/user's Worklist/Notifications page.If it does not exist     then it means that notification itself is not created and need to check the corresponding workflow     status.You may also query the notification from the wf_notifications table SQL> select recipient_role,notification_id,status,mail_status from wf_notifications where recipient_role like '&user_name';    The e-mail notification is sent only if all of following are true.                --Notification status is OPEN or CANCELED                --Notification mail_status is MAIL or INVALID 2. Check Recipient role has a valid e-mail address and notification preference MAIL% SELECT email_address, nvl(WF_PREF.get_pref(name, 'MAILT...
Read more