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 AUGUST 09, 2017

Applies to:

Oracle Bills of Material - Version 12.1.3 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms