Using BOM_BO_Pub.Process_BOM API Cannot Create Product Family Bills Or Add Members That Are Dual Unit Of Measure Controlled (Doc ID 1663732.1)

Last updated on DECEMBER 09, 2024

Applies to:

Symptoms

Coded PL/SQL to invoke "bom_bo_pub.process_bom" API - Product Family Bills wrapper , need this working for all 3 cases - CREATE / UPDATE / DELETE

ERROR
-----------------------
1. When creating Product family bills - The Bill cannot contain items tracked in two quantities. (BOM_DUAL_UOM_ITEMS) - This should not be raised for Product Family bills, as we can do this from front-end form. Can add both header and members.
2. When updating Product family bills - "An error occured while processing business object" - Looks like update is not supported.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create product family bill using API for Dual UOM header and Dual UOM members.
2. Update product family bill - Add new member, or Update Allocation Percentage

WHAT IS WORKING
-----------------------
Works fine from forms (Material Planner -> Setup -> Product Family Bills), but API gives error for both cases.

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.