Absence : hr_trs_shd.constraint_error : APPS.HR_TRANSACTION_SWI line 255

(Doc ID 1364937.1)

Last updated on JULY 18, 2016

Applies to:

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


In 12.1.3, when one enters an absence in Employee Self-Service, the following problem occurs :

oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20001: System Error: Procedure hr_trs_shd.constraint_error at Step 5

Cause: The procedure hr_trs_shd.constraint_error has created an error at Step 5.

Action: Contact your system administrator quoting the procedure hr_trs_shd.constraint_error and Step 5.
ORA-06512: at "APPS.HR_TRANSACTION_SWI", line 255
ORA-06512: at line 1

at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)



Steps to Reproduce:

Responsibility: Employee Self-Service, Zensar Technologies India-->Leave Management
Apply Leave
Get the error



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