API PROCESS_BOM - How To Clean Up Attributes (Doc ID 1589034.1)

Last updated on SEPTEMBER 30, 2021

Applies to:

Goal

In 12.1.3

API PROCESS_BOM - How to clear attributes

Using the API call PROCESS_BOM in order to create and maintain BOMs

in the EBS. This works just fine except clearing attributes once they have been filled.

Using the Oracle Forms UI, you can enter attributes (e. g. MINIMUM_ALLOWED_QUANTITY or MAXIMUM_ALLOWED_QUANTITY sitting on the BOM line) and you can also delete them again. As a result, the attributes shows up as null in the database. How can this be done using PROCESS_BOM ?

Had the same problem with the Item API call PROCESS_ITEM and found out that this API call behaves like this:
Sending null for such a value will clean it in the DB, sending the default value like G_MISS_CHAR, G_MISS_DATE... will leave the value as it is.
As this option does not work for PROCESS_BOM,  how can archive the same with for this API call.

Also read about the option to send a "!" sign but it did not solve this issue.

Do have the same problem with EngineeringChangeOrder objects using PROCESS_ECO.

This ECO side issue is currently worked trough <bug 17275108> API PROCESS_ECO - How to clean attributes.
 

Solution

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