Moving a date between tables is causing error ORA-01841
Zgguy answered this in comments:

Explicitly stating columns in the insert solved the problem, as it was trying to put columns in the wrong columns.

INSERT INTO BRAND_RECORD (STRENGTH, GENERIC_NAME, INTERCHANGEABILITY_DATE)