• I only see the one delete so does the error happen when deleting from FUEL_MESSAGE?

    From the error message and that one delete, it looks like there is a Relationship between FUEL_ESS_PUBLISH_RECORD and FUEL_MESSAGE. FUEL_ESS_PUBLISH_RECORD has FK relationship to FUEL_MESSAGE. They are related on the msg_id column.

    So Fuel_message can have one or more related rows Fuel_ess_publish_record. The rows in Fuel_ess_publish_record would be orphaned as there wouldn't be the related msg_id row in FUEL_MESSAGE.

    Sue