It's
Inventing the Abbotts (1997).
Kind of a so-and-so movie, not terrible. If the only things you remember are the erotic scenes, it's understandable. The first two scenes feature Jennifer Connelly at her peak attractiveness.
The cast of the movie went on to do quite a lot.