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 MARCH 05, 2018

Applies to:

Oracle Demantra Demand Management - Version 7.1.1 and later
Information in this document applies to any platform.


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)

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

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





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