Product(s):	Exor TMA Noticing Manager
	Version(s):	04.05.10.54
	Environment:	N\A
	Area:	Reports
	Subarea:	N\A

Error or Warning Message

ORA-06502: numeric or value error when running the Phase Due To Complete Report (TMA7010)

Explanation

The error occurs either as the report is opened, or when clicking 'Go' to run the report.

How to Avoid

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.