My Oracle Support Banner

How WIP Job Explodes Effective Components When BOM Is Defined With Overlapped Periods? (Doc ID 2377800.1)

Last updated on MARCH 25, 2018

Applies to:

Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

BOM is defined as disable date of previous row overlaps effective date of next row. Which component is selected when Job is created with start date 2018-05-01 00:00:00?

Case1:

Assembly Item A
+--- Component A -- From=2018-01-01 00:00:00 - To=2018-05-01 00:00:00
+--- Component B -- From=2018-05-01 00:00:00 - To=NULL

Case2:

Assembly Item A
+--- Component A -- From=2018-01-01 00:00:00 - To=2018-05-01 00:00:00
+--- Component B -- From=2018-05-01 00:00:00 - To=2018-05-01 00:00:00
+--- Component C -- From=2018-05-01 00:00:00 - To=NULL
 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.