Search Template And Contracts Window Errors With APP-JTF-210604 Datasource: OKC_SEARCH_KHEADERS

(Doc ID 1270731.1)

Last updated on DECEMBER 01, 2017

Applies to:

Oracle Service Contracts - Version and later
Information in this document applies to any platform.


When attempting to search for a contract in the Search Template and Contracts window, an error occurs.

Enter a short description to search on and window hangs.

Nothing happens until session is killed.

Known situations: Database is upgraded from 10g to 11g. It works on 10g database and also with R12 and on 11g database, but with 11i and 11g database this issue 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
The following information is available:
The error is most likely in the form or the metadata definition. Please check the following alert for the error code.

APP-FND-01564: ORACLE error 1000 in audfrm
Cause: audfrm failed due to ORA-01000: maximum open cursors exceeded.
The SQL statement being executed at the time of error was:
&SQLSTMT and was executed from the file &ERRFILE.

Steps to Reproduce
The issue can be reproduced at will with the following steps:
Service Contracts Responsibility.
NAV Launchpad
Use the torch to open the Search Template and Contracts window.
Query for a contract (short description) and error shows.




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