HRMS security custom profile using fnd_global or fnd_profile variables not working as expected.
I had a requirement from business to create a responsibility for handling employee’s absences.
Many users will have access to this authority and each user will have to handle colleagues from the same department. He must not have access to data of other employees who are not in the same department as him.
The setup is done via HRMS Manager -> Security
I made a new responsibility with security profile based on organization security and additionally wrote a custom security profile based on logged in user_id
It seems that the fnd_profile.value('USER_ID') variable that i used in my custom security profile is not recognized when the user log in the system unless he runs the concurrent request "Security List Maintenance