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

Last updated on APRIL 03, 2023

Applies to:

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

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