Collect Sales History Does Not Load Data Into Demantra Staging Tables (Doc ID 1967300.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Value Chain Planning Integration Base Pack - Version 11.1 and later
Information in this document applies to any platform.

Symptoms

On : 11.1 version, JDE to Demantra Flow

ACTUAL BEHAVIOR
---------------
Demantra staging tables data issue

Customer applied the official patch in Stage (Patch: 20024975 - JDE-VCP ONE-OFF PIP FIXES PATCH) and tried to run collect sales history which completed, but we do not see any data getting into Demantra staging tables.

Reverting the ODI files from backup did not work either and bouncing the PIP server did not help.

t_src_loc_tmpl, t_src_item_tmpl and t_src_sales_tmpl do not have data and the DemHistory.dat file has null values.
 

EXPECTED BEHAVIOR
-----------------------

Expect Collect Sales History to load data into the Demantra staging tables



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Collect Sales History
 

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