Problem: Periodic Process Skipped EMPLIDs in Group List

Periodic Process, run using a group list, does not process all EMPLIDs.

Root Cause

There are three common reasons that not all EMPLIDs might have been processed.

1. Incorrect setup of Periodic Process Request – confirm the correct AsOfDate, Group List, Plan, and Process Selections. When run individually, the skipped EMPLIDs would process successfully. For example, the processing is bypassed for EMPLIDs that are not eligible for the requested plan. Also, running Normal Processing with an earlier AsOfDate than used previously will not update result histories.
2. If the first EMPLIDs in the group list (sorted alphabetically) were skipped – The previous Instance of this Run Control stopped with errors and left a row in the calculation restart table (PS_PA_CALC_RESTART).
3. If the last EMPLIDs in the group list (sorted alphabetically were skipped – The group list may include an EMPLID without an Original Hire Date. As the process progresses through the group list, when the next EMPLID on the group list does not have an Original Hire Date, no EMPLID is returned and the process is fooled into thinking the process has successfully processed everyone on the list.

Solutions

Restart

MORE TO ADD HERE

Invalid EMPLID

An Invalid EMPLID might be missing from the PERSON table or not have a valid Original Hire Date.

When reviewing the Create Group List page, an invalid EMPLID might appear with a blank Name.

MORE TO ADD HERE – STORED STATEMENT UPDATE, DESCRIBE HOW AN INVALID ID MIGHT GET ON A LIST.

Hints

There are many reasons why a processed EMPLID might not get results. An EMPLID might not be eligible for the requested plan. Or there could be data, configuration, or processing errors associated with the EMPLID. Does the process run individually for a skipped EMPLID produce the expected results?

Look at the Periodic Process Review page (or PS_PA_PRDIC_PLAN.TOTAL_EMPLOYEES) to see how many EMPLIDs were processed.

Details

Periodic Process returns a Success process status in the process monitor, but not all EMPLIDs in the Group List were processed. No error message is returned.