My Oracle Support Banner

After Upgrade To 12.2.5 ORA-20000: ORA-20001:ORA-20001 When Submit Timecard Using Security in Timekeeper Responsibility. (Doc ID 2169886.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle Time and Labor - Version 12.2.5 and later
Information in this document applies to any platform.


On : 12.2.5 version, Timekeeper Entry

When attempting to submit timecard after upgrade to 12.2.5

the following error occurs.

  ORA-20000: ORA-20001:ORA-20001: Data HXC_PTO_ACCRUAL not found at line 71 of HXC_PTO_ACCRUAL_COMPARISON Cause: A SQL SELECT statement, obtained from the application dictionary, returned no rows when executed. Action: Please refer to your local support representative.

error only when  AU Security Profile was attached to the INTL Timekeeper resp

The issue can be reproduced at will with the following steps:
1. upgraded to 12.2.5

2-Navigation - Timekeeper --> Authorized Delegate Time Entry --> Select the person from LOV --> Click Create Timecard --> Enter the hours --> Click "Continue" button --> error message received
a) Remove the HR:Security Profile from the INTL Timekeeper responsibility .

The "Person" LOV lists all employees in all payrolls  and When  select the AU person , then able to  create a timecard Successfully.




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.