Fusion US Payroll - Extract is Failling Error: "Assign a value to the local variable "ORA_HRX_US_WTH_STATE_DIR_COMP_AREA1_MEANING" before it's referenced"
(Doc ID 2962733.1)
Last updated on OCTOBER 04, 2023
Applies to:
Oracle Fusion Global Payroll Cloud Service - Version 11.13.23.04.0 and laterInformation in this document applies to any platform.
Symptoms
When attempting to run a custom extract,
the following error occurs.
ERROR
-----------------------
A system error ORA-20001: Formula EXT_W4_STAT occurred in table ReportUtil.CallReportProc at location 20. Contact your help desk.
A system error occurred during processing. Contact your helpdesk
ORA-20001: Formula EXT_W4_STATE_COMPONENT_DETAILS_300000XXXXXXXXX, line 28, a local variable was used before being initialized. Details: Assign a value to the local variable "ORA_HRX_US_WTH_STATE_DIR_COMP_AREA1_MEANING" before it's referenced. ORA-06512: at "FUSION.FF_EXEC", line 3796 ORA-06512: at "FUSION.FF_EXEC", line 397 ORA-06512: at "FUSION.FF_EXEC", line 3710 ORA-06512: at "FUSION.FF_EXEC", line 3806 ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 2225 ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 2094 ORA-06512: at line 1
A system error occurred during processing. Contact your helpdesk
ORA-20001: Formula EXT_W4_STATE_COMPONENT_DETAILS_300000XXXXXXXXX, line 28, a local variable was used before being initialized. Details: Assign a value to the local variable "ORA_HRX_US_WTH_STATE_DIR_COMP_AREA1_MEANING" before it's referenced. ORA-06512: at "FUSION.FF_EXEC", line 3796 ORA-06512: at "FUSION.FF_EXEC", line 397 ORA-06512: at "FUSION.FF_EXEC", line 3710 ORA-06512: at "FUSION.FF_EXEC", line 3806 ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 2225 ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 2094 ORA-06512: at line 1
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. My Clients Groups - Data Exchange - Submit a flow.
2. Select Extract - Error occurs.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |