Search Template And Contracts Window Errors With APP-JTF-210604 Datasource: OKC_SEARCH_KHEADERS
Last updated on DECEMBER 01, 2017
Applies to:Oracle Service Contracts - Version 126.96.36.199 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.
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