Unable To Compile HCM Extract
Last updated on MARCH 08, 2017
Applies to:Oracle Fusion Global Human Resources Cloud Service - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.0 version, Set Up Workforce Deployment
When attempting to compile fast formula in HCM extracts, the following error occurs.
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
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
The issue has the following business impact:
Due to this issue, users cannot setup extract
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