My Oracle Support Banner

IMPORT SEGMENT VALUES IS CHANGING LAST_UPDATE_DATE EVEN WHEN NO UPDATES WERE DONE TO THE SEGMENT VALUES (Doc ID 2783285.1)

Last updated on AUGUST 29, 2023

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.13.21.04.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.21.01.0 version, Setup, Rapid Impl and Security

ACTUAL BEHAVIOR
---------------
When importing Segment Values and Hierarchies on a daily basis via schedule process 'Load interface file for import', as the customer has EDMCS to store and maintain value sets and hierarchies, the program is updating the last updated by and last update date for all values even though there is no change for it.


EXPECTED BEHAVIOR
-----------------------
The fields last updated by and last update date should be change only if there was a change for it.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Have EDMCS to store and maintain value sets and hierarchies
2. Have the process 'Load interface file for import' scheduled daily to extracts an update Fusion
3. The process launches also import Segment Values and Hierarchies


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


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