Hi Experts,
Can some one please highlight the mistake and its fix in the query below? Thanks.

select id,measure, last_day(to_date(frcstprdenddt,'rrmm')) as frcstprdenddt, periodicity, estimator,
to_timestamp( to_char(announcestopdt,'mm/dd/yyyy') || ' ' ||announcestoptm , 'HH24:MI:SS.FF') as announcestopdt
from raw_ibesstpepsatus
and frcstprdenddt<>'0'
order by id, measure, frcstprdenddt, periodicity, estimator, announcestopdt, announcestoptm;

I get ORA-01830: date format picture ends before converting entire input string