HCM Extract failing at runtime for Name PAY_PAYPROC_UNKNOWN_ERR

Summary:

Hello,

The HCM Extract validated and compiled with no errors is failing at runtime for below mentioned errors:

Name PAY_PAYPROC_UNKNOWN_ERR

Token1 null

Token2 null

Token3 null

A system error occurred during processing. Contact your help desk.

Name HR_6881_HRPROC_ORA_ERR

Token1 ORA-00907: missing right parenthesis

ORA-06512: at "SYS.DBMS_SQL", line 1199

ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 624

ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 2209

ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 2040

ORA-06512: at line 1

Token2 ReportUtil.CallReportProc

Token3 20

A system error ORA-00907: missing right parenthesis

ORA-06512: at "SYS.DBMS_SQL", line 1199

ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 624