My Oracle Support Banner

1-1 Fulfillment, 'no records returned from mass query' (Doc ID 1273039.1)

Last updated on AUGUST 24, 2018

Applies to:

Oracle One-to-One Fulfillment - Version 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 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,



  • 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'.


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

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