Setting Up the Security Performance Enhancement Feature

Typically, most of the Oracle HRMS products use the security mechanism that Oracle HRMS provides. Defining which records and information users can access is fundamental to HRMS security. To enhance product performance when person security evaluation happens during processing of voluminous data, Oracle HRMS provides the security performance enhancement feature. You can set up this feature, if required, based on your business needs.

arrow icon   To set up the security performance enhancement feature:

Complete the following steps to set up the security performance enhancement feature.

  1. Run the Synchronize Security Performance Tables process to synchronize the PER_ALL_ASSIGNMENTS_F_PERF table with the PER_ALL_ASSIGNMENT_F table.

    The PER_ALL_ASSIGNMENTS_F is the base table, which Oracle HRMS uses to evaluate person security. The PER_ALL_ASSIGNMENTS_F_PERF table is a performance table and includes the following columns from the PER_ALL_ASSIGNMENTS_F table:

    1. ASSIGNMENT_ID

    2. EFFECTIVE_START_DATE

    3. EFFECTIVE_END_DATE

    4. PERSON_ID

    5. POSITION_ID

    6. PAYROLL_ID

    7. ORGANIZATION_ID

    8. SUPERVISOR_ID

    9. SUPERVISOR_ASSIGNMENT_ID

    10. BUSINESS_GROUP_ID

    11. ASSIGNMENT_TYPE

    12. ASSIGNMENT_STATUS_TYPE_ID

    13. PRIMARY_FLAG

    See: Running the Synchronize Security Performance Tables Process

  2. Make sure that the PER_ASG_PERF_TRG trigger on the PER_ALL_ASSIGNMENTS_F table is enabled all the time as this trigger is responsible for the incremental refresh of the PER_ALL_ASSIGNMENTS_F_PERF table whenever there is a DML operation on the PER_ALL_ASSIGNMENTS_F table.

  3. Set the HR: Security Performance Enhancer profile option at the responsibility level, so that Oracle HRMS retrieves information from the assignment records in the PER_ALL_ASSIGNMENTS_F_PERF table during person security evaluation. This ensures that the person security data retrieval is faster.

arrow icon   Troubleshooting security performance enhancement issues:

If you encounter any security performance enhancement issues, then complete the following steps:

  1. Run the Synchronize Security Performance Tables process:

    Verify if there is any difference in the row count between PER_ALL_ASSIGNMENTS_F and PER_ALL_ASSIGNMENTS_F_PERF tables. If there is any difference between the two tables, then run the Synchronize Security Performance Tables process to synchronize data in the two tables.

  2. Reset the HR: Security Performance Enhancer profile option:

    If the difference in the row count between PER_ALL_ASSIGNMENTS_F and PER_ALL_ASSIGNMENTS_F_PERF tables still exists after you run the Synchronize Security Performance Tables process, then reset the HR: Security Performance Enhancer profile option to Null and retest the issue.

Restrictions

You cannot use the security performance enhancement feature if your enterprise uses custom security. When the system administrator creates custom security mechanism, the administrator can make use of any of the columns in the PER_ALL_ASSIGNMENTS_F table to define security restrictions. However, the PER_ALL_ASSIGNMENTS_F_PERF table contains data from only 13 columns of the PER_ALL_ASSIGNMENTS_F base table. See list of columns. If you use any column other than the columns in the PER_ALL_ASSIGNMENTS_F_PERF table, set the HR: Security Performance Enhancer profile option and define custom security, then this feature as well as the general Oracle HRMS security mechanism will not work.