SPP Collection MSDDEMRH: Collect Returns History Fails With 'msd_dem_collect_return_history.collect_return_history_data ORA-00942'
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.
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:
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms