1-1 Fulfillment, oracle.apps.jtf.fm.engine.request.WorkNotCompletedException 'no records returned from mass query'
Last updated on SEPTEMBER 06, 2016
Applies to:Oracle One-to-One Fulfillment - Version 22.214.171.124 and later
Information in this document applies to any platform.
***Checked for relevance on 11-Nov-2013***
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:
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,
- 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.
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'.
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 hundreds of Community platforms