The Absence Integration Preference Or Profile Option Is Not Set. (Doc ID 2079623.1)

Last updated on JANUARY 14, 2021

Applies to:

Symptoms

Problem Description:

Getting an error when trying to create a timecard for a Non-OTLR employee with Absence Integration enabled

ERROR
-----------------------
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



STEPS
-----------------------
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

Cause

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