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 JUNE 18, 2020
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
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!