How to Check component Version in Apps 11i/R12/12i

Find component Version in Apps 11i/R12/12i

Q. How to find Apps Version (11i/R12/12i).
A.  Connect to database as user apps
SQL> select release_name from apps.fnd_product_groups;
Output like 12.0.4 or 11.5.10.2

Q. Web Server/Apache or Application Server in Apps 11i/R12
A. Log in as Application user, set environment variable and run below query $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version
Output for 11i should be like
Server version: Oracle HTTP Server Powered by Apache/1.3.19 (Unix)
Server built:   Jan 26 2005 11:06:44 (iAS 1.0.2.2.2 rollup 5)

Output for R12 should be like
Server version: Oracle-Application-Server-10g/10.1.3.0.0Oracle-HTTP-Server
Server built:   Dec  4 2006 14:44:38

Q. Forms & Report version (aka developer 6i) in 11i
A. Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/f60run | grep Version | grep Forms

output like
Forms 6.0 (Forms Runtime) Version 6.0.8.25.2 (Production)
Check fourth character in version 25 which means Forms 6i patchset 16 (25-9)

.

Q. Forms & Report version in R12/12i
A. Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/rwrun | grep Release

Output should be like
Report Builder: Release 10.1.2.2.0
You can safely ignore warnings

Q. Database Version in 11i/R12/12i
A. Go to database section below.

Q. Oracle Jinitiator in 11i/R12/12i
A. Log in as Application user, set environment variable and run below query
grep jinit_ver_comma $CONTEXT_FILE

(Default is Java Plug-In for R12/12i )

Q. Oracle Java Plug-in in 11i/R12/12i
A. Log in as Application user, set environment variable and run below query
grep plugin $CONTEXT_FILE

Q. File Version on file system
adident Header <filename>
or
strings <file_name> | grep Header

Here adident is AD Utility (Oracle Apps) and strings is Unix utility

Q. Version of pld file
*.pld are source code of *.pll which are inturn source of *.plx.  *.pll is in $AU_TOP/resource and to find its version check

adident Header $AU_TOP/resource/<filename>.pll
IGSAU012.pll:
$Header IGSAU012.pld 115.1.115100.1 2004/04/01 05:40:18 appldev ship $

or
strings $AU_TOP/resource/<filename>.pll | grep -i header

FDRCSID(’$Header: IGSAU012.pld 115.1.115100.1 2004/04/01 05:40:18 appldev ship $’);

Q. OA Framework Version
A.http:// hostname.domainName:port/OA_HTML/OAInfo.jsp (Only for 11i)

A.  Log in as Application user, set environment variable and run below query

adident Header $FND_TOP/html/OA.jsp
adident Header $OA_HTML/OA.jsp

output for both should look like
$Header OA.jsp 115.60 2006/03/31 00:47:28 atgops1 noship $

120.21 means OA Framework Version (coming soon..)
115.60 means OA Framework Version (coming soon..)
115.56 means OA Framework Version (coming soon..)
115.36 means OA Framework Version 5.7
115.27 means OA Framework Version 5.6E
115.26 means OA Framework Version 5.5.2E

Q. Discoverer Version for 11i (3i or 4i)
A. Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/disc4ws | grep -i Version

Q. Discoverer Version for 11i or R12 (10g AS)
Check under Application Server Section as 10g AS Discoverer is on standalone

Q. Workflow Version with Apps
A. Connect to Database as apps user
SQL> select TEXT Version from   WF_RESOURCES where  NAME = ‘WF_VERSION’;
Output like 2.6.0 means workflow version 2.6.0

.

Version for Fusion Middleware Component

Identity Management component Version/Release Number

A. Oracle Single Sign On
Connect to database which holds SSO repository
SQL>select version from orasso.wwc_version$;

B. Oracle Internet Directory

There are two component in OID (Software/binaries & Schema/database)

>>> To find software/binary version

$ORACLE_HOME/bin/oidldapd -version
output should look like

