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)