You may have noticed that if you query any of the APEX's dictionary views (APEX_*) outside the parsing schema you won't get any rows. There's quick solution for this. You only have to grant APEX_ADMINISTRATOR_ROLE to this schema.
grant APEX_ADMINISTRATOR_ROLE to your_nonparsing_schema;
Be careful, user with this role can execute APEX_INSTANCE_ADMIN package procedures and functions.
Enjoy!
grant APEX_ADMINISTRATOR_ROLE to your_nonparsing_schema;
Be careful, user with this role can execute APEX_INSTANCE_ADMIN package procedures and functions.
Enjoy!
Tested in APEX 5.0.3.00.03
