Error In Staging Table Msc_St_Bom_Components - msc_pp_date_overlap (Doc ID 2169368.1)

Last updated on MARCH 08, 2017

Applies to:

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

Goal

12.2.4.1


PROBLEM
-------------
Error in Staging Table msc_pp_date_overlap in msc_st_bom_components

Problem Description
---------------------------------------------------
BOM component data is getting extracted from JD Edwards to Oracle VCP.
The client has changed the BOM effectivity dates in JDE after first extraction and collection.
Now during collection client is getting the following error in the staging table:

ERROR
-----------------------
MSC_PP_DATE_OVERLAP.

Appears similar to Bug 19641871

WHY ARE THE DATES CHANGED?

It was a business decision to set the start same as the legacy system.
i.e. moved all start dates from original dates to system date for this run of collections
 

Solution

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