In PeopleXD Workforce Management, this error can appear in Roster Builder when the system finds an invalid value in roster-related data for one or more employees in the selected period.
This issue is usually caused by incorrect values being entered in roster details, shift details, contract details, or personal overrides.
Before you start
Make sure:
the issue only affects one specific Team Area or period
you have confirmed the error appears when searching in Roster Builder
you capture the exact error message shown on screen
Cause
This error can happen for one of the following reasons:
an employee’s roster details have been updated with a character value where a numeric value is expected
an employee’s start time or end time in roster details has been entered in an invalid format, such as 8:00 instead of 08:00
an employee’s start time or end time in Contract Details, Shift, or Personal Override has been updated with an invalid value
📌Note: This issue is caused by invalid data in one or more records linked to the affected Team Area and period.
Resolution
This issue requires investigation and correction of the invalid data.
To get this resolved
Raise a new case online.
Include the exact title of this article in the case details.
Provide the affected Team Area and period.
Include the full error message: FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-01722.
Result
Once the invalid data has been identified and corrected, you should be able to search for the Team Area and load the affected period in Roster Builder without the error.