search cancel

WIP reversal transactions are showing in DWH

book

Article ID: 254941

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

An adhoc view is created from the Financial Management domain and the view is showing all the transactions which were reversed in Clarity PPM. 

The Posted Transaction Review portlet in Clarity PPM shows only the corrected transactions and not the Reversed transactions.

Cause

DWH DB is a dump of all records from the PPM database and hence if the right filters are not used, it will show all the transactions in the adhoc view irrespective of its Status.

Resolution

The field 'Transaction Status' = 0 should be used in the filter to show the non reversed WIP transaction. 

DB column: DWH_FIN_TRANSACTION"."transaction_status_flag" = 2