My Oracle Support Banner

1-1 Fulfillment, oracle.apps.jtf.fm.engine.request.WorkNotCompletedException 'no records returned from mass query' (Doc ID 1273039.1)

Last updated on AUGUST 24, 2018

Applies to:

Oracle One-to-One Fulfillment - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 11-Nov-2013***

Symptoms

When trying to send mass emails via Oracle Marketing the 1-1 Fulfillment Server requests remain 'In Progress'. We would expect the requests to go to a status of 'Successful'.

The Following error is noted in the Errors.log file:

(r11640.0:p0)
Time : --Thu Nov 18 13:40:27 GMT 2010--3 seconds, 294 milliseconds--
Note : unable to process batch segments
oracle.apps.jtf.fm.engine.request.WorkNotCompletedException: request '11640'; no records returned from mass query > SELECT e.event_offer_name event_name,
TO_CHAR(e.event_start_date,'DD-MON-YYYY') start_date,
TO_CHAR(e.event_end_date,'DD-MON-YYYY') end_date,

 

Note:

  • When sending a test email for a cover letter is sent this goes through successfully.
  • When running the above sql from a sqlplus session on the 1-1 Fulfillment Server a record is returned.




Steps

The issue can be reproduced at will with the following steps:

1 Generate a Mass 1-1 Fulfillment Request through Oracle Marketing Online.

<Document 1267609.1> How to test 1-1 Fulfillment Server with Oracle Marketing Online Event Registration

2 Oracle Marketing Super User-> Administration -> Fulfillment -> History
    The request summary for the email has been triggered but stays in status  'In Progress'.

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!


In this Document
Symptoms
Cause
Solution
References


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