My Oracle Support Banner

BOM_STRUCTURES_B.EFFECTIVITY_CONTROL Is Set to Null in SNAPSHOTS BILLS Generated by Supply Chain Cost Rollup - No Report Prgram (Doc ID 2480888.1)

Last updated on AUGUST 27, 2023

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.


Actual Behavior
In the Snapshots Bills generated by Supply Chain Cost Rollup - No Report prgram, the BOM_STRUCTURES_B.EFFECTIVITY_CONTROL is set to null.

Normally, BOM_STRUCTURES_B.EFFECTIVITY_CONTROL should be set as NOT NULL in BOM function. It is always taken over from MTL_SYSTEM_ITEMS.EFFECTIVITY_CONTROL.

Expected Behavior
Supply Chain Cost Rollup programs should create the Snapshots Bills with setting correct value to BOM_STRUCTURES_B.EFFECTIVITY_CONTROL.

Steps to Reproduce

  1. Define a cost type as the Snapshots Bills as Yes and enter the value of something Alternate in Rollup Option.
  2. Define an assembly item and BOM
  3. Run Supply Chain Cost Rollup - No Report for the cost type and item.
  4. EFFECTIVITY_CONTROL is set to null in BOM_STRUCTURES_B record of the Alternate created by the Supply Chain Cost Rollup.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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