Retro Notification Report Does Not Process Delete Assignment Future Change

(Doc ID 2151918.1)

Last updated on JULY 26, 2016

Applies to:

Oracle Payroll - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Problem Statement:

When date-tracking to a historic date (eg 01-Sep-2015) and deleting assignment changes made after this date, the pay_process_events table is logged with the relevant rows showing the deleted rows for the assignment.

Retro-Notification Report is not picking up the assignment for processing even though the setup in the event group checks for deletes against per_all_assignments_f.

 

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  Choose an assignment. Datetrack history shows changes
    11/18/15 Supervisor
    11/09/15 - 11/17/15 Supervisor
    11/8/15 - 11/8/15 Org, Position, Reason
    4/27/15 - 11/7/15 Supervisor
  2. Datetrack to 9/1/15 and delete, selecting 'All' button 'Remove all scheduled changes'

  3. Results show all November changes are removed.

  4. Employee has 'Contractual Pay' element that is set up for retropay

  5. PAY_PROCESS_EVENTS table shows rows for the assignment with EVENT_TYPE 'D' for CHANGE_TYPE DATE_PROCESSED

  6. Ran RNR and no rows for the assignment in pay_retro_assignments

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms