Participation Process: Scheduled Errors with FDPSTP Failed Due To ORA-20001: BEN_91665_BENMNGLE_ERRORED: N, ORA_ERRCODE, -1001 (Doc ID 1999065.1)

Last updated on JUNE 05, 2017

Applies to:

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

Symptoms

On 12.1 HRMS RUP7 version in Oracle Advanced Benefits,

When attempting to run the Participation Process: Scheduled, the following error occurs:

 

ORACLE error 20001 in FDPSTP  ORA-20001: BEN_91665_BENMNGLE_ERRORED: N, ORA_ERRCODE, -1001

Cause: FDPSTP failed due to  ORA-20001: BEN_91665_BENMNGLE_ERRORED: N, ORA_ERRCODE, -1001

ORA-06512: at "APPS.FND_MESSAGE", line 509 ORA-06512: at "APPS.BEN_MANAGE_LIFE_EVENTS", line 6818 ORA-06512: at line 1

 

ORA-01001: invalid cursor
ORA-06512: at "APPS.BEN_DETERMINE_DATE", line 8687
ORA-06512: at "APPS.BEN_PROVIDER_POOLS", line 5372
ORA-06512: at "APPS.BEN_PROVIDER_POOLS", line 6081
ORA-06512: at "APPS.BEN_PROVIDER_POOLS", line 6291
ORA-06512: at "APPS.BEN_PROVIDER_POOLS", line 7184
ORA-06512: at "APPS.BEN_NEWLY_INELIGIBLE", line 1395
ORA-06512: at "APPS.BEN_DETERMINE_ELIGIBILITY2", line 6146
ORA-06512: at "APPS.BEN_DETERMINE_ELIGIBILITY", line 1350
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-01001: invalid cursor
ORA-06512: at "APPS.BEN_DETERMINE_DATE", line 8687
ORA-06512: at "APPS.BEN_PROVIDER_POOLS", line 5372
ORA-06512: at "APPS.BEN_PROVIDER_POOLS", line 6081
ORA-06512: at "APPS.BEN_PROVIDER_POOLS", line 6291
ORA-06512: at "APPS.BEN_PROVIDER_POOLS", line 7184
ORA-06512: at "APPS.BEN_NEWLY_INELIGIBLE", line 1395
ORA-06512: at "APPS.BEN_DETERMINE_ELIGIBILITY2", line 6146
ORA-06512: at "APPS.BEN_DETERMINE_ELIGIBILITY", line 1350
ORA-06510: PL/SQL: unhandled user-defined exception

 

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

1. Run process
2. Review log files

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