My Oracle Support Banner

EGO_ITEM_PUB.PROCESS_ITEMS API Is Updating The LAST_UPDATE_DATE Of All Organization Items When Master Item Attribute is Updated (Doc ID 1621447.1)

Last updated on APRIL 18, 2023

Applies to:

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

Symptoms

On : 11.5.10.2 version, Catalog items

Actual Behavior
When using the EGO_ITEM_PUB.PROCESS_ITEMS API to update processing lead times in all of their organizations.
When running the API for just the Master org the API updates the LAST_UPDATE_DATE on all the inventory items
with the same inventory_item_id even though we only updated the MASTER ORG LEAD times.

However, when we run the API for any org besides the Master org it updates the individual organization record correctly.

Expected Behavior
Expect only the Master org last update date should be updated.

Steps
The issue can be reproduced at will with the following steps:
1. Launch EGO_ITEM_PUB.PROCESS ITEMS to update item attribute in master org.

Changes

 None

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.