Fusion HCM : JBO-27122 : Error while Loading Element Entries (Doc ID 1907586.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

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

Symptoms

When user loads an element entry batch and faces below error :
The error is : JBO-27122: SQL error during statement preparation

The error message is :
SQL error during statement preparation. Statement: SELECT ElementTypeDPEO.ELEMENT_TYPE_ID, ElementTypeDPEO.EFFECTIVE_START_DATE, ElementTypeDPEO.EFFECTIVE_END_DATE, ElementTypeDPEO.CLASSIFICATION_ID, ElementTypeDPEO.LEGISLATIVE_DATA_GROUP_ID, ElementTypeDPEO.LEGISLATION_CODE, ElementTypeDPEO.INPUT_CURRENCY_CODE, ElementTypeDPEO.OUTPUT_CURRENCY_CODE, ElementTypeDPEO.BASE_EL

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