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

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

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