Collect Sales History Does Not Load Data Into Demantra Staging Tables

(Doc ID 1967300.1)

Last updated on DECEMBER 18, 2017

Applies to:

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


On : 11.1 version, JDE to Demantra Flow

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.


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

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


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