My Oracle Support Banner

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

Last updated on SEPTEMBER 26, 2018

Applies to:

Oracle Common Applications - Version 12.1.3 and later
Information in this document applies to any platform.
Checked relevance on 26-Sept-2018


On : 12.1.3 version, Resources Module (JRES)

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

the following error occurs.

Local Event ERROR : oracle.apps.jtf.jres.resource.update.effectivedate / oracle.apps.jtf.jres.resource.update.effectivedate-179508
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)

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




To view full details, 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 a vibrant support community of peers and Oracle experts.