I recently read that Freud invented theories about children being sexually fixated on their parents to explain away why so many of his female patients were disclosing CSA. Many of his patients told him they were being sexually abused by their fathers who were upstanding society men so he wrote that the girls were sexually attracted to their fathers to protect the men’s reputations.
Is there any truth to this concept?
No, that's not really accurate. If I may link back to this sub:
This reply by u/hillsonghoods to a similar question five years ago gives a pretty impartial overview of the history (as far as we know it), in addition to briefly explaining Freud's concepts of Oedipal identification/attachment (which you're thoroughly misrepresenting, albeit in a common way).
You might also be interested in this comment from the same poster, which elaborates on the historical reception of Freudian theory in the American context.