My Oracle Support Banner

APPROVAL_STATUS in PAY_RETRO_ASSIGNMENTS Table is not Reflecting the Correct Status (Doc ID 2830538.1)

Last updated on APRIL 16, 2023

Applies to:

Oracle Payroll - Version 12.1 and later
Information in this document applies to any platform.
This note provides a brief overview of Bug:17854648.

Symptoms

Problem Statement:

Retropay status is not updating correctly in the PAY_RETRO_ASSIGNMENT table.

After running Retro Notifications Report:
   RetroPay Status = Awaiting Processing
   PAY_RETRO_ASSIGNMENT.APPROVAL_STATUS = A

After running Retropay:
   RetroPay Status = Completed
   PAY_RETRO_ASSIGNMENT.APPROVAL_STATUS = P

After Reversing the Retro:
   RetroPay Status = Awaiting Processing
   PAY_RETRO_ASSIGNMENT.APPROVAL_STATUS = P


  EXPECTED BEHAVIOR
  -----------------------

After running Retro Notifications Report:
  RetroPay Status = Awaiting Processing
  PAY_RETRO_ASSIGNMENT.APPROVAL_STATUS = A

After running Retropay:
  RetroPay Status = Completed
  PAY_RETRO_ASSIGNMENT.APPROVAL_STATUS = C

After Reversing the Retro:
  RetroPay Status = Awaiting Processing
  PAY_RETRO_ASSIGNMENT.APPROVAL_STATUS = A

 

Steps to Reproduce:

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

  1.  Login as HRMS Manager responsibility

  2.  Run Retro Notification Report
     (N) Processes and reports > Submit Processes and Reports > Single Request

  3.  Check the value in PAY_RETRO_ASSIGNMENT.APPROVAL_STATUS and status in RetroPay status page
          
     (N) View > Retropay Status

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.