oidldapd: Release 10.1.4.0.1 - Production on mon jul 14 14:14:21 2008
Copyright (c) 1982, 2006 Oracle.  All rights reserved.

>>> To find Schema Version/ database use

ldapsearch -h <hostname> -p <port> -D “cn=orcladmin” -w “<password>” -b “” \
-s base “objectclass=*” orcldirectoryversion

and output should be like

version: 1
dn:
orcldirectoryversion: OID 10.1.4.0.1

or run following query in database
SQL> select attrval from ods.ds_attrstore where entryid = 1 and attrname = ‘orcldirectoryversion’;

Output should be like OID 10.1.4.0.1

C. Application Server

1. Oracle Application Server 10g Rel 3 (10.1.3.X)
cat $ORACLE_HOME/config/ias.properties | grep Version

Version=10.1.3.0.0

2. For Oracle Application Server 10.1.2 (Prior to Oracle WebLogic Server)
If application server is registered in database (Portal, Discoverer) check from database
SQL> select * from ias_versions;
or
SQL>select * from INTERNET_APPSERVER_REGISTRY.SCHEMA_VERSIONS;

.

D. AOC4J (Oracle Container for J2EE)
Set ORACLE_HOME
cd $ORACLE_HOME/j2ee/home
java -jar oc4j.jar -version

.

E. Oracle Portal
SQL> select version from portal.wwc_version$;

.

Database Component

I) Oracle Database

To find database version
SQL> select * from v$version;
or
All component version in database

$ORACLE_HOME/OPatch/opatch lsinventory -detail.

Oracle Enterprise Manager
Metalink Note 605398.1  How to to find the version of the main EM components.

Unix Operating System

Solaris -> cat /etc/release
Red Hat Linux -> cat /etc/redhat-release

 .

Concurrent Requests Fail Due to Output Post Processing (OPP) Timeout

• Error Message A (CONC-PP NO RESPONSE):
  
  
  The Output Post-processor is running but has not picked up this request.
  No further attempts will be made to post-process this request, and the request will be marked
  with Warning status.
  Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary.

Cause A (CONC-PP NO RESPONSE)

The concurrent manager process generates the XML data file. Upon completion it will trigger the Output Post Processor in order to merge the XML data file and the template which was selected on the Submit Request form.

The number of concurrent requests that the Output Post Processor can handle in parallel depends upon:

• the number of Processes
• the number of Threads Per Process

The default values are 2 Processes and 5 Threads Per Process so a total of 10 reports can be processed in parallel.

In case there are other concurrent requests running which have already invoked the OPP then it might happen that no additional requests can be picked up for a period of time. The pending request will be picked up as soon as one of the running jobs completes. By default a timeout will occur if it takes longer then 120 seconds (2 min.) for the Output Post Processor to pick up the request from the concurrent manager process. In that case, the concurrent request will complete with status Warning and the request log file will contain Error Message A (see above).

Solution A (CONC-PP NO RESPONSE)

Option 1: Increase the value (in seconds) for the profile option 'Concurrent:OPP Response Timeout'.
Option 2: Increase the number of processes or threads (or both) of the OPP via Oracle Applications Manager

If Option 2 is taken, remember to stop and restart the OPP for the change to be implemented

• Error Message B (CONC-PP TIMEOUT):
  
  
  The concurrent manager has timed out waiting for the Output Post-processor to finish this request.
  
  Check that there are enough Output Post-processor service processes running.
  More information may be found in the service process logfile.

Cause B (CONC-PP TIMEOUT)

Once the Output Post Processor picks up the request, the BI Publisher engine is invoked to generate the final output file. The time that this takes will depends on various elements such as:

• size of the XML Data File
• complexity of the template
• performance of the server
• ....

By default a timeout will occur if it takes longer then 300 seconds (5 min.) for the BI Publisher engine to generate the output file. The concurrent request will complete with status Warning and the request log file will contain Error Message B. 

Solution B (CONC-PP TIMEOUT)
Increase the value (in seconds) for the profile option 'Concurrent:OPP Process Timeout'.

