SQL error: ORA-00905: missing keyword occurred processing stored SQL for Content 800:HR_1_CNT When Generating Letter From WebADI
(Doc ID 2254618.1)
Last updated on MARCH 14, 2022
Applies to:Oracle Applications Desktop Integrator - Version 12.2.6 and later
Oracle Human Resources - Version 12.2.6 and later
Information in this document applies to any platform.
After R12.ATG_PF.C.Delta.6 Release Update Pack Patch 21900895
When attempting to generate a letter through WEBADI, the following error occurs.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. XX HR Shared Service User (With HR and Leadership)
2. Search for any employee.
3. Export the data using the Export button:
4. Pass the parameters
Integrator: XX HR Letters
Viewer: Excel 2013
Layout: ABS01- Invitation to informal sickness absence review meeting
Pass the Session Date
Click Create Button
Received the error:
“SQL error: ORA-00905: missing keyword occurred processing stored SQL for Content 800:HR_1_CNT.
System upgraded to Patch 21900895 12.2 HRMS RUP6 to include:
Instead of applying R12.ATG_PF.C.Delta.5
Patch 21900895 R12.ATG_PF.C.Delta.6, and it's prereqs
Patch 21830810 [P] TXK:R12.TXK.C.DELTA.8
Patch 21841299 [P] AD:R12.AD.C.DELTA.8 PATCH were applied
This brings the the system up to 12.2.6 tech stack code level and delivered new Web ADI functionality.
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