Fusion Applications - Global Payroll - Unable To Compile HCM Extract's Formula Due To Application Error (when using the "compile all formula"): An application error occurred. See the incident log for more information.

(Doc ID 2312596.1)

Last updated on OCTOBER 29, 2017

Applies to:

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

Goal

Unable to compile the a Payroll Interface (HCM Extract) due to a application error.


The formulas were individually compiled but the same error message is returned when using the "compile all formula" button on the HCM extract validate page.

Details:
Extract: <Extract_Name>
Compilation failing on Formula using the Advanced Condition for Element Records:

((((EE.effective_start_date<=pay_report_utils.get_context_value_date('END_DATE'))
  AND (EE.effective_end_date>=pay_report_utils.get_context_value_date('START_DATE')))
  AND ((EE.effective_end_date>=pay_report_utils.get_context_value_date('END_DATE'))
  OR (EE.effective_end_date=EU.DATE_TO)))
  AND (hr_general.decode_lookup('PAY_CREATOR_TYPE', EE.creator_type) NOT IN ('Salary Proposal', 'Deduction Card')))
AND SUBSTR(ET.DESCRIPTION,1,4) = 'MISC'
AND PIV.BASE_NAME in ('Period Amount','Info Text')

Solution

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