ApplySession failed during prerequisite checks: Prerequisite check "CheckPatchApplicableOnCurrentPlatform" failed.

PROBLEM:

we hade error when applied patch.

error:
ApplySession failed during prerequisite checks: Prerequisite check "CheckPatchApplicableOnCurrentPlatform" failed.

SOLUTION:

1.check the your OS version.
2.download correct version  of patch
3. reapply patch

OOPS: cannot change directory

PROBLEM:

i had error when tried to connect with FTP.
error:
OOPS: cannot change directory:/ftp_user_home_path

SOLUTION:

you must to disable firewall.

sudo setenforce 0

sqlplus not found in crontab

PROBLEM:

i hade below error when tried to run shell script in cron job.
the script included sqlplus command.

scripts:

!/bin/bash
sqlplus DB_USER/DB_PASSWORD @SQL_SCRIPT_PATH/SQL_SCRIPTS.sql

The script did not run.
Crontab hade error when tried to run script in log file.

error:
script_path/script.sh: sqlplus:  not found

SOLUTION:

you must change the script:

!/bin/bash
export ORACLE_SID=<SID_NAME>
export ORACLE_HOME=<ORACLE_HOME path>
export PATH=$ORACLE_HOME/bin:$PATH
sqlplus -s /nolog <<EOF
    connect <DB_user/DB_password>
    @SQL_SCRIPT_PATH/SQL_SCRIPTS.sql
spool off
EOF


good luck...

Failed to connect to database - Unable to connect to Oracle Applications database (afscpgcs)

PROBLEM

I had error when tried to coonect BI Discoverer.

A connection error.
- Oracle BI Discoverer is unable to authenticate using the password provided. This can happen due to an invalid password or because the password was lost while using back, forward, or refresh in your browser. Enter the password again to continue.
- Failed to connect to database - Unable to connect to Oracle Applications database (afscpgcs)


SOLUTION
Copy application .dbc file under Middelware_Home\asinst_no\config\Discoverer\Discoverer_asinst_no

Local Event ERROR : oracle.apps.ar.applications.CashApp

PROBLEM

Local Event ERROR : oracle.apps.ar.applications.CashApp

SOLUTION

If you do not need the PA AR Notification subscription then you can disable it as follows:

First login as SYSADMIN (you must have SYSADMIN privileges in order to update)

Responsibility: Workflow Administrator Web Applications
Navigation: Administrator Workflow > Business Events
- In Name field for search criteria enter 'oracle.apps.ar.applications.CashApp.apply'
- (B) Click Go
- It will show you one even under Results
- Under Subscription column, click on Subscription icon
- Go to update subscription "PA_PWP_NOTIFICATION.Receive_BE"
- Select Disable
- Apply
- This will disable the notifications to PA manager and will also bypass the call made to this particular API.



If on the other hand you need the PA AR Notification subscription, then please apply the patch below:



1. Bug Summary

Description
The issue is introduced as part of the changes done for ER of "Oracle Project Costing".
The code within procedure PA_PWP_NOTIFICATION.Receive_BE re-initializes FND variables and this causes the errors to be raised.

Workaround
None

Resolution
Commented the call to apps_inititalize(), now this package will get called in context already set by AR.
2. Fixed Files

R12.AR.A:
ARATRECB.pls 120.25.12000000.88
ARCEAPPB.pls 120.81.12000000.42
ARTACCMB.pls 120.19.12000000.12

R12.AR.B:
ARATRECB.pls 120.40.12010000.56
ARCEAPPB.pls 120.86.12010000.25
ARTACCMB.pls 120.19.12010000.6


3. Recommended Patches

R12.AR.A and R12.AR.B: Patch 8903995

4. Solution Steps

Ensure that you have taken a backup of your system before applying the recommended patch.
Apply the patch in a test environment.
Confirm the file versions listed above, by navigating to the directory where the file is and using:
strings -a |grep '$Header'
Retest the issue.
Migrate the solution as appropriate to other environments.
If the patch for your release is unavailable for download or needs a password, or if you experience any issues applying this patch, please contact the E-Business Patching Community for assistance.

ref:Receipt Workbench Error: Applying Receipt Generates Workflow Notification With Error - Local Event Error: oracle.apps.ar.applications.cashapp.apply (Doc ID 973074.1)

CORBA protocol : Failed to bind to session using IOR

PROBLEM:

A connection error has occurred.
- OracleBI Discoverer was unable to complete the connection initialization.
- Attempt 1. CORBA protocol : Failed to bind to session using IOR : null Hint An administrator can further diagnose connection problems by running the "checkdiscoverer" script under <ORACLE_HOME>/discoverer/util.


SOLUTION:

 To implement the solution, please execute the following steps.  Please backup files prior to modifying them.
1. Edit the opmn.xml file: (10.1.2 in $ORACLE_HOME/opmn/conf ) (11.1.1 in $ORACLE_INSTANCE\config\OPMN\<opmn-component-name>\ )
2. Increase the value of maxprocs parameter

3. Re-load the opmn.xml file ('opmnctl reload') recycle the Discoverer middle tier ('opmnctl stopall', 'opmctl startall')


ref:Discoverer Plus or Viewer Connection Attempt Receives a CORBA Error, Hard Limit (Doc ID 399846.1)

Config Error Cannot add duplicate collection entry of type 'mimeMap' with unique key attribute 'fileExtension' set to '.docx' for UPK

this error receive when try to open http://localhost/KContent and educations after installition upk.

PROBLEM

HTTP Error 500.19 - Internal Server Error
The requested page cannot be accessed because the related configuration data for the page is invalid.
Module CustomErrorModule
Notification SendResponse
Handler StaticFile
Error Code 0x800700b7
Config Error Cannot add duplicate collection entry of type 'mimeMap' with unique key attribute 'fileExtension' set to '.docx'
Config File \\?\C:\KContent\web.config

Config Source

  163:       <mimeMap fileExtension=".ex~" mimeType="application/octet-stream" />
  164:       <mimeMap fileExtension=".docx" mimeType="application/vnd.openxmlformats-officedocument.wordprocessingml.document" />
  165:       <mimeMap fileExtension=".flv" mimeType="video/x-flv" />

SOLUTION

1.open the C:\KContent\web.config

2.add below lines between <staticContent>  tags.

 <remove fileExtension=".flv" />
 <remove fileExtension=".docx" />
 <remove fileExtension=".ex~" />

3.saved the web.config


ref:UPK: Importing a Title into Knowledge Center Fails with HTTP Error 500.19 Internal Server Error (Doc ID 1521720.1)

how to find running concurrent process id in operation system for R12,R11

execute below sql definition in sqlplus with apps user.

SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
v$process c,
v$session d
WHERE a.controlling_manager = b.concurrent_process_id
AND c.pid = b.oracle_process_id
AND b.session_id=d.audsid
AND a.request_id = &Request_ID
AND a.phase_code = 'R';

it will want concurrent no,

after find out process id, you can list.

ps -ef | grep process_id

how to start / stop netbackup services in unix

Stop:
/usr/openv/netbackup/bin/goodies/netbackup stop

Start:
/usr/openv/netbackup/bin/goodies/netbackup start

deleted xml definition in CONTEXT_FILE after adautocfg.sh for R12

i write xml definition for custom top in CONTEX_FILE, but it is deleted after run adautocfg.sh.

xml syntax:
<XXXXX_TOP oa_var="s_xxxxx_top" oa_type="PROD_TOP" oa_enabled="FALSE">$APPL_TOP/xxxxx/12.0.0</XXXXX_TOP>

SOLUTİON:

write in topfile.txt and run  adautocfg.sh. ($APPL_TOP/admin/topfile.txt)
synatx:
xxxxx    $APPL_TOP

how to count EBS users

query:

SELECT user_id, user_name, full_name
    FROM fnd_user fu, per_all_people_f papf
   WHERE papf.person_id = fu.employee_id
         AND SYSDATE BETWEEN fu.start_date AND NVL (fu.end_date, SYSDATE)
         AND SYSDATE BETWEEN papf.effective_start_date
                         AND NVL (papf.effective_end_date, SYSDATE ) ORDER BY 2;

TNS-01151: Missing listener name, APPS_database-SID, in LISTENER.ORA for 11g

PROBLEM:

i have problem (below) when run adstrtal.sh after  Perl adcfgclone.pl appsTier.

TNS-01101: Could not find service name libociei.so

TNS-01101: Could not find service name libociei.so
03/01/14-22:17:48 :: adalnctl.sh: Starting listener process APPS_SID.

LSNRCTL for Solaris: Version 10.1.0.5.0 - Production on 01-MAR-2014 22:17:48

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Starting $ORACLE_HOME/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 10.1.0.5.0 - Production
Log messages written to $ORACLE_HOME/network/log/apps_mesakl04.log
TNS-01151: Missing listener name, APPS_database-SID, in LISTENER.ORA

Listener failed to start. See the error message(s) above...


SOLUTION:

cd  $INST_TOP/ora/10.1.2/network/admin/

if listener.ora is not found under path

cd $ADMIN_SCRIPTS_HOME
./adautocfg.sh


it will solve.
go to $INST_TOP/ora/10.1.2/network/admin/ for test.

Could not find all the required OS utilities in the $PATH' Error for solaris when run perl adcfgclone.pl appsTier for R12

PROBLEM:

cd $COMMON_TOP/clone/bin  and  run perl adcfgclone.pl appsTier :

bash-3.2$ perl adcfgclone.pl appsTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.31.12010000.8

Enter the APPS password :

Checking for make...
 Unable to locate 'make' utility in path
 Checking for ld...
 Unable to locate 'ld' utility in path
 Checking for ar...
 Unable to locate 'ar' utility in path
 Unable to locate all utilities with system path.
 PATH = $COMMON_TOP/clone/bin/../jre/bin:/bin:/usr/bin:/usr/bin:/bin:/opt/openv/pdde/pdopensource/bin:/usr/X11/bin:/usr/openwin/bin


WARNING:  could not find all the required os utilities in the $path. please review the checks above                                                                                        w the checks above


SOLUTION:

To implement the solution, please execute the following steps:

1. Locate the missing utilities. On most releases of unix, they are in /usr/ccs/bin
2. Include a reference to the utilities path in the $PATH environment variable for the applmgr user used to manage the instance. Remember to export the PATH for changes to take effect.
3. Rerun the command 'perl adcfgclone.pl appsTier'

ref:   adcfgclone.pl is Unable to Locate All Utilities in the System Path - 'Could not find all the required OS utilities in the $PATH' Error (Doc ID 397742.1)

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.