Not much different in my experience.
It's often a credit given to an exceptional UPM who needs the credit on her way to the producers chair. And relevant to your question, a line producer can also be the "producer" on location.
But the duties are still the same as a UPM.