My Oracle Support Banner

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

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.