My Oracle Support Banner

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.

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.

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

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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.