Customer Data Not Populated Into Demantra Tables On Running Standard Data Collections, Collect Shipment and Booking History (Doc ID 471824.1)

Last updated on AUGUST 17, 2022

Applies to:

Symptoms

On 7.1.1 in Production:
Find On an integrated EBS-Demantra instance, the Customer Data (Customer Name, Customer Number,
Site, Account, etc.) is not getting populated into Demantra tables after running the Data Collections (both Standard Data Collections and Collect Shipment and Booking History). This data is available on ODS in Collected Data on the ASCP side (Standard Data Collections puts the data into the MSC_*** tables so this part of the process is working fine).



STEPS
The issue can be reproduced at will with the following steps:
1. Go to responsibility Demand Management System Administrator > Collections > Oracle Systems
> Standard Collection. A 'Complete Refresh' or 'Target Refresh' can be chosen. (making the
parameter 'SUPPLIERS/ Customers/ Orgs' to 'Yes')
then,
2. Go to responsibility Demand Management System Administrator > Collections > Oracle Systems
> Shipment and Booking History

3. For checking the collected data:
Go to Advanced Supply Chain Planner responsibility > Collections > View Collected Data

Also, it has been verified from the backend that data has not been updated in t_src_sales_tmpl,
t_src_loc_tmpl, t_ep_item, t_ep_organization and t_ep_ebs_customer tables

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.