Unable To Compile HCM Extract
(Doc ID 1637613.1)
Last updated on MARCH 30, 2019
Applies to:Oracle Fusion Global Human Resources Cloud Service - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On : 126.96.36.199.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
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