ORA_WFM_WCR_MISSING_DAY_TIME_ENTRIES_AP Fast Formula
This fast formula determines whether the person is scheduled to work the current day. If yes, it determines whether time entries exist for the current day.
If the formula doesn't find any entries, it generates the corresponding defined message. The message severity is an output associated with the generated message. This formula uses an array to process time card data. It isn't associated with any delivered workforce compliance rule templates.
Parameters
| Name | Data Type | Description |
| OVERRIDE_MSG_CODE | Message | Code of the message that overrides the code of the delivered default message, which is HWM_FF_WCR_MISSING_DAY_ENTRIES |
| TAGS_COMMA_SEPARATOR | Fixed text | Comma-separated tags |
Output
| Name | Message Severity |
|---|---|
| OUT_MSG | Specify whether the output message is informational, warning, or error. |
Examples
For these examples, the current day is Wednesday, March 4, 2020.
Example 1: The formula generates a missing day exception for Tuesday and Wednesday because the person is scheduled to work and no entry exists.
| Start and End Times | Mon 2 Mar 2020 | Tue 3 Mar 2020 | Wed 4 Mar 2020 | Thu 5 Mar 2020 | Fri 6 Mar 2020 | Sat 7 Mar 2020 | Sun 8 Mar 2020 |
|---|---|---|---|---|---|---|---|
| Schedule | 8:00 to 16:00 | 8:00 to 16:00 | 8:00 to 16:00 | 8:00 to 16:00 | 8:00 to 16:00 | NA | NA |
| Reported | 8:00 to 16:00 | NA | NA | NA | NA | NA | NA |
Example 2: The formula doesn’t generate an exception because the person is scheduled to work and an entry exist.
| Start and End Times | Mon 2 Mar 2020 | Tue 3 Mar 2020 | Wed 4 Mar 2020 | Thu 5 Mar 2020 | Fri 6 Mar 2020 | Sat 7 Mar 2020 | Sun 8 Mar 2020 |
|---|---|---|---|---|---|---|---|
| Schedule | 8:00 to 16:00 | 8:00 to 16:00 | 8:00 to 16:00 | 8:00 to 16:00 | 8:00 to 16:00 | NA | NA |
| Reported | 8:00 to 16:00 | 8:00 to 16:00 | 9:00 to 14:00 | NA | NA | NA | NA |
Example 3: The formula doesn't generate an exception because the person isn't scheduled to work and no entry exists.
| Start and End Times | Mon 2 Mar 2020 | Tue 3 Mar 2020 | Wed 4 Mar 2020 | Thu 5 Mar 2020 | Fri 6 Mar 2020 | Sat 7 Mar 2020 | Sun 8 Mar 2020 |
|---|---|---|---|---|---|---|---|
| Schedule | 8:00 to 16:00 | 8:00 to 16:00 | NA | 8:00 to 16:00 | 8:00 to 16:00 | NA | NA |
| Reported | 8:00 to 16:00 | 8:00 to 16:00 | NA | NA | NA | NA | NA |
Example 4: The formula doesn't generate an exception because the person has an absence and no entry exists.
| Start and End Times | Mon 2 Mar 2020 | Tue 3 Mar 2020 | Wed 4 Mar 2020 | Thu 5 Mar 2020 | Fri 6 Mar 2020 | Sat 7 Mar 2020 | Sun 8 Mar 2020 |
|---|---|---|---|---|---|---|---|
| Schedule | 8:00 to 16:00 | 8:00 to 16:00 | Sick | 8:00 to 16:00 | 8:00 to 16:00 | NA | NA |
| Reported | 8:00 to 16:00 | 8:00 to 16:00 | NA | NA | NA | NA | NA |