My Oracle Support Banner

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 JULY 04, 2018

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:
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

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.