JBO-27122: SQL error during statement preparation Error Is Displayed When Openning Hire FIY Notification from Worklist
(Doc ID 3074636.1)
Last updated on MARCH 02, 2025
Applies to:
Oracle Self-Service Human Resources - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
When attempting to open a For Your Information (FIY) Notification for Hire from the Worklist after final approval, the following error occurs.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select flex_struct.id_flex_code, id_flex_structure_code
from pay_legislation_rules plr, fnd_id_flex_structures flex_struct
where plr.rule_type =:1
and plr.legislation_code = :2
and plr.rule_mode = to_char(flex_struct.id_flex_num)
and flex_struct.id_flex_code = 'SCL'
and flex_struct.application_id = 800
from pay_legislation_rules plr, fnd_id_flex_structures flex_struct
where plr.rule_type =:1
and plr.legislation_code = :2
and plr.rule_mode = to_char(flex_struct.id_flex_num)
and flex_struct.id_flex_code = 'SCL'
and flex_struct.application_id = 800
The issue can be reproduced at will with the following steps:
1. Under Manager Self Service responsibility or equivalent.
2. Try to open FIY Notification from Worklist for Hire after Final Approval.
3. Observe above error is displayed.
Changes
Upgrade application from 12.1.3 to 12.2.12
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 |