Unable To Update Process_execution_enabled_flag In Mtl_system_items_b Using API ego_item_pub.process_items
Last updated on MARCH 08, 2017
Applies to:Oracle Product Hub - Version 12.2.5 and later
Information in this document applies to any platform.
On : 12.2.5 version, Catalog items
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.
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.
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"
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms