Product Return History Collection Program Is Erring Out with 'Unable to Find The Return History Staging Tables' (Doc ID 2025429.1)

Last updated on APRIL 25, 2017

Applies to:

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

Symptoms

VCP 12.1.3.9.1 <Patch 17350769>
Centralized install

PROBLEM
-------------
Cannot collect returns history for SPP
Using Service Parts Planning module to generate in-line forecast. Users are trying to collect Return Material Authorization (RMA) history for returns to perform return forecasting.
Users are using oracle order management functionality for RMAs.

MSDDEMRH - Collect Returns History
+---------------------------------------------------------------------------+
Current system time is 29-APR-2015 02:13:08
+---------------------------------------------------------------------------+
**Starts**29-APR-2015 02:13:08
**Ends**29-APR-2015 02:13:11
Unable to find the return history staging tables.


STEPS
--------
Run process with parameters
Instance - TST
coll Group - ALL
collection method - complete
date range - Rolling
history collection window - 365
Date from - NULL
Date to - NULL

EXPECTED BEHAVIOR
----------------------------
Concurrent request completes successfully

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