Timecards Error JBO-27122: SQL error during statement preparation. Statement: SELECT 'My Templates-------------' java.sql.SQLException: Invalid column index (Doc ID 2792910.1)

Last updated on DECEMBER 01, 2021

Applies to:

Symptoms

On : 12.1.3 HRMS RUP5 , Time Entry

After applying Patch 32438190 - CPU Patch for Apr-2021 or Patch 32841266 CPU Patch for July 2021 and try to create timecard or create template getting the following error


ERROR
-----------------------
## Detail 0 ##java.sql.SQLException: Invalid column index
...

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT 'My Templates-------------' "DisplayValue"
  , '-1' "Value",
  -1 "RowNum"
 FROM dual
 UNION ALL
 SELECT DisplayValue,Value,RowNum
 FROM (select ' - ' || template_name DisplayValue,'PRIVATE|'||template_id Value, (ROWNUM+1) "RowNum"
  from hxc_template_summarY
  WHERE
  resource_id = :1
  AND
  template_type ='PRIVATE'
  AND layout_id =:2
  order by template_name)
.
.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply Patch 32438190 - CPU Patch for Apr-2021
2- Navigate to Self service time > create timecard using template .
getting the error

Cause

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