My /usr/bin/vlc binary was broken after installing vlc from source into /usr/local prefix. Based on my experience installations into /usr/local didn't affect binaries /usr/bin/[binary], but maybe that was just by accident.
Afaik the effect of a /usr/local installation might be (unstable) shared libraries which are loaded from there before the (stable) ones from /usr/. So, does Ubuntu force package maintainers to load dynamic libraries from /usr/ only?
Resources like hier manpage, BLSF position on /usr/local vs /usr and FHS explanation of Debian answers this question imo since it doesn't define interoperability between binaries in different prefixes.
This is not about the functioning of path lookup priorities (for binaries, shared libraries, ...) which is quite clear for me, but about their usage (constraints, definitions, (pseudo)-standards) in Ubuntu.