ORA-01403: No Data Found Error When Running Shipment And Booking History Collection from EBS to Demantra

(Doc ID 785994.1)

Last updated on JANUARY 06, 2014

Applies to:

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

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

Symptoms


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.

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

BUSINESS IMPACT
The issue has the following business impact:

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

Cause

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