New Transactions Are Not Processed in the Invalid Transactions Page

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

There are Invalid Transactions with Message/Status = 'New Transaction' that are not being processed by the Post Transaction to Financials job.

 

Resolution

Run the following query to find out how widespread the issue is:

select * from IMP_TRANSACTIONIMPORT
where  importstatus = 'N'
and pac_imp_header_id != 0

An update to set pac_imp_header_id = 0 would be needed to have the transactions go through.