My Oracle Support Banner

Payroll Dashboard Readiness Configuration Page Throws JBO-27122: select pay_ip_utility.get_ip_installation(':1') as CHECK_SUPP_LEG FROM dual (Doc ID 2584501.1)

Last updated on JUNE 22, 2023

Applies to:

Oracle Payroll - Version 12.2 HRMS RUP13 to 12.2 HRMS RUP14 [Release 12.2]
Oracle Payroll - Version 12.1.1 to 12.1 HRMS RUP13 [Release 12.1]
Information in this document applies to any platform.
This note provides a brief overview of .


Problem Statement:

When attempting to navigate to Readiness Configuration, the following error occurs.

Error Page
You have encountered a unexpected error. Please contact your System Administrator for assistance.

Error Message:
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during
statement preparation. Statement: select pay_ip_utility.get_ip_installation(':1') as CHECK_SUPP_LEG
FROM dual

## Detail 0 ##
java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: 1



Steps to Reproduce:

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

  1.  Login as Payroll Professional responsibility
  2.  Go to Payroll Dashboard > Readiness Configuration
  3.  Error occurs



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.