Values are missing from either PPA_WIP.EXTERNALBATCHID or PRTIMEENTRY.INCIDENT_ID and PRTIMEENTRY.INCIDENT_INVESTMENT_ID so that it is not possible to query for PPA_WIP records with its origin back to the incidents that are used on timesheets.
If the option is checked from Administration, Project Management: Settings, 'Allow Effort Task Creation' :
If the 'Allow Effort Task Creation' option is NOT checked:
Steps to Reproduce:
select * from ppa_wip where project_code = 'ASSET_TWO'
-- note this is the code for the second asset
-- note you will not find this transaction from the Create WIP Adjustment page in Clarity, this is as expected because the task ID is null
Expected Result: PPA_WIP.EXTERNALBATCHID has the same value as PRTIMESHEET.PRID
Actual Result: PPA_WIP.EXTERNALBATCHID is null, there is no way to know which timesheet this transaction has come from
Caused by CLRT-73023
Our sustaining team reviewed CLRT-73023 and closed it as they are not planning to make any changes to this area of the product in the reported version.
This issue does not impact overall stock financial functionality, but without this information in the WIP tables, it cannot provide references to the incident for use in user-defined queries.
For more details please review the Customer Reported Defect Resolution Policy for CA PPM
Release: ESPCLA99000-14.2-Clarity-Extended Support Plus