TCC: A LUDS Net-Change Sends Updates For All Records Instead Of Just Changed Ones (Doc ID 2277008.1)

Last updated on JANUARY 06, 2023

Applies to:

Symptoms

A UDSElement Net-Change sends empty updates for all the records instead of just for records that have changed.

Looking in TCC console, it is seen that only the lookup key is passed in the Request xml.  For example:
---------------------
<UDSElement-update identifier="UDSElement|update|<VALUE 1>,<VALUE2>">
<UDSElement>
<Code searchType="search" searchValue="<VALUE 1"/>
<UserDefinedSelection>
<UserDefinedSelection>
<Code searchType="search" searchTarget=".." searchValue="<VALUE 2"/>
</UserDefinedSelection>
</UserDefinedSelection>
</UDSElement>
</UDSElement-update>
---------------------

Changes

The net-change import uses the same field twice as expected.  

• One instance of the UserDefinedSelection,Code targets UserDefinedSelection
• The other instance targets UDSElement.

The script with the problem has the instance that targets UDSElement before the instance of the field that targets UserDefinedSelection.

Cause

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