Friday, February 28, 2014

ERROR: OPatch failed during prerequisite check. Interim Patch yyyyyyy is holding the lock from this patch xxxxxxx for R12

PROBLEM:
i have problem when try to apply patch:9044638

ERROR:
bash-4.2$ opatch apply

Oracle Interim Patch Installer version 1.0.0.0.64
Copyright (c) 2011 Oracle Corporation. All Rights Reserved..

Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)

Oracle Home : /appdata/data_appl/apps/tech_st/10.1.2
Oracle Home Inventory : /appdata/data_appl/apps/tech_st/10.1.2/inventory
Central Inventory : /appdata/cloneap2/inst/apps/burklon_testburlaapp/admin/oraInventory
from : /etc/oraInst.loc
OUI location : /appdata/data_appl/apps/tech_st/10.1.2/oui
OUI shared library : /appdata/data_appl/apps/tech_st/10.1.2/oui/lib/ibm_aix/liboraInstaller.so
Java location : /appdata/data_appl/apps/tech_st/10.1.2/jre/1.4.2/bin/java
Log file location : /appdata/data_appl/apps/tech_st/10.1.2/.patch_storage/<patch ID>/*.log

Problems with the lock file
Lock file exists, details are:
Interim Patch 9593176 is holding the lock from this patch 9044638,
probably due to previous unsuccessful operation

ERROR: OPatch failed during prerequisite check.

SOLUTION:

1.remove patch_locked file.
mv $ORACLE_HOME\.patch_storage\patch_locked $ORACLE_HOME\.patch_storage\patch_locked_backup
2. apply patch again.

When navigating from one field to another field in Receipts Workbench (ARXRWMAI) using mouse, the cursor will not navigate to the desired field. Users are hard forced to use Tab key on the keyboard for R12

PROBLEM:
When navigating from one field to another field in Receipts Workbench (ARXRWMAI) using mouse, the cursor will not navigate to the desired field. Users are hard forced to use Tab key on the keyboard

SOLUTION:

Responsibility: Receivables Manager
Navigation: Help > About Oracle Applications
Check for Forms Server > Oracle Forms Version

Alternatively, you can get the forms version using the following at the command line prompt:

$ORACLE_HOME/bin/frmcmp_batch | grep Forms | grep Version

If the Forms version is 10.1.2.2,

1. Refer to Note 750359.1 to make sure patches listed under "Forms - Java Patch" in Step 2.1.2 are applied.

If the the issue occurs even after the patches in Note 750359.1 are applied, then it is suggested that the Forms version is upgraded to 10.1.2.3 please refer to Note 437878.1 for more information on the latest patches available.

If the Forms version is 10.1.2.3, then

1. Please download and review the read me for Patch 9044638
2. Then apply Patch 9044638 in a test environment.
3. After applying patch, please regenerate jar files via ADADMIN.
4. Retest the issue.
5. If the issue is resolved, please migrate the solution as appropriate to other environments.