The ODF_SS_OLD_Value & ODF_SS_NEW_VALUE fields in the CMN_AUDITS_TSV table do not get populated properly with their sliced value.

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

Description:

The current functionality does not present the end-user with the 'Audit' tab on the Cost Plan pages, therefore, through the Clarity application, only users with the proper security access rights can see Audit Trail information within the Admin Tool > Audit Trail. As such, customers wanting to create user-defined portlets looked at the Clarity database schema and found that the sliced values for the Cost Plan TSV attribute audits table is not populated as expected.

Steps to Reproduce:

  1. Enable Audit Trail for a Time-Varying Attribute (TSV)

    1. Admin Tool > Objects > Cost Plan Detail Object > Audit Trail

    2. Select some of the TSV attributes, such as planned units, planned cost for auditing on updates

  2. Create a Project Cost Plan and enter in planned units, planned costs for a few periods in the plan

  3. Edit the cost plan and change the original values to different values

  4. Query the following fields in the CMN_AUDITS_TSV table for the TSV 'sliced' value

    1. ODF_SS_OLD_VALUE (sliced old value)

    2. ODF_SSL_NEW_VALUE (sliced new value)

Expected: The BLOB field on this record should be cracked and I should see sliced values in the sliced fields
Actual: But instead, no values are populated in the sliced fields

Solution:

Workaround:

NONE.

If the fields are populated as expected, the Studio developer should be able to develop a query that retrieves the values on this table. Here is an example of a query that will be useful if these slice fields were populated as expected:

SELECT CMN_AUDITS_TSV.ID ODF_PK,
   ( SELECT VALUE 
   FROM CMN_AUDITS_TSV TI 
   WHERE CREATED_DATE=
   ( SELECT MAX(CREATED_DATE) 
         FROM CMN_AUDITS_TSV TII 
         WHERE TII.CREATED_DATE < CMN_AUDITS_TSV.
         CREATED_DATE 
         AND TII.OBJECT_CODE=CMN_AUDITS_TSV.OBJECT_CODE 
         AND TII.OBJECT_ID=CMN_AUDITS_TSV.OBJECT_ID 
         AND TII.ATTRIBUTE_CODE=CMN_AUDITS_TSV.
         ATTRIBUTE_CODE
   )
   AND TI.OBJECT_CODE=CMN_AUDITS_TSV.OBJECT_CODE 
   AND TI.OBJECT_ID=CMN_AUDITS_TSV.OBJECT_ID 
   AND TI.ATTRIBUTE_CODE=CMN_AUDITS_TSV.ATTRIBUTE_CODE
   )
   OLD_VALUE,
   CMN_AUDITS_TSV.VALUE NEW_VALUE 
   FROM CMN_AUDITS_TSV 
 WHERE CMN_AUDITS_TSV.ODF_PK = ?

-- ? The ODF_PK is the primary key of the record instance where the audit is recorded.

Status/Resolution:

CLRT-24784

Resolved in Clarity 12.0.6 Generic Patch. Reference TEC522707.
Resolved in Clarity 12.1.3, 13.0.1

Keywords: CLARITYKB, CLRT-24784