Unable to "UNDO" PBL (Initialize Balance) batch

Content

Hi All,

When we are trying to "UNDO" PBL (Initialize Balance) batch through Load Initial Balances process getting error. When we verified in the log file didn't see any errors.

We ran with below SQL query and unable to see any payrolls is run. Please share inputs how to debug the issue.

SELECT DISTINCT PPA.PAYROLL_ACTION_ID, PPA.ACTION_TYPE,
PPA.EFFECTIVE_DATE,
PRC.CATEGORY_NAME,
PPA.LEGISLATIVE_PARAMETERS
FROM FUSION.PAY_PAYROLL_ACTIONS PPA,
FUSION.PAY_PAYROLL_REL_ACTIONS PPRA ,
FUSION.PAY_PAY_RELATIONSHIPS_DN pprd,
FUSION.PAY_REPORT_CATEGORIES_VL PRC
WHERE
PPA.PAYROLL_ACTION_ID =PPRA.PAYROLL_ACTION_ID