ORA-20001: PAY_34309_RTS_MANY_ASG_FOUND Error when using API pay_retro_status_load.update_reprocess_date (Doc ID 2170279.1)

Last updated on MARCH 28, 2017

Applies to:

Oracle Payroll - Version 12.1.3 and later
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:
ORA-20001: PAY_34309_RTS_MANY_ASG_FOUND

and the error stack is as follows:
ERROR
-----------------------

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, starting with 2010
2. Rehire the employee strating with 01-Jan-2011.
3. Recalculation date with 01-Jun-2016
4. 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
5. When calling the API, it ends in 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