My Oracle Support Banner

R12-PAY: UK Payroll Group not Allowing Updates (Doc ID 2693343.1)

Last updated on JULY 22, 2020

Applies to:

Oracle HRMS (UK) - Version 12.1 HRMS RUP12 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:

The customer has indicated that the Payroll Group module is no longer allowing them to update payroll groups with new payrolls, after upgraded to HRMS 12.1 RUP12.

The last time that this was successful was in September 2019, when the environment had RUP 11.

The customer have tested on different environments and can confirm that the 2 environments that have RUP12 in them are the ones that are no longer allowing updates.

Exception Details.  
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM (SELECT
   PAYROLL_GROUP_NAME,
   PAY_FREQUENCY,
   PAYROLL_GROUP_ID,
   BUSINESS_GROUP_ID
FROM
   PAY_GB_PAYROLL_GROUPS) QRSLT  WHERE (PAYROLL_GROUP_ID = :1 AND ( UPPER(PAYROLL_GROUP_NAME)  like UPPER( :2) )) ORDER BY PAYROLL_GROUP_NAME ASC
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.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1465)
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:3084)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1914)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:559)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:441)

## Detail 0 ##
java.sql.SQLException: Invalid column type
at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:8516)
at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8034)

 

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

  1.  Go to "UK HRMS Manager" responsibility
  2.  (N) -> Select "Other Definitions"
  3.  Select "Payroll Group" > Search for an existing "Payroll Group Name" > press Go
  4.  Click on the update button

Changes

 

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
Changes
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.