My Oracle Support Banner

Getting Duplicate Component Records in Bills of Material Form (BOMFDBOM) For Common Bills When Updating Bill Header Descriptive Flexfield Segment(s) (Doc ID 1369659.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Bills of Material - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
Form:BOMFDBOM.FMB - Define Bill of Material


Symptoms

When updating an header level descriptive flexfield (DFF) segment value in Define Bills of Material form (BOMFDBOM), the following decision message is raised and when the user confirms (by clicking Yes), then components get duplicated, ie each component appears twice in Components block.

DFF name is "Bill of Material Information".

The problem occurs with common bills in child / subordinate organizations.
The problem does not occur when the user does not update the header level DFF segment value.

Expectation
Component records should not be replicated.

Message
In the Decision message box:
"This BOM is common. New components can be added only in the source BOM. You can edit select attributes on this BOM, though. Would you like to edit any of the material control attributes?"

Steps
1. Open at least one segment in "Bill of Material Information" DFF, set it as displayed and not required.
2. Create a bill of material in the master organization with two components.
Do not populate the DFF at bill header level
Save
3. Common the bill to a hierarchy or to a specific organization.
Uncheck "Enable attributes update"
4. Change organization to this organization. (or to a subordinate organization)
5. Query the bill.
Click on Material Control tab
Go to components block
See a Decision message pops up as below:
"This BOM is common. New components can be added only in the source BOM. You can edit select attributes on this BOM, though. Would you like to edit any of the material control attributes?"
Click Yes
See the message "FRM-40401: No changes to save" at the bottom
See two component records are shown
See attributes Supply Type, Subinventory, Locator are editable
6. Requery the bill
See again two component records are shown
7. Update the DFF at header level, set it to any valid value
Save
See message "FRM-40400: Transaction complete: 1 records applied and saved" at the bottom
Click on Material Control tab
Go to components block
See the Decision message pops up again
Click Yes
See the message "FRM-40401: No changes to save" at the bottom
See four records are now shown in Components block as if the two components got replicated including Operation Seq field

Business impact
Due to this issue, users are getting confused with Common BOM feature.

Cause

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
Symptoms
Cause
Solution
 A. Datafix
 B. Patch
References


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