Leave Of Absence Does Not Set Tran_submit Consistently When An Error Occurs. (Doc ID 809316.1)

Last updated on JULY 18, 2016

Applies to:

Oracle Self-Service Human Resources - Version 11.5.10.0 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
Oracle HRMS (Self Service) - Version: 11.5.10


Symptoms


On Release 11.5.10 and Release 12:

Find that If an error occurs in Leave of Absence Self-Service Workflow the attribute TRAN_SUBMIT is not set consistently. If the process errors in PQH_SS_WORKFLOW.validation_on_final_approval then the hr_api_transactions record status is set to ‘E’. The attribute TRAN_SUBMIT is not set. If the process errors in HR_TRANSACTION_SS.COMMIT_TRANSACTION then the hr_api_transactions record status is set to ‘E’. The attribute TRAN_SUBMIT is also set to ‘E’. This causes the concurrent program ‘Complete Defunct HR Workflow Processes’ to only complete workflow processes where TRAN_SUBMIT is set to ‘E and miss those in error caused by PQH_SS_WORKFLOW.validation_on_final_approval.

 

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

1. Approve LOA where Security Profile excludes the persons LOA you are approving.

 

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