Post Transactions to Financials Job Not Processing New Transactions

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

There are transactions in the 'New' status in Administration > Invalid Transactions page that are not being picked up by the Post Transactions to Financials job.

Environment

Clarity 

Cause

There is an issue with the IMP_TRANSACTIONIMPORT.pac_imp_header_id
or a rate matrix issue.

Resolution

Run the following query:
select * from IMP_TRANSACTIONIMPORT where importstatus = 'N'
and transdate between 'DD-MMM-YYYY' and 'DD-MMM-YYYY'
order by importdate desc

Review the table PAC_IMP_TRANSIMPORT_HEADER

When a transaction XOG occurs, 2 tables are populated:
a. IMP_TRANSACTIONIMPORT
b. PAC_IMP_TRANSIMPORT_HEADER

the groupId value set in the XOG will be propagated to
a. PAC_IMP_TRANSIMPORT_HEADER.id
b. IMP_TRANSACTIONIMPORT.pac_imp_header_id

Any error found while running PTF will set
a. PAC_IMP_TRANSIMPORT_HEADER.errorcode
b. PAC_IMP_TRANSIMPORT_HEADER.importstatus of that particular groupId.

Any further attempts to run the Post Transactions to Financials job, the script looks at each groupId
and its corresponding PAC_IMP_TRANSIMPORT_HEADER.errorcode and will not process any of the transactions with the same groupId from IMP_TRANSACTIONIMPORT.
This is the reason we are still seeing the "New Transaction" status even after running PTF job.

 

Additional Information

The rate matrix configuration could also be the cause of the issue.

1. Go to the Administration > Finance > Manage Matrix page
2. Select the matrix
3. Use the filter to check the resource or property needing to be validated for a matching rate.

If one does not exist, add a catchall row, a row denoted by selecting all * asterisks for the value.

4. Run the Post Transactions to Financials job.
Lastly also ensure there is an appropriate foreign exchange defined for the project currency if this is different from Home Currency defined in the Entity setup