The Synchronize Security Performance Tables is a process which deletes the rows from the PER_ALL_ASSIGNMENTS_F_PERF performance table and inserts data from the PER_ALL_ASSIGNMENTS_F base table to the PER_ALL_ASSIGNMENTS_F_PERF table. Run this process if you want to use the security performance enhancement feature. For more information, see: Setting Up the Security Performance Enhancement Feature

You run this process from the Submit Request window.

Prerequisites

• This process is not delivered in any request sets or groups. To use the process, you must add the process to a request group and, if applicable, a request set.

  See: Organizing Programs into Request Groups, Oracle E-Business Suite System Administrator's Guide - Configuration

  See: Organizing Programs into Request Sets, Oracle E-Business Suite System Administrator's Guide - Configuration

   To run the Synchronize Security Performance Tables process:

1. In the Name field, select Synchronize Security Performance Tables.

2. Select ASG_PERF, which is the Assignment Performance Table (PER_ALL_ASSIGNMENTS_F_PERF) table.

3. Click OK and submit the process.

What's Next

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 rerun the Synchronize Security Performance Tables process to synchronize data in the two tables.