After Upgrade to Receive Error - Employee Self-Service Voluntary Termination : ORA-20002: 3109: Attribute 'REASSIGN_DIRECTS' does not exist

(Doc ID 1673987.1)

Last updated on SEPTEMBER 13, 2016

Applies to:

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


After upgrading from to, when attempting to perform a Voluntary termination the following error occurs.

## Detail 0 ##
java.sql.SQLException: ORA-20002: 3109: Attribute 'REASSIGN_DIRECTS' does not exist for activity '274758' in item 'HRSSA/1360'.
ORA-06512: at "APPS.WF_CORE", line 309
ORA-06512: at "APPS.WF_ENGINE", line 2486
ORA-06512: at line 1

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

     1. Login to the application

     2. Employee Self-Service

     3. Voluntary Termination

     4. See page: Voluntary Termination: Perform Action

     5. Click Start

     6. See page: Voluntary Termination: Effective Date Options
                       Select Changes should take effect on the effective date.

     7. See the unexpected 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