How does the Retro Notification Report and Retropay (Enhanced) Work?

The retrospective changes made will be recorded in pay_process_events with the following details:

  • pay_process_events.effective_date as the effective date (back date) in the system on which the change/update was made
  • pay_process_events.creation_date as the system date when the change/update was made.

When the Retro Notification report (RNR) is run, it will check for the date stored in pay_recorded_requests.recorded_date with attribute_category RETRONOT_ASG. This will tell RNR till which date the events are processed for an assignment. And will find the new events (i.e. events with creation_date after the recorded_date) and process them. It will create retro assignments (pay_retro_assignments) and retro entries (pay_retro_entries)

The Retropay(Enhanced) will process the assignments for which records were inserted into pay_retro_assignments by last RNR. It reprocesses all payroll actions (Quick Pay, Run, Balance Adjustments and Reversals) and creates retro entries where variances in balances are found.

If you do any further retrospective changes, the date stored in pay_process_events.creation_date would be greater than the pay_recorded_requests.recorded_date. Hence it would be processed in the next RNR run. This RNR would insert a new record in pay_retro_assignments and the same would be picked up by Retropay (Enhanced).


Doc ID 1213203.1


Oracle Balance
YTD    Year To Date(Calendar Year)
PTD     Period To Date
ITD      Inception To Date
FYTD    Fiscal Year to Date balance
_ASG_RUN   Assignment Run

Defined Balance Balance Type + Dimesnsion

Balance values don not explicitly sget stored in database.




Oracle Important Links

Fusion Applications Documentation

Release 12.1

Release 12.2 Documentation Library

Release12 Documentation Library