'Allocate Checklists And Tasks Process' Completing With Warning But Log Shows "ORA-20001: BEN_92308_OBJECT_NOT_FOUND" Error. (Doc ID 2795506.1)

Last updated on JULY 28, 2021

Applies to:

Symptoms

On : 12.2.8 Version, Checklist
RUP Level = 28862999 R12.HR_PF.C.Delta.13

When we are trying to on-board an employee or off-board employees , Allocate checklists and tasks process is completing with warning with below error ..

Error Details in Concurrent Request Log:
==========================

ORA-01422: exact fetch returns more than requested number of rows
ORA-20001: BEN_92308_OBJECT_NOT_FOUND: N, PROC, ben_person_object.set_per_object, N, PERSON_ID, <Person Id>, N, BUSINESS_GROUP_ID, , N, EFFECTIVE_DATE
ORA-06512: at "APPS.FND_MESSA

+---------------------------------------------------------------------------+

Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Allocate Tasks Process Started
Allocate Tasks Process Errored for person : <person_id> event_id : 4125
ORA-01422: exact fetch returns more than requested number of rows -1422

=========================

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Navigation: Processes and Reports --> Submit Request --> Request Name: Allocate checklists and tasks process

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.