BOM Import Program BMCOIN - Bill And Routing Interface Nulls Out specific_assembly_comment (Bill Details)

(Doc ID 1994866.1)

Last updated on DECEMBER 01, 2016

Applies to:

Oracle Bills of Material - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

You are using the BMCOIN program to nullify a value in the Material Control Tab in the BOM form.
When you are running BOM Import program, you have not explicitly mentioned any value for column SPECIFIC_ASSEMBLY_COMMENT (which in the BOM form reflects as "Bill Details").
But after running import, you see the value for Bill Details has been removed.

EXPECTED BEHAVIOR

The value for column SPECIFIC_ASSEMBLY_COMMENT shouldn't be removed.

STEPS

The issue can be reproduced at will with the following steps:

  1. Load data into interface table, setting only those field you want to update.
  2. Run the program
  3. Value are updated properly but values of the field SPECIFIC_ASSEMBLY_COMMENT are removed, even though you have not explicitly passed any to interface.

Changes

 

Cause

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