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 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.

Symptoms

After R12.ATG_PF.C.Delta.6 Release Update Pack <Patch 21900895>
When attempting to generate a letter through WEBADI, the following error occurs.

ERROR
-----------------------
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.


Changes

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.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms