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 JANUARY 24, 2017

Applies to:

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

Symptoms

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:

ERROR
-----------------------

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.

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