Last updated on MARCH 08, 2017
Applies to:Oracle Bills of Material - Version 12.1.3 and later
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms