CA PPM: Transactions are not appearing in the Invalid Transactions page

Document ID : KB000007452
Last Modified Date : 17/08/2018
Show Technical Document Details
Issue:

Timesheet transactions are not appearing as financial transactions in the Administration > Invalid Transactions page in CA Project & Portfolio Management (PPM)
 

 

Cause:

In order for transactions to appear on this page, the Post Timesheets must have processed the timesheet transaction. Additionally, some other causes of this issue can be if the transactions were inadvertently deleted by a user from the Invalid Transaction list, or the timesheet related to the missing transactions was adjusted. 

Resolution:

Solution 1: Check to see that the following financial properties are fulfilled:

  • Timesheet must be in POSTED status
  • Resource track mode = PPM
  • Resource is financially active
  • Project is approved
  • Project financial status is open
Solution 2: If the above has been verified, options to fix the issue include doing a manual transaction or XOGing in missing transactions. 

Below is a query that can be used to find any timesheet hours that do not match WIP hours to help in finding discrepancies:

select ts.PRRESOURCEID resource_id, 

select SRM.UNIQUE_NAME 
from SRM_RESOURCES srm 
where SRM.ID=ts.PRRESOURCEID 
) resource_code, 

select SRM.FULL_NAME 
from SRM_RESOURCES srm 
where SRM.ID=ts.PRRESOURCEID 
) resource_name, 
ts.PRSTART ts_period, 
ts.POSTED_TIME ts_posted_time, 
ts.act_hrs ts_hrs, 
wip.wip_hrs 
from 

SELECT PRTIMESHEET.PRRESOURCEID, 
PRTIMEPERIOD.PRSTART, 
PRTIMESHEET.POSTED_TIME, 
sum(nvl(PRTIMEENTRY.PRACTSUM,0))/3600 act_hrs 
FROM PRTIMEENTRY, 
PRTIMESHEET, 
PRTIMEPERIOD 
WHERE PRTIMEENTRY.PRTIMESHEETID(+)=PRTIMESHEET.PRID 
and PRTIMESHEET.PRTIMEPERIODID=PRTIMEPERIOD.PRID 
and PRTIMEPERIOD.PRSTART>=to_date('01/02/2018','MM/DD/YYYY') 
and PRTIMESHEET.PRSTATUS=4 
and PRTIMEPERIOD.PRSTART<(select trunc((sysdate), 'DAY') from dual) 
and trunc(PRTIMESHEET.POSTED_TIME,'DD')<trunc(sysdate,'DD') 
group by PRTIMESHEET.PRRESOURCEID, 
PRTIMEPERIOD.PRSTART, 
PRTIMESHEET.POSTED_TIME 
)ts, 

select SRM.ID resource_id, 

select a.PERIOD_START_DATE 
from NBI_DIM_CALENDAR_TIME a 
where a.HIERARCHY_LEVEL='WEEK' 
and a.WEEK_KEY=cal.WEEK_KEY) PERIOD_START_DATE, 
CAL.WEEK_KEY, 
sum(PPA_WIP.QUANTITY) wip_hrs 
from PPA_WIP, 
SRM_RESOURCES srm, 
NBI_DIM_CALENDAR_TIME cal 
where PPA_WIP.TRANSDATE>=to_date('01/02/2018','MM/DD/YYYY') 
and PPA_WIP.STATUS<>2 
and PPA_WIP.TRANSDATE<=(select trunc((sysdate), 'DAY') from dual) 
and PPA_WIP.RESOURCE_CODE=SRM.UNIQUE_NAME 
and CAL.HIERARCHY_LEVEL='DAY' 
and PPA_WIP.TRANSDATE=CAL.DAY 
and PPA_WIP.SOURCEMODULE not in(52,53) 
group by SRM.ID, 
CAL.WEEK_KEY 
) wip 
where ts.PRRESOURCEID=wip.resource_id(+) 
and ts.PRSTART=wip.PERIOD_START_DATE(+) 
and ts.act_hrs != wip.wip_hrs ; 
Additional Information:

https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec466919.html
Financial Transactions in Invalid Transaction Log shows a rejected message with the reason 'no rate was found for this transaction'  

https://support.ca.com/irj/portal/kbtech?docid=483363&searchID=TEC483363 
How do I resolve the rejected reason 'Invalid Entity Location' message?