Incomplete Data in the Demantra t_src_sales_tmpl table after running Shipment And Booking Collection from EBS (Doc ID 749245.1)

Last updated on APRIL 21, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 21-Apr-2016***


Symptoms

On 7.1.1 in Production:
Not all of the Data from the EBS Transactional/OM table (apps.oe_order_lines_all) was getting
populated in the Demantra staging table (demantra(msd_dem).t_src_sales_tmpl)

EXPECTED BEHAVIOR
Expect all data, for qualified order types, to be transferred from EBS to Demantra

STEPS
The issue can be reproduced at will with the following steps:
1. Launched Shipment and Booking History for Demantra with the following parameters:
Complete Refresh
Collect All Types of Orders


.

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