Identify the Last Job Request ID that Updated a Transaction

When you run multiple absence processes such as Update Accrual Plan Enrollments or Calculate Accruals and Balances in quick succession or simultaneously, there may be errors. Now you can easily identify the process that last updated or deleted the tables using the new ESS_Job_Request_ID column has been added to the following tables:

  • ANC_PER_PLAN_Enrollment
  • ANC_PER_Accrual_Entries
  • ANC_PER_ACRL_Entry_DTLS

This new attribute is updated each time the Calculate Accruals and Balances process and the Update Accrual Plan Enrollment process are run.

Troubleshooting errors is easier now by identifying the last process that updated a transaction.

Steps to Enable

You don't need to do anything to enable this feature.