My Oracle Support Banner

"Calculate Assignment Budget Values (UK)" Program Error ORA-20001: There is an existing, <UOM>, assignment budget value row starting the future (Doc ID 2535157.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle HRMS (UK) - Version 12.2.6 and later
Oracle Human Resources - Version 12.2.6 and later
Information in this document applies to any platform.


On : 12.2.6 R12.HR_PF.C.Delta.12 version, UK legislation

After running concurrent program "Calculate Assignment Budget Values (UK)" ,
when the process completes we find we have a number of employees whose assignment actions are in error, who are presenting with the following error message:

"Error ORA-20001: The Assignment Budget Value Maintenance process could not apply the value change. There is an existing,<UOM>, assignment budget value row starting the future.".

The issue can be reproduced at will with the following steps:
1. Run the 'Calculate Assignment Budget Values (UK)' process with below parameters:

UOM: Full Time Equivalent (FTE)
Effective Date: <DD-MON-YYYY>
Run Type: Normal
Payroll: <Payroll Name>
All other parameters are left blank.

2. When the process completes find a number of employees whose assignment actions are in error as per above.


 No changes


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

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