Oracle Application Express (APEX) is increasingly being used to produce custom developments within Oracle E-Business Suite. I've posted previously about how to configure your custom applications to use E-Business Suite context for purposes such as foundation API's, MOAC security, profile values and such (
using fnd_global.apps_initialize), however I've generally put in a note of warning that such techniques may not work with Human Resources Security. So here I will explain why that is, what you might be able to do to get around that. This assumes the Embedded PL/SQL Gateway (EPG) is being used.
First, let's recap how HR Security is implemented with E-Business Suite, taking People table as an example.
We have the base table
per_all_people_f which is not secured (by VPD or otherwise). Built upon this are a set of secure views such as
per_people_f which are queries from the base table however with a call to the API
hr_security as follows.
The key call in this code is to
hr_security.show_person(...) which evaluates the users access to that person record based upon the security profile the user is currently using (the actual method for this depends on whether Cross Business Group security is in use).