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 MARCH 08, 2017

Applies to:

Oracle Product Hub - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

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"


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