My Oracle Support Banner

Error When Using API update_reprocess_date: ORA-20001: PAY_34309_RTS_MANY_ASG_FOUND (Doc ID 2170279.1)

Last updated on FEBRUARY 16, 2019

Applies to:

Oracle Payroll - Version 12.2 to 12.2 HRMS RUP9 [Release 12.2]
Information in this document applies to any platform.

Symptoms

When using API 'update_reprocess_date' (that in turn calls the get_assignment_id API) to update the reprocess date of an existing retro assignment, an error is displayed as below:


ERROR
-----------------------
ORA-20001: PAY_34309_RTS_MANY_ASG_FOUND

Error stack:

ORA-06512: in "APPS.FND_MESSAGE", regel 509
ORA-06512: in "APPS.PAY_RETRO_STATUS_LOAD", regel 151
ORA-06512: in "APPS.PAY_RETRO_STATUS_LOAD", regel 1030
ORA-06512: in "APPS.POPAY_PAY_PROCESSES", regel 1604

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Use HRMS Responsibility
1. Create contingent worker, e.g. starting with 2010
2. Rehire the employee, e.g. starting with 01-Jan-2011.
3. User wants recalculation date with 01-Jun-2016. Use the API update_reprocess_date (that in turn calls the get_assignment_id API) to update the reprocess date of an existing retro assignment
4. When calling the API, it ends in error.


Cause

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
Symptoms
Cause
Solution
References


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