My Oracle Support Banner

Replace Children (RC) Transaction Code Does Not Delete All Child Data Corresponding to the Top Level Parent (Doc ID 2672481.1)

Last updated on MAY 20, 2020

Applies to:

Oracle Transportation Management Cloud Service - Version 6.3.4 and later
Oracle Transportation Management - Version 6.4.3 and later
Oracle Trade Compliance Cloud Service - Version 6.3.4 and later
Oracle Customs Management Cloud Service - Version 6.3.4 and later
Oracle Global Trade Management Cloud Service - Version 6.3.4 and later
Information in this document applies to any platform.

Symptoms

According to the Integration Guide, you expect to see a delete query for every child data and insert query for child data in the update XML, but the application only deletes the removed child data.

RC: Replace Children. Use this transaction code to delete all child data corresponding to the top level parent, update the top level parent, and insert the new child data.

 

EXAMPLE (This is just an example, but the same applies to all other OTM/GTM objects):
---------------------------------------------------------------------------------------------

GtmTransaction XML update using 'RC' Transaction Code does not delete the existing GtmTransactionLine(s), only deletes the removed lines.


01. Created GTM Transaction (TR) with the following two lines using 'IU' Transaction Code.

Lines:
TRL1
TRL2

02. Updated the GTM Transaction (TR) with the following Lines using 'RC' Transaction Code.

Lines:
TRL1
TRL3

In the logfile.

No delete statement for TRL1 (existing). Only for TRL2 (removed).

Debug Sql delete from gtm_transaction_line where gtm_transaction_line_gid=?; [XXX.TRL2]

You expect the application to delete all the lines and insert whatever lines in the XML update as you are using 'RC' Transaction Code.



Changes

 

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.