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.
Clarity
There is an issue with the IMP_TRANSACTIONIMPORT.pac_imp_header_id
or a rate matrix issue.
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.
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