HCM Extract Fast Formula Not Getting Compiled

(Doc ID 1909118.1)

Last updated on FEBRUARY 06, 2015

Applies to:

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


On : version, Set Up Workforce Deployment

After the application upgrade from Release 7 to Release 8, when attempting to compile HCM extract -> MTW_PEOPLESOFT_EMPLOYMENT_CHANGES the following error occurs.


AFDICT_APP_PREFIX-FF-1605069: The compile failed for the formula type Extract Record named EXT_MTW_EMPLOYEE_RECORD300000009114236_300000009114236 with an effective start date of 1951/01/01 00:00:00.
AFDICT_APP_PREFIX-FF-1605039: Formula EXT_MTW_EMPLOYEE_RECORD300000009114236_300000009114236, compilation failed while creating the formula PL/SQL package FFP300000011292414_01011951.
AFDICT_APP_PREFIX-FF-1605071: The following Oracle error occurred for table DDL_EXECUTE: -20500. (2=ORA-20500: ORA-04020: deadlock detected while trying to lock object FU) (3=107)
ORA-20500: ORA-04020: deadlock detected while trying to lock object FUSION_DYNAMIC.PER_ALL_ASSIGNMENTS_M

ORA-06512: at "FUSION.ADM_DDL", line 217
ORA-06512: at line 2


UTIL-CURRENT TIME (DATE=11-JUL-2014) (TIME=05:09:14)



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