Creating HRMS Secured Reports based on Security Profiles

Using rdf as source of the report:

1. Use secured views like
PER_PEOPLE_F
PER_ASSIGNMENTS_F
PAY_PAYROLLS_F
HR_ORGANIZATION_UNITS


2. Create user Parameters in rdf as below all as datatype number.

1. P_RESP_APPL_ID
2. P_RESP_ID
3. P_SECURITY_GROUP_ID
4.P_USER_ID
5. P_SERVER_ID


3. While registering the parameters in  Concurrent Programs.

1. P_RESP_APPL_ID -->Default Type>Profile --> Default Value> RESP_APPL_ID
2. P_RESP_ID-->Default Type>Profile --> Default Value> RESP_ID
3. P_SECURITY_GROUP_ID-->Default Type>Profile --> Default Value> SECURITY_GROUP_ID
4.P_USER_ID-->Default Type>Profile --> Default Value> USER_ID
5. P_SERVER_ID-->Default Type>Profile --> Default Value> SERVER_ID