ORA-06502: numeric or value error when running the Phase Due To Complete Report (TMA7010)
The error occurs either as the report is opened, or when clicking 'Go' to run the report.
This is probably due to a duration challenge having been received, and either it hasn't been processed successfully or someone has blanked out the challenge details when sending subsequent notices. If the challenge details are missing the report can't work out the overrun. This script will identify any phases that have a duration challenge notice but no challenge details.
SELECT tn.tnot_works_ref, tp.TPHS_PHASE_NO, tp.tphs_phase_status, tn.tnot_created_datim FROM tma_phases tp, tma_notices tn WHERE ( tp.tphs_working_hours IS NULL OR tp.TPHS_CHALLENGE_DURN_TYPE IS NULL OR tp.TPHS_CHALLENGE_DURN_VALUE IS NULL OR tp.TPHS_CHALLENGE_END_DATE IS NULL) AND tp.TPHS_PHASE_NO = tn.TNOT_PHASE_NO AND tp.TPHS_WORKS_ID = tn.TNOT_WORKS_ID AND tn.tnot_notice_type = '1200';
Please see wiki https://communities.bentley.com/products/assetwise/exor/w/wiki/15366/missing-phase-data for details of what to do in this situation.