Can Transactions From PPA_transcontrol / PPA_transcontrol_values Be Deleted?
search cancel

Can Transactions From PPA_transcontrol / PPA_transcontrol_values Be Deleted?

book

Article ID: 261659

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

There are transactions that are ready to processed by the POST TO WIP job, found by navigating to
Classic UI > Home Menu >  Financial Management   > Transaction Entry

They are manual transactions (Voucher - Expense) and (Voucher - Other)

The project is closed and these transaction are not needed.
Can we delete them?

 

Environment

Release : All supported releases

Resolution

Yes, they are safe to delete from the UI.

The following queries can be used to analyze:

--a
select * from PPA_TRANSCONTROLAPINFO

--b
select a.ppa_transcontrolapinfo_id, a.*
from
PPA_TRANSCONTROL a,
PPA_TRANSCONTROL_VALUES b,
PPA_TRANSCONTROLAPINFO c
where a.transno = b.transno
and c.id = a.ppa_transcontrolapinfo_id