Dynamic Approval on Checklist get Error ORA-01722: Invalid Number ORA-06512: At "APPS.PER_CHECKLIST_EVENTS" (Doc ID 1512257.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Human Resources - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When having setup dynamic approval group for checklists, when running process 'Allocate checklists and tasks process'
get following error :

ORACLE error 1722 in FDPSTP

Cause: FDPSTP failed due to ORA-01722: invalid number
ORA-06512: at "APPS.PER_CHECKLIST_EVENTS", line 743
ORA-06512: at line 1

The SQL statement being executed at the time of the error was: SELECT R.Conc_Login_Id, R.Request

 

WHAT IS WORKING
----------------------------------
Works fine when using static approval group (ie single person)
Same approval group sql works fine when used in the HR Item type, only fails on Checklists


STEPS TO REPRODUCE
----------------------------------
1. Use responsibility : Global HRMS manager
2. Navigation :processes and reports > submit processes and reports
3. Submit 'Allocate checklists and tasks process'



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