My Oracle Support Banner

SPP Collection MSDDEMRH: Collect Returns History Fails With 'msd_dem_collect_return_history.collect_return_history_data ORA-00942' (Doc ID 2129522.1)

Last updated on FEBRUARY 06, 2019

Applies to:

Oracle Service Parts Planning - Version 12.2.5 and later
Information in this document applies to any platform.


On 12.2.5 Using Oracle Service Parts Planning / Collections
When attempting to run Product Return History (MSDDEMRH: Collect Returns History)
the following error occurs:


Collect History Data - Actions
Exception: msd_dem_collect_return_history.collect_return_history_data - 04-MAR-2016 13:34:47
ORA-00942: table or view does not exist

-- Steps To Reproduce:

Customer states the issue can be reproduced at will at customer site with the following steps:
1. (R) Service Supply Chain Planner
2. (N) Collections / Oracle Systems / Product Return History
3. Parameters:
 Instance: DEV
 Collection Group: ALL
 Collection Method: Complete
 All others are left blank
4. Inspect the log for the MSDDEMRH: Collect Returns History request
5. Observe the noted error.


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.