My Oracle Support Banner

How to Create a Bill of Material (BOM) using Bom_Bo_Pub.Process_Bom API [Video] ? (Doc ID 1242665.1)

Last updated on APRIL 24, 2019

Applies to:

Oracle Bills of Material - Version 12.0 to 12.1.2 [Release 12 to 12.1]
Information in this document applies to any platform.

Goal

The purpose of this document is to provide a demonstration showing how Bills of Material (BOMs)  can be created using APIs. The demonstration uses the BOM_BO_PUB.PROCESS_BOM API to create bill header and add components to the bill.
The attached viewlet will walk the user through creating the PL/SQL Procedure for creating Bills using API. There is also a document which has sample code for test purposes.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 1. Sample Code and Demo
 2. Troubleshooting
 1. Why do we see the error - "All records in a business object must belong to the same Bill. That is, they must all have the same Assembly Item Name, Organization and Alternate Designator. Please check your records for this." (BOM_MUST_BE_IN_SAME_BOM)
 2. When running the BOM_BO_PUB.Process_BOM API for multiple bills, it runs correctly the first time, but, errors for the other bills ?
 3. API runs successfully, when trying to delete a bill, but, the Bill is still present in the system
 4. How to create a commoned bill using the Bom_Bo_Pub.Process_Bom API ?
 5. How to create a alternate bill using the Bom_Bo_Pub.Process_Bom API ?
 6.How to delete a component alone using the Bom_Bo_Pub.Process_Bom API ?
 7. How to delete a bill using the Bom_Bo_Pub.Process_Bom API ?
 8. Error - You cannot update or delete component &component since it does not exist for item &assembly     
 9. How to update supply subinventory and supply locator to NULL using the BOM_BO_PUB.Process_BOM API ?
 10. How to add substitute components to a Bill using the BOM_BO_PUB.Process_BOM API ?
 11. How to get debug log or trace for reviewing BOM API errors ?
 3. Test your knowledge
References

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