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.
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.
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