HR Self-Service Benefits Error ORA-01722: Invalid Number In Set Role To Send FYI Notification

(Doc ID 2163619.1)

Last updated on JUNE 05, 2017

Applies to:

Oracle Advanced Benefits - Version 12.1 HRMS RUP5 and later
Information in this document applies to any platform.


On : 12.1 HRMS RUP5 version, Self Service Benefits

When attempting to make benefit change to trigger FYI notification,
the following error occurs.

Failed Activity Set Role to Send FYI Notification
Activity Type Function
Error Name -1722
Error Message ORA-01722: invalid number
Error Stack Wf_Engine_Util.Function_Call(BEN_FYI_NTFN_SS.SET_ROLE_TO_SEND_NTFN, SSBEN, 5, 239698, RUN)

The issue can be reproduced at will with the following steps:
1. Manager Self-Service -> Benefits
2. Proceed through Enrollment making some type of change
3. Submit and save changes
4. Navigate to Workflow Administrator
5. Notifications
6. Search for SSBEN
7. Status in 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