Run the following queries to check for orphans in the tables or incorrect ratio of records (PPM SaaS customers, please contact CA Technical Support for assistance)
Orphan PPA_WIP record: The following query will show any record that is in PPA_WIP table, but no matching records in the PPA_WIP_VALUES table. No results indicate no problem.
from ppa_wip wip
where wip.transno not in (select transno from ppa_wip_values)
Incorrect Ratio of Records: Here is a query that shows there might be records in the PPA_WIP_VALUES table, but not all 5 records in the table.
For the application to function properly, there must be a 1:5 ratio between PPA_WIP and PPA_WIP_VALUES tables. No results indicate no problem.
select w.transno, count(*)
from ppa_wip w, ppa_wip_values v
where w.transno = v.transno
group by w.transno
having count(*) <> 5
Orphan PPA_WIP_VALUES records: The following query will show any records that are in the PPA_WIP_VALUES table, but no matching header record in the PPA_WIP_VALUES table. No results indicate no problem.
from ppa_wip_values wipval
where wipval.transno not in (select transno from ppa_wip)
If the issue arises again, review the data and check for the 1:5 record ratio to determine if there is a data corruption issue.
Contact CA Technical Support for assistance in resolving the data corruption issue.