Search Template And Contracts Window Errors With APP-JTF-210604 Datasource: OKC_SEARCH_KHEADERS (Doc ID 1270731.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Service Contracts - Version 11.5.10.2 and later
Information in this document applies to any platform.
Form:OKCKSRCH.FMB - Search Contracts
***Checked for relevance on 08-Mar-2015***

Symptoms


On:  11.5.10.2 version, Search Related

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.

Error:
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: <BLK_KGRID.KHEADER_GRID>
datasource: <OKC_SEARCH_KHEADERS>
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.

Error
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:
1.
Service Contracts Responsibility.
2.
NAV Launchpad
3.
Use the torch to open the Search Template and Contracts window.
4.
Query for a contract (short description) and error shows.


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