• Error Message C (CONC-PP NO RESPONSE and TIMEOUT):
  
  
  The Output Post-processor is running but has not picked up this request.
  No further attempts will be made to post-process this request, and the request will be marked
  with Warning status.
  Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary.

Cause C (CONC-PP NO RESPONSE and TIMEOUT)

The Output Post Processor (OPP) service is not picking up any new requests.
The Output Post Processor JAVA process is still running, but it is unresponsive. 

This can be due to errors in previous requests or just to the amount of time the manager has been running. The OPP becomes unresponsive (stale) after running for more than one week.

Solution C (CONC-PP NO RESPONSE and TIMEOUT):
To implement the solution, execute the following steps:

For 11i and 12i Environments:

1. Please run the Concurrent Manager Recovery feature to address any Concurrent Manager / Concurrent Processing issues within the Oracle Application Manager.
2. Resubmit report.

OR

For 12i Environments:

1. Apply R12.ATG_PF.A.DELTA.6 (7237006)
2. Retest.

Workaround
The timeouts can also be altered directly in the package AFCPOPRB.pls :

The package body (AFCPOPRB.pls) and spec (AFCPOPRS.pls)can be found at the following location: patch/115/sql

Example: patch/115/sql/AFCPOPRB.pls

-- Default timeout values for waiting on a response to a request (seconds)
TIMEOUT1   constant number := 120;  
TIMEOUT2   constant number := 300;

TIMEOUT1 and TIMEOUT2 corresponds to respectively OPP Response Timeout (solution A) and OPP Process Timeout (solution B).

Concurrent Manager “System Hold, Fix Manager before resetting counters”.

Recently after EBS upgrade to 12.1.3 CM were not functional and was showing status “System Hold, Fix Manager before resetting counters”. 

Solution:
To implement the solution, please execute the following steps:

1. Stop all middle tier services including the concurrent managers.
Please make sure that no FNDLIBR, FNDSM, or any dead process is
running.

2. Go to cd $FND_TOP/bin
$ adrelink.sh force=y link_debug=y “fnd FNDLIBR”
$ adrelink.sh force=y link_debug=y “fnd FNDFS”
$ adrelink.sh force=y link_debug=y “fnd FNDCRM”
$ adrelink.sh force=y link_debug=y “fnd FNDSM”

3. Run the CMCLEAN.SQL script from the referenced note below (don’t forget to commit).
Note 134007.1 CMCLEAN.SQL – Non Destructive Script to Clean Concurrent Manager Tables

4. Start the concurrent manager.

5. Retest the issue.

Reference :
SCHEDULE/PRERELEASER MANAGER STATUS : SYSTEM HOLD, FIX MANAGER BEFORE RESETTING [ID 985835.1]

How to Compiling form and Libraries in Oracle Apps R12

Compiling Form

• Login to server apps

• run environment

• Navigate to the path $AU_TOP/forms/US

• run the below command, .fmx file will be generated if there are no errors. 

Installing Oracle Database 12c onn Linux [RHEL6]

Prerequisete Installation

·         Add or edit kernel parameter in /etc/sysctl.conf

fs.file-max = 6815744

kernel.sem = 250 32000 100 128

kernel.shmmni = 4096

kernel.shmall = 1073741824

kernel.shmmax = 4398046511104

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

How to Clone Oracle Apps R12

Step by step Clone oracle apps

1. Preclone on source Server

 Preclone AppsTier
cd /u01/oracle/PROD/inst/apps/PROD_apdev12/admin/scripts
./adpreclone.pl appsTier

How to apply patch Oracle Apps R12

Shutdown apps services
cd /u01/oracle/PROD/inst/apps/PROD_appdev12/admin/scripts/
./adstpall.sh apps/apps

Set Environment Variables
Login as Oracle user.
In R12 we will do as follows
$ cd /u01/oracle/PROD/apps/apps_st/appl/
$. APPSPROD_appdev12.env