'Concurrent program returned no reason for failure' || 'ORA-03114: not connected to ORACLE' || 'Shutting down Concurrent Manager' ||'Routine AFPCMT encountered an ORACLE error. ORA-03114: not connected' ||'Intermittently Login URL unable to Access' || 'COncurrent Programs and Reports are Erroring out' || 'Standard manager getting down automatically' || 'OPP aslo getting down automatically'

'Concurrent program returned no reason for failure' || 'ORA-03114: not connected to ORACLE' || 'Shutting down Concurrent Manager' ||'Routine AFPCMT encountered an ORACLE error. ORA-03114: not connected' ||'Intermittently Login URL unable to Access' || 'Concurrent Programs and Reports are Erroring out' || 'Standard manager(FNDLIBR) getting down automatically' || 'OPP aslo getting down automatically' || after executing adcmctl.sh, FNDLIBR process won't go down

Errors :

=======================Error1=================================

Concurrent program returned no reason for failure.

===========================Error 2============================
Cause: AFPRSR-Resubmit_Time failed due to ORA-03114: not connected to ORACLE
.

The SQL statement being executed at the time of the error was: select To_Char(To_Date(Decode(Resubmit_Time,null ,'00:

Shutting down Concurrent Manager : 05-JUL-2014 11:22:21
ORA-03114: not connected to ORACLE

ORACLE error 3114 in AFPRSR-Resubmit_Time

Cause: AFPRSR-Resubmit_Time failed due to ORA-03114: not connected to ORACLE
.

The SQL statement being executed at the time of the error was: select To_Char(To_Date(Decode(Resubmit_Time,null ,'00:

List of errors encountered:
.............................................................................

_ 1 _
Routine AFPCMT encountered an ORACLE error. ORA-03114: not connected
to ORACLE
.

Review your error messages for the cause of the error. (=<POINTER>)

_ 2 _
Routine AFPPRD has encountered a fatal error. ORA-03114: not connected
to ORACLE


Contact your system administrator or support representative.

_ 3 _
Routine AFPPRD has encountered a fatal error. ORA-03114: not connected
to ORACLE


Contact your system administrator or support representative.
.............................................................................


=========================Error 3====================
Program was terminated by signal 9
APP-FND-01564: ORACLE error 3114 in close_server_files

Cause: close_server_files failed due to ORA-03114: not connected to ORACLE.

The SQL statement being executed at the time of the error was: &SQLSTMT and was executed from the file &ERRFILE.
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 3213341.

Review your concurrent request log and/or report output file for more detailed information.
ORACLE error 3114 in AFPRSR-Resubmit_Time
=========================Error 4======================
+---------------------------------------------------------------------------+
Subledger Accounting: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

XLAACCUP module: Accounting Program
+---------------------------------------------------------------------------+

Current system time is 05-JUL-2014 05:40:44

+---------------------------------------------------------------------------+

**Starts**05-JUL-2014 05:40:44



like above log in concurrent request's log, all the reports and requests are going into Error


========================================================================

Solution

========================================================================

we were unable to resolve this issue for 4 days, create many SR with oracle and took Oracle ACS service and got the confirmation that database side everything fine.

and they said it could be because of network issue.

If anybody face above error check the following:

1) Check database and application server's hard status like RAM,CPU and Hard disk etc...

2) Check connectivity between database and application.

3) verify the database and application servers are same subnet like ( db server ip : 10.10.10.221 apps server ip : 10.10.10.223 )

4) verify firewall and switch bandwidth utilization between database and application server

5) If application and database's servers are in different subnet mask like connective between database and application happening through firewall,
   and firewall unable to process the connective between the these db and apps, cpu of firewall reaching 90 to 100%,
   Bring the db and apps server in same subnet so that connective would not happen by firewall, then it will communicate by switch.
 
   <<<<<<<<<< all the above errors happened in our Environment because of this >>>>>>>>>>
 

App server ip was : 10.10.9.221
DB server ip was  : 10.10.10.223

Then we changed ip address of application server ( 10.10.10.198 ) by the use of : Correct Method of Changing the IP Address in 11i & R12 (Doc ID 751328.1)

Then everything became fine...... :)

Thanks & Regards,

Chandrasekar S

