Unexpected Error When Restricting by Multiple Plan Types

(Doc ID 2074629.1)

Last updated on JULY 18, 2016

Applies to:

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


On : 12.1 HRMS RUP8 version, Self Service Benefits

When attempting to access ICD plan with plan type id's added, the following error occurs.

java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

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

1. Use ICD Quick Setup to identify your existing plan_type_ids
2. Add &PLANTYPE=1111,2222 (using 2 of the above plan_type_ids) to the seeded function BEN_SS_MGR_ICD.
3. Access ICD plan


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