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.


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


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

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


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