Employee Claims Self Service Page Error Message JBO-27122

(Doc ID 2277091.1)

Last updated on MARCH 27, 2018

Applies to:

Oracle HRMS (UK) - Version 12.1 HRMS RUP9 and later
Information in this document applies to any platform.


After patch 25026041, when accessing Employee Claims Self Service page the following error message appears:

Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT et.element_name element_name
  ,et.element_type_id element_type_id
  ,pec.classification_name classification_name
  ,et.input_currency_code input_currency_code
FROM pay_element_types_f et
  ,pay_element_classifications pec
  FROM pay_ele_classification_rules ecr
  WHERE ecr.element_set_id = to_number(:1)
  AND et.classification_id = ecr.classification_id
  FROM pay_element_type_rules etr
  WHERE etr.include_or_exclude = 'E'
  AND etr.element_type_id = et.element_type_id
  AND etr.element_set_id = to_number(:2)
  FROM pay_element_type_rules etr
  WHERE etr.include_or_exclude = 'I'
  AND etr.element_set_id = to_number(:3)
  AND etr.element_type_id = et.element_type_id
AND pec.classification_id = et.classification_id
AND sysdate BETWEEN et.effective_start_date
  AND et.effective_end_date
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1196)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3353)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3148)
at _OA._jspService(_OA.java:229)

Steps to reproduce:
The issue can be reproduced at will with the following steps:
1. Navigate to Self Service responsibility and open Employee Claims function
2. Try to open the page, error occurs


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