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.
There is an issue with the IMP_TRANSACTIONIMPORT.pac_imp_header_id
There could be a database sequencing issue.
Release : 15.8
Component : CA PPM APPLICATION
select * from IMP_TRANSACTIONIMPORT where importstatus = 'N'
and transdate between 'DD-MMM-YYYY' and 'DD-MMM-YYYY'
order by importdate desc
When a transaction XOG occurs, 2 tables are populated:
the groupId value set in the XOG will be propagated to
Any error found while running PTF will set
b. PAC_IMP_TRANSIMPORT_HEADER.importstatus of that particular groupId.
Any further attempts to run the PTF 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.
In order to further troubleshoot comparing this xog file to one that works might provide an answer.
Another cause would be due to issue in article: https://knowledge.broadcom.com/external/article?articleId=130919
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