Unable To View Allocated Checklist Getting Exception Page: JBO-27122: SQL error during statement preparation

(Doc ID 2071376.1)

Last updated on JULY 03, 2016

Applies to:

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


Problem Statement:

When attempting to open the Allocated Checklists form,
the following error occurs.

You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click Here for exception details.

Java exception:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT
pat.allocated_task_id AS allocated_task_id,
pat.allocated_checklist_id AS allocated_checklist_id,
pat.task_name AS task_name,
pat.description AS description,
pat.performer_orig_system AS performer_orig_system,
pat.performer_orig_sys_id AS performer_orig_sys_id,

## Detail 0 ##
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)


Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  Log into Applications with Super HRMS Manager .
  2.  Navigate --> People --> Enter and Maintain --> Others
  3.  Select a "Allocated Checklists" from the Others button LOV.
  4.  The page opening with above mentioned error message.


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