After Upgrade Getting APP-JTF-210604 ORA-00904 : "PROJECT_TASK_ID" invalid identifier Using Find Service Request Form To Search Service Request

(Doc ID 2076113.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Teleservice - Version 12.2.4 and later
Information in this document applies to any platform.


On : 12.2.4 version, Find Service Request Form

When attempting to do simple search using an exact SR number.,
the following error occurs.

APP-JTF-210604: Program error: Please inform your system administrator or support representative that:
jtf_grid.populate package reports error:

An unexpected error occurred in jtf_grid.populate

And then:

The error stack is (first 1000 bytes):
ORA-00904: "PROJECT_TASK_ID": invalid identifier
ORA-06512:at "APPS.JTF_GRIDDB", line 837
ORA-06512:at "APPS.JTF_GRIDDB", line 878

The issue can be reproduced at will with the following steps:
 Steps To Reproduce:
(R) Service
(N) Service Requests > Find Service Request
- Search by Number
- Click "Search" button
- Getting an error


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