My Oracle Support Banner

ORA-20001 Error Occurs When Executing PER_UTILITY_FUNCTIONS.GET_NET_ACCRUAL (Doc ID 3030919.1)

Last updated on JUNE 26, 2024

Applies to:

Oracle Human Resources - Version 12.2 HRMS RUP16 and later
Information in this document applies to any platform.

Symptoms

When attempting to execute PER_UTILITY_FUNCTIONS.GET_NET_ACCRUAL to get the net accrual for the employee, the following error occurs.

 

ORA-20001: Data PER_AGE not found at line 96 of ANNUAL_LEAVE_ACCRUAL

Cause: A SQL SELECT statement, obtained from teh application dictionary, returned no rows when executed.

Action: Please refer to your local support representative.
ORA-06512: at "APPS.PER_FORMULA_FUNCTIONS", line 608
ORA-06512: at "APPS.HR_UTILITY", line 970
ORA-06512: at "APPS.FF_EXEC", line 2807
ORA-06512: at "APPS.PER_FORMULA_FUNCTIONS", line 582
ORA-06512: at "APPS.PER_ACCRUAL_CALC_FUNCTIONS", line 70
ORA-06512: at "APPS.PER_ACCRUAL_CALC_FUNCTIONS", line 129
ORA-06512: at "APPS.PER_ACCRUAL_CALC_FUNCTIONS", line 979
ORA-06512: at "APPS.PER_UTILITY_FUNCTIONS", line 895
ORA-06512: at line 1

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

  1.  Execute PER_UTILITY_FUNCTIONS.GET_NET_ACCRUAL.


      2. Error occurs.

 

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


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