After Upgrade To 12.2.5 ORA-20000: ORA-20001:ORA-20001 When Submit Timecard Using Security in Timekeeper Responsibility.
Last updated on AUGUST 08, 2016
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms