Employee Claims Self Service Page Error Message JBO-27122 (Doc ID 2277091.1)

Last updated on JUNE 15, 2017

Applies to:

Oracle Human Resources - Version 12.1 HRMS RUP10 and later
Information in this document applies to any platform.

Symptoms

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
WHERE EXISTS
  (
  SELECT NULL
  FROM pay_ele_classification_rules ecr
  WHERE ecr.element_set_id = to_number(:1)
  AND et.classification_id = ecr.classification_id
  AND NOT EXISTS
  (
  SELECT NULL
  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)
  )
  UNION
  SELECT NULL
  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


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