It happens relatively rarely to have an error PLS-00907 (PLS-00907: Can not load library unit). We have encountered it few times in our APEX applications. Here is the way to resolve it (performed by a SYS user).
Solution : Ask your DB admin to flush the shared pool 🙂
APEX App Lab 
great, it worked, thanks
LikeLike