After Installation of Oracle Applications R12.1.1,I have upgraded to R12.1.3 Successfully in my Servers. The following patches are required and download from the Oracle Support as per their environment.In this Note I have added some more patches for avoiding the feature errors and for avoiding invalid objects. Before going to proceed please check the metal ink Note Oracle E-Business Suite Release 12.1.3 Readme [ID 1080973.1].
Required patches:
p9239089_R12.AD.B_R12_LINUX.zip
p10349415_R12.AD.B_R12_GENERIC.zip (Optional)
p9239090_R12_LINUX_1of6.zip
p9239090_R12_LINUX_2of6.zip
p9239090_R12_LINUX_3of6.zip
p9239090_R12_LINUX_4of6.zip
p9239090_R12_LINUX_5of6.zip
p9239090_R12_LINUX_6of6.zip
p9239095_R12_GENERIC.zip
p9822544_R12.MSC.B_R12_GENERIC.zip(Optional)
Post update patches are :
p9966055_R12.FND.B_R12_GENERIC.zip
p9817770_R12.ATG_PF.B_R12_LINUX.zip
The following information will provide upgradation process for Ooracle Applications R12.1.1 to R12.1.3.
Step1: Run adadmin and put Maintenance Mode
Step2: Apply Prerequisite R12.AD.B.DELTA.3 Patch 9239089
Do the following Tasks before going to apply the Patch R12.AD.B.DELTA.3 Patch 9239089
Run the adgrants.sql script as a user that can connect as SYSDBA to grant privileges to selected SYS objects and create PL/SQL profiler objects.
Usage:
1.Create $ORACLE_HOME/appsutil/admin on the database server.
2.Copy adgrants.sql (UNIX) from this patch directory to $ORACLE_HOME/appsutil/admin.Or, copy adgrants_nt.sql (Windows) from this patch directory to %ORACLE_HOME%\appsutil\admin.
3.Set the environment to point to ORACLE_HOME on the database server.
4.Use SQL*Plus to run the script:
UNIX:
$ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql
Step3: Apply R12.AD.B_R12_GENERIC.zip Patch 10349415
Step4: Apply Oracle E-Business Suite Release 12.1.3 Patch 9239090
Step5:. Apply Oracle E-Business Suite Online Help for 12.1.3 Release Update Pack patch 9239095
Step6:.Apply Patch 9822544 for Advanced Supply Chain Planning. (Optional).This patch fixes the issue of collecting resource requirements of OPM batches WIP warehouse does not belong to resource warehouse.
Step7: Apply post Update Patches:
–Apply mandatory Patch 9817770 (9817770:R12.ATG_PF.B [POST-R12.ATG_PF.B.DELTA.3 CONSOLIDATEDPATCH].)
–Apply mandatory Patch 9966055 (9966055:R12.FND.B [TRANSLATED VERSION OF FNDSCSGN NOT LAUNCHED].)
Notice
After you have upgraded to Oracle E-Business Suite Release 12.1.3, perform the following post-update steps to update all database tier nodes with the code level, provided by Oracle E-Business Suite Release 12.1.3Step8: Run Application and Database Environment files.
@Application Tier:
Run AutoConfig on the APPL_TOP.
Run the admkappsutil.pl utility to create the file appsutil.zip in the /admin/out directory.
perl /bin/admkappsutil.pl@Database Tier:
Copy or FTP the appsutil.zip file to the . Uncompress appsutil.zip under the .
cd
unzip -o appsutil.zip
Run AutoConfig on the .
Step9:. Run adpreclone.pl on the database tier and the application tier
perl adpreclone.pl dbTier
perl adpreclone.pl appsTier
Step10: Disable Maintenance Mode using adadmin and check the version using following sql statement.

SQL> select release_name from fnd_product_groups;
RELEASE_NAME
————————————————–
12.1.3

Concurrent Manager - Sytem Hold, Fix Manager before resetting Status

Concurrent Processing – SYSTEM HOLD, FIX MANAGER BEFORE RESETTING [ID 985835.1]
==========================================================================
On 12.1 in Production:
When attempting to run requests the Scheduler/Prereleaser is showing the
following error:
The actual value of the manager is 0.
ERROR:
———————–

"System Hold, Fix Manager before resetting counters".

This issue could appear also for all the concurrent managers not only for Scheduler/Prereleaser.
Steps to Reproduce
Responsibility System administrator >Concurrent > Manager > Administer

Cause

One of manager “Scheduler/Prereleaser Manager” is showing status “System Hold, Fix Manager before resetting counters”.
Solution suggested as per:
Bug 8446080
Bounced CM, Ran Cm clean & Issue resolved.
Bug 8240251
Bounced DB listener
Compiled apps schema using adadmin
Bug 8264854
SELECT
a.user_concurrent_queue_name,c.CONCURRENT_PROCESSOR_NAME,d.control_code
FROM
fnd_concurrent_queues_tl a , fnd_concurrent_queues
b,FND_CONCURRENT_PROCESSORS c , FND_CONCURRENT_QUEUES_VL d
WHERE a.concurrent_queue_id=b.concurrent_queue_id AND d.enabled_flag=’Y’
AND
d.control_code=’H’ AND d.concurrent_queue_name = a.concurrent_queue_name
AND a.LANGUAGE=’US’ AND b.concurrent_processor_id=c.concurre
nt_processor_id;
Select owner, name, enqueue_enabled, dequeue_enabled
From dba_queues
Where upper (name) like ‘%GSM%’
and owner=’APPLSYS’
order by name;

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. Stop the database.
3. Start the database.
4. 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”
5. 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
6. Execute the following SQL:
select CONCURRENT_QUEUE_NAME from FND_CONCURRENT_QUEUES where
CONCURRENT_QUEUE_NAME like ‘FNDSM%’;
7. Start the middle tier services including your concurrent manager.

8. Retest the issue.