Return For Correction - Cannot Select Initiator when Previous Approver Updated Transaction (Doc ID 1476515.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version,
ReturnForCorrVO.xml 120.6.12010000.3

ACTUAL BEHAVIOR  
---------------
Find that when users want to return a transaction for correction, the 'return for correction' cannot be assigned to the initiator of the transaction

EXPECTED BEHAVIOR
-----------------------
Expect functionality to work as it was working in r11 where return for correction showed ALL actors in the approval flow, including the initiator

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. employee self-service
2. select any SIT function, enter all data
3. and submit the transaction
4. First Approver (Fabienne Delfosse) receives approval notification and update the action (the SIT)
5. She has to add some data so she clicks "Update Action"
6. She clicks the update button and adds the required information
7. then clicks on "Continue"
8. then Next
9.Then resubmits.
10 Flow goes to next approver; User is now Victor Bastos
11 this approver wants a correction to be made on the data.
This correction should come from the flow initiator (Antonio Lucas). However, when Bastos click the Return For Correction Link, he gets the following screen where he can only return the action to Fabienne Delfosse (first approver, not initiator)

RESEARCH FROM CUSTOMER : cause of the issue
-----------------------
ReturnForCorrVO.xml with version 120.6.12010000.3; which states a condition:

  AND pah.approval_history_id IN
  (SELECT MAX(p1.approval_history_id)
      FROM pqh_ss_approval_history p1
      WHERE p1.transaction_history_id = :5
       AND p1.action <> 'RFC'
     )

But
the approval _history_id is incremented after an "update action"/"resubmit". Any approver/initiator having a lower approval_history_id cannot be selected for RFC


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