Clarity PPM: Duplicate Transactions Created in WIP tables

Document ID : KB000122832
Last Modified Date : 11/12/2018
Show Technical Document Details
Issue:

There are duplicate transactions observed in the following Clarity pages:
1. Home > Financial Management > Transactions
2. Home > Financial Management > Posted Transactions Review 

Cause:

The root cause is unknown, however when reported it is likely due to an environmental issue which may involve one or more of the following symptoms:
1. Multicast issue
2. Disruption in the background service

Resolution:

Run the following query to determine how widespread the issue is:

Please complete and run the following SQL
NOTE: Export the results to an .XLS file with column header names.

Be sure to fill out the date range of the transactions.
===========================================================
select 
w.externaltransno, w.external_id, W.APPLYTO, W.TRANSNO, 
W.SOURCEMODULE, W.EXTERNALBATCHID, W.TRANSTYPE, 
W.TRANSDATE, W.ENTRYDATE, W.STATUS, W.QUANTITY, WV.BILLRATE, 
WV.totalcost t_actualcost, WV.AMOUNT t_revenue, WV.PRICE, WV.AMOUNTREMAINING, 
W.GLPOSTED, W.PROJECT_CODE, W.RESOURCE_CODE, W.TASK_ID, W.ROLE_CODE, 
W.CHARGE_CODE, WV.CURRENCY_CODE, W.USER_LOV1
from 
PPA_WIP W,
PPA_WIP_VALUES WV 
WHERE W.TRANSNO = WV.TRANSNO 
and WV.CURRENCY_TYPE = 'HOME' 
and W.TRANSDATE between TO_DATE('XX-MON-YYYY', 'DD-MON-YYYY') and TO_DATE('XX-MON-YYYY', 'DD-MON-YYYY')
order by w.transno

Please ZIP the file and contact the Support team to upload the files.

If there are confirmed duplicates, there is an 18-step procedure to have it corrected and the steps will be provided by the Support team.