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 MAY 06, 2022
Applies to:
Oracle Time and Labor - Version 12.1.3 and laterInformation in this document applies to any platform.
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
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 |