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

Last updated on JULY 05, 2018

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

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

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