The Absence Integration Preference Or Profile Option Is Not Set.
(Doc ID 2079623.1)
Last updated on JANUARY 14, 2021
Applies to:Oracle Time and Labor - Version 12.2 HRMS RUP6 and later
Information in this document applies to any platform.
Getting an error when trying to create a timecard for a Non-OTLR employee with Absence Integration enabled
ORA-01722: invalid number
ORA-06512: at "APPS.HXC_RETRIEVE_ABSENCES", line 386
ORA-06512: at "APPS.HXC_RETRIEVE_ABSENCES", line 1542
ORA-06512: at "APPS.HXC_SELF_SERVICE_TIMECARD", line 5580
ORA-06512: at line 2
The issue can be reproduced at will with the following steps:
1. HR profile option HR: Absences Integration with OTL set to Yes
2. OTL Preference includes
Enable Integration with Absences = Yes
Allow Edit on Timecard Absence entries = Yes
Action for Absences Pending Approval = Warning
Retrieval Rule for Absences = Use Retrieval Rule Group Preference
Display Absence Status Region on Timecard = Yes
Action for Overlap and PTO Validations = Warning
Action for Absences Pending Confirmation = Warning
Exclude Absences from Timecard Totals = No
3. Login as a Non-OTLR employee and try to create a timecard
4. Get error
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