Synchronize Employee Concurrent Program, Generates WF Error Notifications. (Doc ID 2002861.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Common Applications - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Resources Module (JRES)

When run the Synchronize employee concurrent program, it generates WF Error notifications.

the following error occurs.

ERROR
-----------------------
Local Event ERROR : oracle.apps.jtf.jres.resource.update.effectivedate / oracle.apps.jtf.jres.resource.update.effectivedate-179508
To SYSADMIN
Sent 18-10-2014 07:01:48
ID 990955


An Error occurred in the following Event Subscription: Event Subscription

Event Error Name: -1427
Event Error Message: ORA-01427: single-row subquery returns more than one row
Event Error Stack:
AS_RESOURCE_MERGE_PUB.update_resource_enddate(oracle.apps.jtf.jres.resource.update.effectivedate, E76F4527DFC33AAEE0301490CBC418E0)
------------



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
> Terminate a resource in CRM Resource Manager
> (R) CRM ADMINISTRATOR Run the Synchronize employee program

User receives the workflow notification error

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