When attempting to send a notice against archived works, the following error appears:
ORA-01422: exact fetch returns more than requested number of rowsORA-06512: at "TMA_VALIDATION", line 2149ORA-01403: no data found
This happens when starting a new phase on archived (EToN 3) works which have more than 1 site.
Create the works from scratch in the TMA Works form (TMA1000), keeping the details the same as the archived version as far as possible, including the works reference.
Save the works without sending a notice.
Exit the Works form, then go back in again and query the works reference just created.
Send the initial notice as normal. This time you should not see the error.