foalabs

In this post I am going to share how to install Oracle EBS R12.2 on multiple nodes. Which means Database on one server and Application on one server. I am using Oracle Virtual Box and configured 2 servers, one for Database and one for Application. Virtual Server/Machine Details Database Node Memory: 6 GB Harddisk: 200 GB Hostname: fundb.lab IP: 192.168.56.80 OSuser: oracle Stage Area has been created separately on nodes and is non shared Application Node Memory: 7 GB Harddisk: 270 GB Hostname: funapp.lab IP: 192.168.56.81 OSuser: applmgr Stage Area has been created separately on nodes and is non shared   Please perform all the pre-reqs on both nodes as described in earlier post. 1) user creation 2) rpm installation and limits configuration 3) oraInst.loc Refer  https://www.funoracleapps.com/2017/02/installing-oracle-apps-r122-step-by.html  for steps by step pre-installation method setup. Also make sure hostname are pingable from each other....

Oracle Workflow Services in Oracle Applications are encountering problems.The workflow components are not starting when I was trying to start up the services from front end web-form using system administrator responsibility.These services appear with a Target value of 1 and an Actual value of 0. Even I tried from Concurrent>Manager>Administer form but still these were not starting.  Workflow components was not coming  Up and  showing as below  Target - 1 Actual - 0 Workflow service Components and there shotnames. Workflow Agent Listener Service - WFALSNRSVC Workflow Mailer Service - WFMLRSVC Workflow Document Web Services Service - WFWSSVC  We can find the same using below query as well. Workflow Agent Listener Service: SQL> select CONCURRENT_QUEUE_NAME from  apps.fnd_concurrent_queues_tl where USER_CONCURRENT_QUEUE_NAME='Workflow Agent Listener Service'; CONCURRENT_QUEUE_NAME --------------...

If we want to unlink any Oracle application user from SSO then we can use below script. Run the EBS  script $FND_TOP/patch/115/sql/ fndssouu.sql  USER_NAME Apart from setting the FND_USER.USER_GUID value to NULL, this script also flushes the workflow entity cache for the user.

When Autoconfig is executed in EBS/Oracle Apps it creates various configuration files which are created from the template files. Some time we might need to find the template file associated with these conf file to customize these templates and avoid autoconfig to use the default ones. Below are the few important points to be remembered. The AutoConfig template file cannot be customized if the "LOCK" keyword appears in the template file. AutoConfig ignores custom template files that are marked with "LOCK”. Customization of Template File must be done on both Patch & Run File system. How to Determine the Auto Config template file which you want to customize. Apps Tier: /bin/adtmplreport.sh contextfile= target= DB Tier: /appsutil/bin/adtmplreport.sh contextfile= target= Example: $AD_TOP/bin/adtmplreport.sh contextfile=/u01/TEST/fs1/inst/apps/TEST_funoracleapps/appl/admin/TEST_funoracleapps.xml target=/u01/TEST/fs1/FMW_Home/webtier/insta...

We can use below query to check the session details. Query: select s.ECID ,s.inst_id, s.SID,s.SERIAL#,p.spid,s.status,s.machine, s.ACTION, s.MODULE, s.TERMINAL,s.sql_id,s.last_call_et,s.event, s.client_info,s.PLSQL_SUBPROGRAM_ID,s.PROGRAM,s.client_identifier , ( SELECT max( substr( sql_text , 1, 40 )) FROM gv$sql sq WHERE sq.sql_id = s.sql_id ) AS sql_text , ( SELECT object_name FROM dba_procedures WHERE object_id = plsql_entry_object_id AND subprogram_id = 0) AS plsql_entry_object , ( SELECT procedure_name FROM dba_procedures WHERE object_id = plsql_entry_object_id AND subprogram_id = plsql_entry_subprogram_id) AS plsql_entry_subprogram , ( SELECT object_name FROM dba_procedures WHERE object_id = plsql_object_id AND subprogram_id = 0) AS plsql_entry_object , ( SELECT procedure_name FROM dba_procedures WHERE object_id = plsql_object_id AND subprogram_id = PLSQL_SUBPROGRAM_ID) AS plsql_entry_subprogram , 'alter system kill session ' || '''' || s.SID |...