When Post Timesheet job runs, it looks for timesheets which are in Approved status and will process them from timesheet tables to imp_transactionimport table(Invalid Transaction List).
But for various reasons like a Project not financially enabled or Project that is not approved and so on, the timesheet entries going into the financial module by the 'Post Timesheet' job however, the status of the timesheet is marked 'Posted'.
Even though these timesheets are in Posted status, the actuals haven't entered into the Invalid Transaction List for the Post Transaction to Financials job to process.
This will bring a lot of confusion to PMO/Application administrators and raises the alarm stating - "My timesheet is in Posted status but I don't see the actuals hours in Invalid Transaction List or waiting for Post to WIP or in WIP table."
Note: This is an initial query/portlet and can be used as an example to expand further and suggestions are welcome.