My Oracle Support Banner

Participation Process: Compensation Workbench Errors with ORA-01422 (Doc ID 1503051.1)

Last updated on MAY 01, 2019

Applies to:

Oracle Compensation Workbench - Version 11.5.10 and later
Information in this document applies to any platform.


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

FDPSTP failed due to ORA-20001: BEN_91665_BENMNGLE_ERRORED: N, ORA_ERRCODE, -1422
ORA-06512: at "APPS.FND_MESSAGE", line 509
ORA-06512: at "APPS.BEN_MANAGE_LIFE_EVENTS", line 6075

ORA-01422: exact fetch returns more than requested number of rows
Calling cwb_eval_ptnl_per_for_ler.

The issue can be reproduced at will with the following steps:
1) Go to US Super HRMS Manager Responsibility.
2) Setup the Compensation Workbench Process for the Year 2017.
3) Run the concurrent request "Participation Process: Compensation Workbench".
Error occurs.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.