Fusion HCM Extracts: Extract Fails Referencing a Custom Fast Formula (Doc ID 2749554.1)

Last updated on MAY 22, 2023

Applies to:

Symptoms

When attempting to run a custom extract, the extract run fails and the following error occurs:

ERROR
-----------------------
A system error occurred during processing. Contact your help desk.
Name HR_6881_HRPROC_ORA_ERR
Token1 ReportUtil.CallReportProc
Token2 ORA-20001: Context JOB_ID wasn't set when used at line 32 of formula <FORMULA_NAME>. Details: All database items context values must be set when using the database item. All formula functions context values must be set when calling the function. Context values can be set within a formula using a CHANGE_CONTEXTS statement. When writing formula make sure all the required context values are set.
ORA-06512: at "FUSION.FF_EXEC", line 3796
ORA-06512: at "FUSION.FF_EXEC", line 3577
ORA-06512: at "FUSION_DYNAMIC.FFP300000000000_01012000", line 2827
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 4466
ORA-06512: at "FUSION.FF_EXEC", line 4898
ORA-06512: at "FUSION_DYNAMIC.FFP300000000000_01012000", line 2684
ORA-06512: at "FUSION_DYNAMIC.FFP300000000000_01012000", line 52
ORA-06512: at "FUSION_DYNAMIC.FFP300000000000_01012000", line 35
ORA-06512: at line 1
ORA-06512: at "FUSION.FF_EXEC", line 3597
ORA-06512: at "FUSION.FF_EXEC", line 3806
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 2122
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1991
ORA-06512: at line 1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Schedule the extract to run > Verify it fails with the above error

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.