Unable To Compile HCM Extract (Doc ID 1637613.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.7.0.0 version, Set Up Workforce Deployment

When attempting to compile fast formula in HCM extracts, the following error occurs.

ERROR
-----------------------
Error:

AFDICT_APP_PREFIX-FF-1605069: The compile failed for the formula type Extract Record named EXT_PERSONAL_DATA_300000001163255 with an effective start date of 2000/01/01 00:00:00.
AFDICT_APP_PREFIX-FF-1605039: Formula EXT_PERSONAL_DATA_300000001163255, compilation failed while creating the formula PL/SQL package FFP300000001163258_01012000.
AFDICT_APP_PREFIX-FF-1605071: Table DDL_EXECUTE, Oracle error -20202. (2=ORA-20202: ORA-24344: success with compilation error
ORA-06512: at "FU) (3=107)
ORA-20202: ORA-24344: success with compilation error
ORA-06512: at "FUSION.ADM_DDL", line 385
ORA-06512: at "FUSION.ADM_DDL", line 162
ORA-06512: at line 2

CONC-REQ RETURNED NO MESG


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Workforce Management > Data Exchange > Extract Definitions> Manage HCM Extract Definitions > Custom_Changes_Extract > Click Personal_data > Actions > Compile Formula

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot setup extract

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms