Clarity: GL Allocation XOG Causes Updates To last_updated_date Column for the Entire CBK_GL_ALLOCATION_DETAIL table

Document ID : KB000050053
Last Modified Date : 14/02/2018
Show Technical Document Details


XOG write of a single debit rule can cause the LAST_UPDATED_DATE to be updated for the entire CBK_GL_ALLOCATION_DETAIL table on V12 versions; the same problem also affects the CBK_GL_ALLOCATION table on 12.0.5 but not 12.0.6 or higher versions

Steps to Reproduce

There are some projects in the system where debit rules are set up (prior to today) with data entered in the GL Allocation in TSV area

  1. Check CBK_GL_ALLOCATION_DETAIL.LAST_UPDATED_DATE that there are some records with dates from the past

  2. Find a debit rule that has a few rows:

    chargebacks tab of the project > Debit Rules > click on a rule > click on the GL Account link > create a few rows here

    Figure 1

  3. XOG read this debit rule (see below for a sample XML)

    <?xml version="1.0" encoding="UTF-8"?>  <NikuDataBus xmlns:xsi=""  xsi:noNamespaceSchemaLocation="/niku/xog/src/webroot/WEB-INF/xog/xsd/nikuxog_read.xsd">  <Header version="8.0" action="read" objectType="glallocation" externalSource="NIKU"/>  <Query>  <Filter name="description" criteria="OR">DEBIT00001</Filter>  </Query> </NikuDataBus>
  4. Remove one of the rows from this Debit Rule from the UI, Submit

    Figure 2

  5. Verify CBK_GL_ALLOCATION_DETAIL.LAST_UPDATED_DATE that a row has been removed but the existing rows retain the old values

  6. XOG write in the debit rule allocation output from step 3 to bring back the removed row

  7. Verify from the UI that the previously removed row is now added back


Expected Result: Only the rows for the debit rule used in the above XOG has today's date.

Actual Result: All rows in the entire table CBK_GL_ALLOCATION_DETAIL has today's day updated to the LAST_UPDATED_DATE column.





Resolved in 12.1.1 Generic Patch. Reference TEC553491
Resolved in 12.1.3 Generic Patch. Reference TEC570813
Resolved in 13.1.0

Keywords: CLARITYKB, CLRT-65926, clarity12resolved, clarity13resolved, clarity1310resolved, chargebacks, investment, invoices, revmgr.