Error in Workflow POAPPRV/19799-83839 [WF_ERROR] ERROR_MESSAGE=3835: Error '-6508 - ORA-06508: PL/SQL: could not find program unit being called' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.n

“Error in Workflow POAPPRV/19799-83839 [WF_ERROR] ERROR_MESSAGE=3835: Error '-6508 - ORA-06508: PL/SQL: could not find program unit being called' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.n”

Like above notifications in sysadmin workflow notifications

                                                                AND

Users are complaining workflow mails are not getting (i.e) If a purchasing user creates a PO and sends to his manager but his manager not getting mail for approval link.

                                                                AND

 Unsent mails  count are getting increase and not getting reduce its count more than 1hr.

                                                AND

wf_notifications table column shows mail is “open” and mail_status are “invalid or mail”

Solution for this above problem is ,

1)      Check workflow mailer is running, if running go to step 2.

2)      Go to Oracle application manager > sitemap > Notificaton Mailer > click on “view details” >on right corner of the page , you will see test mail “so click on test mailer” >recipient role “enter some users name who is facing problem > send test message

3)      Check with that users whether he gets the test mail from EBS or not

4)      Check for any new invalid objects in apps schema (Select object_name,owner ,status from dba_objects where status=”INVALID” and owner=”APPS”;)

5)      If found any new invalid objects in apps schema, recompile if using SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql

6)      Now check count of invalid objects in apps again using above query

7)      If any new invalid objects apps schema and all objects in valid state

8)      Now go to workflow manager  >  stop & start  workflow notification mails

9)      After restarting “workflow notification mailer “ users must get the notification from EBS

TNS-04605: Invalid syntax error: Unexpected char or LITERAL

When trying to configure listener or net services of oracle database below error is received 

C:\Documents and Settings\Administrator>netca

Oracle Net Services Configuration:

ServiceAliasException: Could not enum Net Service Names: TNS-04404: no error

  caused by: oracle.net.config.ConfigException: TNS-04414: File error

  caused by: TNS-04605: Invalid syntax error: Unexpected char or LITERAL "PROD"

before or at  PROD = (

Oracle Net Services configuration terminated by user.  The exit code is -1

Same time i'm unable to access in oracle net Manager unable to add or modify in Name serving.

Solution for this Error is:

Reason : Entry in tnsnames.ora syntax is incorrect or missing some parameters.

Solution : 

Check the below syntax is matching according to your SID(TEST) , IP Address(192.168.75.131) and Port (1521)

otherwise copy this below syntax and paste in your $ORACLE_HOME/network/tnsnames.ora

and change these SID,IP and Port according to your Env.

TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.75.131)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = TEST)
    )
  )

 After doing this you can verify it whether this is ping or not using tnsping 

C:\Users> tnsping TEST

How To Disable/Enable Oracle Apps (EBS 11i ) Users Using API

How To Disable Oracle Apps (EBS 11i ) Users  Using API

Oracle API we can Disable Oracle Apps user Using the below API,

SQL > conn apps/apps_Password;

SQL>execfnd_user_pkg.updateuser(x_user_name=>'USER_NAME',x_owner=>'CUST',x_end_date=>SYSDATE-1);

SQL>commit;

How To Enable Oracle Apps (EBS 11i ) Users  Using API

SQL > conn apps/apps_Password;

SQL>      begin

   fnd_user_pkg.enableuser('USER_NAME', sysdate, sysdate+30);

end;

SQL>commit;

Note : where user USER_NAME is which user name you  needed to Disable or Enable.

Notification Mails are not sending to approver in Oracle Apps 11i

Notification Mails are not sending  to approver in Oracle Apps 11i

Step 1: check whether the user has selected his preference to receive his Notification Mail HTML using the below query.

SQL > sqlplus  ‘apps/apps_pwd’

SQL > SELECT * FROM FND_USER_PREFERENCES WHERE USER_NAME='USER_NAME_OF_THE _USER' AND MODULE_NAME=’WF’;

In this above query it must show preference_value=MAILHTML  , If not you need to Login to Oracle Apps after Login to Oracle Apps on top right corner click on preferenceà scroll Down à In Notifications à select mail style as HTML mail à click apply.

Step 2: Login as sysadmin and go to user management search that user name and verify his email address is associated with his Oracle ID , If not go to HRMS responsibility once again add his email ID to his ID and save.

Step 3: Login as sysadmin and request to run “synchronize wf local tables “   to synchronize all table updates

Step 4 : send some test PO’s for Approval whether he is receiving Notification mail or not  

Also check through query ,

SQL > Select * from wf_notifications  ORDER BY BEGIN_DATE DESC;

In this output MAIL_STATUS=’SENT’ means Notification mail’s are sending to that user.

SETTING UP CRON JOBS IN UNIX AND SOLARIS

SETTING UP CRON JOBS IN UNIX AND SOLARIS

Cron is a unix, solaris utility that allows tasks to be automatically run in the background at regular intervals by the cron daemon. These tasks are often termed as cron jobs in unix , solaris.  Crontab (CRON TABle) is a file which contains the schedule of cron entries to be run and at specified times.
This document covers following aspects of Unix cron jobs
1. Crontab Restrictions
2. Crontab Commands
3. Crontab file – syntax
4. Crontab Example
5. Crontab Environment
6. Disable Email
7. Generate log file for crontab activity
1. Crontab Restrictions
You can execute crontab if your name appears in the file /usr/lib/cron/cron.allow. If that file does not exist, you can use
crontab if your name does not appear in the file /usr/lib/cron/cron.deny.
If only cron.deny exists and is empty, all users can use crontab. If neither file exists, only the root user can use crontab. The allow/deny files consist of one user name per line.
2. Crontab Commands
export EDITOR=vi ;to specify a editor to open crontab file.
crontab -e    Edit your crontab file, or create one if it doesn’t already exist.
crontab -l      Display your crontab file.
crontab -r      Remove your crontab file.
crontab -v      Display the last time you edited your crontab file. (This option is only available on a few systems.)
3. Crontab file
Crontab syntax :
A crontab file has five fields for specifying day , date and time followed by the command to be run at that interval.
*     *     *   *    *        command to be executed
-     -     -   -    -
|     |     |   |    |
|     |     |   |    +----- day of week (0 - 6) (Sunday=0)
|     |     |   +------- month (1 - 12)
|     |     +--------- day of        month (1 - 31)
|     +----------- hour (0 - 23)
+------------- min (0 - 59)
* in the value field above means all legal values as in braces for that column.
The value column can have a * or a list of elements separated by commas. An element is either a number in the ranges shown above or two numbers in the range separated by a hyphen (meaning an inclusive range). Notes
A. ) Repeat pattern like /2 for every 2 minutes or /10 for every 10 minutes is not supported by all operating systems. If you try to use it and crontab complains it is probably not supported.
B.) The specification of days can be made in two fields: month day and weekday. If both are specified in an entry, they are cumulative meaning both of the entries will get executed .
4. Crontab Example
A line in crontab file like below removes the tmp files from /home/someuser/tmp each day at 6:30 PM.
30     18     *     *     *         rm /home/someuser/tmp/*
Changing the parameter values as below will cause this command to run at different time schedule below :

min	hour	day/month	month	day/week	Execution time
30	0	1	1,6,12	*	– 00:30 Hrs  on 1st of Jan, June & Dec.
0	20	*	10	1-5	–8.00 PM every weekday (Mon-Fri) only in Oct.
0	0	1,10,15	*	*	– midnight on 1st ,10th & 15th of month
5,10	0	10	*	1	– At 12.05,12.10 every Monday & on 10th of every month
:

 
Note : If you inadvertently enter the crontab command with no argument(s), do not attempt to get out with Control-d. This removes all entries in your crontab file. Instead, exit with Control-c.
5. Crontab Environment
cron invokes the command from the user’s HOME directory with the shell, (/usr/bin/sh).
cron supplies a default environment for every shell, defining:
HOME=user’s-home-directory
LOGNAME=user’s-login-id
PATH=/usr/bin:/usr/sbin:.
SHELL=/usr/bin/sh
Users who desire to have their .profile executed must explicitly do so in the crontab entry or in a script called by the entry.
6. Disable Email
By default cron jobs sends a email to the user account executing the cronjob. If this is not needed put the following command At the end of the cron job line .
>/dev/null 2>&1
7. Generate log file
To collect the cron execution execution log in a file :

30 18 * * * rm /home/someuser/tmp/* > /home/someuser/cronlogs/clean_tmp_dir.log