Columns Last Update Id, Last_update_datetime Are Not Changed Upon Changing Dim_type Of An Item. (Doc ID 3071696.1)

Last updated on FEBRUARY 11, 2025

Applies to:

Symptoms

ERROR
-----------------------

Columns Last update id, last_update_datetime are not changed upon changing dim_type of an item.

Columns Last update id, last_update_datetime are not changed upon changing dim_type (Package_tpye in RMS UI) of an item in the RMS.ITEM_SUPP_COUNTRY_DIM table.
But it gets updated in ITEM_SUPP_COUNTRY table for an item and supplier.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Tasks-->Item-->Manage Item-
2.>Search for item-->More Action-->Supplier--
3. chose a supplier-->Country Of sourcing--->Dimensions-->Edit-
4.Change the Package type-->save and close

Changes

Cause

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