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.

Symptoms

On : 12.2.4 version, Find Service Request Form

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

ERROR
-----------------------
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
grid: <CS_FIND_GRID.ITEM_GRID>
datasource: <CS_SR_FIND_SERVICE_REQUEST_NUM>

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


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



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