Service Request Search Form (Find SR): Error APP-JTF-210604, ORA-01006, ORA-06512 at APPS.JTF_GRIDDB

(Doc ID 986089.1)

Last updated on FEBRUARY 07, 2017

Applies to:

Oracle Teleservice - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
CSSRFND.pld
**Checked for relevance on 07-Feb-2017***


Symptoms

Conduct a search in Find Service Requests form using Request Type and a Serial Number.
Error is reported.

Error:

When doing a search using request type and serial 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
       grid:
       datasource:

i.e.
        grid: <CS_FIND_GRID.ITEM_GRID>
        datasource: <CS_SR_FIND_SR_NUM_NO_CONT>


The following information is available:

 < null >

The error is most likely in the form or the metadata definition.
Please check the following alert for the error code.

[Click OK and then get the second error]

  The error stack is (first 1000 bytes):
    ORA-01006: bind variable does not exist
    ORA-06512: at "APPS.JTF_GRIDDB", line 837
    ORA-06512: at "APPS.JTF_GRIDDB", line 878

Steps:

(R) Customer Support
(N) Service Requests > Find Service Requests

  - Searched SR Type
  - Entered Serial Number (i.e. fc107516)
  - Press the Search button

  => Get the errors

What is Working:

. If no Serial Number is entered, no error occurs.
. No error occurs if SN has only numeric characters.
. No error occurs if SN is selected from the LOV.

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