My Oracle Support Banner

Mails are not Received Using Delivery Option while Submitting Concurrent Request In R12.1.3 (Doc ID 1339491.1)

Last updated on APRIL 25, 2018

Applies to:

Oracle Concurrent Processing - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms


Using the Delivery Options feature available in R12.1.3 version, the output of the concurrent request is not being delivered from email.

The concurrent program delivery options are not working through Delivery Options for Email Notification.

When a request is submitted and the Delivery Options button is selected for sending an Email Notification, there is neither an error (in the FNDCPOPP log or REQUEST log files) nor is the email sent.

 
The Internal Concurrent Manager log file was showing the following errors:

Internal Concurrent Manager started : 13-JUL-2011 14:11:37

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

Process monitor session started : 13-JUL-2011 14:11:37
CONC-SM TNS FAIL
Call to PingProcess failed for FNDCPGSC
CONC-SM TNS FAIL
Call to StopProcess failed for FNDCPGSC
CONC-SM TNS FAIL
Call to PingProcess failed for FNDCPGSC
CONC-SM TNS FAIL
Call to StopProcess failed for FNDCPGSC
CONC-SM TNS FAIL
Call to PingProcess failed for FNDCPGSC
CONC-SM TNS FAIL
Call to StopProcess failed for FNDCPGSC
CONC-SM TNS FAIL
Call to PingProcess failed for FNDOPP
CONC-SM TNS FAIL
Call to StopProcess failed for FNDOPP
  

After the request completed normally, the email notification sending part was failing as the TNS ping failed.

+++++++++++++++++++++++++++++++++++++++++++++++

The following sample request log file extract displays an entry of the DELIVER option to the respective email id that should be seen:-
+------------- 2) DELIVER -------------+
Emailing output to xxx.yyy@oracle.com
Beginning post-processing of request 5904473 on node ZZZZZ at 05-JUL-2011 16:21:45.
Post-processing of request 5904473 completed at 05-JUL-2011 16:23:03.
+--------------------------------------+


Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 05-JUL-2011 16:23:03

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

The sample FNDCPOPP manager log file shown below, consists the following details for a successful email notification delivery:
[5/19/11 10:01:21 PM] [main] Starting GSF service with concurrent process id = 2047653.
[5/19/11 10:01:21 PM] [main] Initialization Parameters: oracle.apps.fnd.cp.opp.OPPServiceThread:2:0:max_threads=5
[5/19/11 10:01:21 PM] [Thread-19] Service thread starting up.
[5/19/11 10:01:21 PM] [Thread-20] Service thread starting up.
[7/5/11 4:21:47 PM] [OPPServiceThread0] Post-processing request 5904473.
[7/5/11 4:21:47 PM] [2047653:RT5904473] Executing post-processing actions for request 5904473.
[7/5/11 4:21:48 PM] [2047653:RT5904473] CONC-OPP-DELIV BEGIN (REQID=5904473)
[7/5/11 4:21:48 PM] [2047653:RT5904473] Beginning email delivery
[7/5/11 4:23:03 PM] [2047653:RT5904473] Completed post-processing actions for request 5904473.
[7/5/11 4:36:09 PM] [OPPServiceThread0] Post-processing request 5904477.
 

Whereas in the case where an issue exists the respective log files show the following:

+-----------------------------
| Starting concurrent program execution...
+-----------------------------

+---------------------------------------------------------------------------+
Executing request completion options...

+------------- 1) PUBLISH -------------+
Beginning post-processing of request 433207 on node XXXXX at 08-JUL-2011 16:08:01.
Post-processing of request 433207 completed at 08-JUL-2011 16:08:02.
+--------------------------------------+

+------------- 2) PRINT -------------+


Printing output file.
Request ID : 433207
Number of copies : 0
Printer : noprint

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

+------------- 3) insert into FND_ENV_CONTEXT -------------+
+--------------------------------------+


Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 08-JUL-2011 16:08:02

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

The FNDCPOPP manager log file was not showing any errors even though the mail was not sent, since the issue was with the TNS ping.
[7/8/11 4:08:01 PM] [OPPServiceThread1] Post-processing request 433207.
[7/8/11 4:08:01 PM] [18924:RT433207] Executing post-processing actions for request 433207.
[7/8/11 4:08:01 PM] [18924:RT433207] Starting XML Publisher post-processing action.
[7/8/11 4:08:01 PM] [18924:RT433207]
Template code: XX
Template app: XX
Language: en
Territory: 00
Output type: EXCEL
[7/8/11 4:08:02 PM] [18924:RT433207] XML Publisher post-processing action complete.
[7/8/11 4:08:02 PM] [18924:RT433207] CONC-OPP-DELIV BEGIN (REQID=433207)
[7/8/11 4:08:02 PM] [18924:RT433207] Beginning email delivery
[7/8/11 4:08:02 PM] [18924:RT433207] Completed post-processing actions for request 433207.
 
 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.