Getting Error When Submitting the Timecard Due to Missing Seeded Time Categories
(Doc ID 2301397.1)
Last updated on SEPTEMBER 01, 2020
Applies to:Oracle Time and Labor - Version 12.2 and later
Information in this document applies to any platform.
When user submits the timecard he gets an error message: 'You have encountered an unexpected error. Please contact the System Administrator for assistance. '
JBO-27122: SQL error during statement preparation. Statement: select
regular_hours, premium_hours, non_worked_hours, total_hours
where timecard_id = :1
and timecard_ovn = :2
java.sql.SQLException: ORA-06511: PL/SQL: cursor already open
ORA-06512: at "APPS.HXC_TIME_CATEGORY_UTILS_PKG", line 4202
ORA-06512: at "APPS.HXC_TIME_CATEGORY_UTILS_PKG", line 5168
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Create timecard
2. Submit timecard
3. Error is thrown
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