Leave Of Absence Does Not Set Tran_submit Consistently When An Error Occurs.
Last updated on JULY 18, 2016
Applies to:Oracle Self-Service Human Resources - Version 184.108.40.206 to 220.127.116.11 [Release 11.5.10]
Information in this document applies to any platform.
Oracle HRMS (Self Service) - Version: 11.5.10
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.
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