My Oracle Support Banner

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

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