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