Unable To Compile HCM Extract (Doc ID 1519186.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 11.1.4.0.0 version, Formula Compiler

When attempting to compile HCM extract the following error occurs.

Error
-----------------------

AFDICT_APP_PREFIX Details: AFDICT_APP_PREFIX
Cau-FF-1605069: The compile failed for the formula type Extract Record named EXT_EMPLOYEE_DEMOGRAPHICS_300000007664268 with an effective start date of 2012/11/27 00:00:00.
AFDICT_APP_PREFIX Details: AFDICT_APP_PREFIX
Cau-FF-1605039: Formula EXT_EMPLOYEE_DEMOGRAPHICS_300000007664268, compilation failed while creating the formula PL/SQL package FFP300000007664290_27112012. Details: The formula has passed all compilation checks, but the generated PL/SQL code is invalid. Compilation failure of generated PL/SQL results from invalid formula function definition text, database item definition text, or database item route text.
AFDICT_APP_PREFIX Details: AFDICT_APP_PREFIX
Cau-FF-1605071: Table DDL_EXECUTE, Oracle error -20202. Details: Error ORA-20202: ORA-24344: success with compilation error
ORA-06512: at "FU occurred when executing statement 107. Contact your support representative.
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 Details: CONC-REQ RETURNED NO MESG
Cause: CONC-REQ RETURNED NO MESG
Action: CONC-REQ RETURNED NO MESG

+---------------------------------------------------------------------------+
UTIL-CURRENT TIME Details: UTIL-CURRENT TIME
Cause: UTIL-CURRENT TIME
Action: UTIL-CURRENT TIME (DATE=05-DEC-2012) (TIME=14:45:32)

+---------------------------------------------------------------------------+


Extract definition contains only one Block, one Record and 2 Data Element

When users include database column person user id or person user name the HCM extract fails to compile.

Steps To Reproduce
1. Extract Record > Actions > Generate Formula and then Compile Formula
-- Checked Extract Execution Tree status (X) compilation failed but No error
2. Navigator: Scheduled Processes and search for "Validate and Compile HCM Fast Formula"
-- Encounter Error


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