The Absence Integration Preference Or Profile Option Is Not Set.

(Doc ID 2079623.1)

Last updated on AUGUST 25, 2017

Applies to:

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

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms