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 13, 2019

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 - <SCHEMA NAME>.T_SRC_SALES_TMPL
Begin Delete data from ERR table - <SCHEMA NAME>.T_SRC_SALES_TMPL_err
Analyzing Table - <SCHEMA NAME>.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.

Changes

 

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
Changes
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.