TMA Spatial Validation Error

Question

Exor TMA Manager 04.05.00.00 
 User enters works details into the Works form (tma1000) then clicks to issue notice TMA1001 and gets an error 
 Error Internal error during validation tma_spatial_validation_proximity_check ORA-29913: error in executing ODCIAGGREGATEMERGE callout 
 The works coordinates were within the area of the related street and there was no visible reason why the validation should fail. 
 In order that the notice could be sent, the user turned off the proximity validation while the notice was sent and then turned it back on again. 
 Please could someone advise if there is an issue that we can resolve at this end, or if this is an issue that will have to be dealt with manually if it happens again. 
 issue with USRN 47818007 - Wolvershill Road, North Somerset. 
 Posted on behalf of an Exor user.

Lee Jackson · Accepted Answer

WORKAROUND: 
 If your new works record has a Works Category of Immediate, you don&rsquo;t need to supply phase coordinates on the initial notice (0200) as the following rule applies: 
 LocationCoordinates are optional when ChargeCategory=6 (secondary promoter) or for WorksCategory values of 4 or 5 (Immediate works). Coordinates should be provided in all other circumstances. 
 If you see the validation error then dont supply any coordinates for the initial notice so you can continue the works. You will need to supply coordinates on a later notice so please use the following workaround to bypass the error. 
 WORKAROUND 2: 
 If you urgently need to send a notice for a works that contains phase coordinates and generates a proximity validation error, double check the coordinates you want to use and send a notice with the proximity validation feature disabled. To disable the TMA Proximity Validation feature, log in as a user with the HIG_ADMIN role and update product option TMAPROXVAL to N. Once you have sent the notice, re-enable the feature by setting the product option to Y.