Unable To Update Process_execution_enabled_flag In Mtl_system_items_b Using API ego_item_pub.process_items
(Doc ID 2192376.1)
Last updated on FEBRUARY 03, 2019
Oracle Product Hub - Version 12.2.5 and later Information in this document applies to any platform.
On : 12.2.5 version, Catalog items
ACTUAL BEHAVIOR --------------- While attempting to update process_execution_enabled_flag in in mtl_system_items_b table, using API ego_item_pub.process_items, there were no error messages, and all the records in the mtl_system_items_interface were removed, the attribute is not updated, but the system says Successful.
EXPECTED BEHAVIOR ----------------------- When attempting to update the process_execution_enabled_flag from 'N' to 'Y" and chose an inventory item whose inventory_item_flag = 'N', the normal Oracle screen interface does not allow the user to change a process_execution_enabled_flag from 'N' to 'Y' if the inventory_item_flag = 'N'. When run a script to update such an item, it SHOULD fail because it's not allowed. However, the return code is SUCCESS, but yet the process_execution_enabled_flag is NOT updated. The API did the correct procedure by NOT updating it, but no error message was presented. The return code should not have been SUCCESS.
STEPS ----------------------- The issue can be reproduced at will with the following steps: 1. Run API ego_item_pub.process_items to update process_execution_enabled_flag from 'N' to 'Y" and chose an inventory item whose inventory_item_flag = 'N"
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!