SQL error: ORA-00905: missing keyword occurred processing stored SQL for Content 800:HR_1_CNT When Generating Letter From WebADI
Last updated on SEPTEMBER 06, 2017
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.
SQL error: ORA-00905: missing keyword occurred processing stored SQL for Content 800:HR_1_CNT.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms