My Oracle Support Banner

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.

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

To view full details, 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 a vibrant support community of peers and Oracle experts.