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 .

Symptoms

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
at
oracle.jdbc.driver.OraclePreparedStatement.setObjectAtName(OraclePreparedStatement.java:15906)
at
oracle.jdbc.driver.OraclePreparedStatementWrapper.setObjectAtName(OraclePreparedStatementWrapp
er.java:911)

 

 

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

 

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!

In this Document
Symptoms
Cause
Solution
References


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