My Oracle Support Banner

ORA-01403: No Data Found Error When Running Shipment And Booking History Collection from EBS to Demantra (Doc ID 785994.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Demantra Demand Management - Version and later
Information in this document applies to any platform.
This problem can occur on any platform.

***Checked for relevance on 06-Jan-2014***


When running Collections to load data into the Demantra application the following error is observed in the Collect Bookings and Shipment History job

MSDDEMCHD module: Collect Shipment and Booking History

Current system time is 06-JAN-2009 05:10:53


**Starts**06-JAN-2009 05:10:53
**Ends**06-JAN-2009 05:14:06
ORA-01403: no data found
Start of log messages from FND_FILE
 Collect History Data - Actions
Date From (DD/MM/RRRR) - 01/01/1000
Date To (DD/MM/RRRR)   - 31/12/4000
Deleting data from sales staging table - DM_CRP1.T_SRC_SALES_TMPL
Begin Delete data from ERR table - DM_CRP1.T_SRC_SALES_TMPL_err
Analyzing Table - DM_CRP1.T_SRC_SALES_TMPL
Warning: can not purge old shipment/booking history data.

The issue can be reproduced at will with the following steps:
1. Run Collect Shipment and Bookings History

The issue has the following business impact:

Due to this issue, users cannot run Collections to load data into the Demantra application.


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.