Cannot Open Delinquent Transaction Node in the UWQ - Multiple Errors (Doc ID 1597097.1)

Last updated on APRIL 27, 2016

Applies to:

Oracle Advanced Collections - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Opening the Delinquent Transaction node on the UWQ results in a multitude of errors starting with:

IN ON_ERROR TRIGGER


APP-JTF-210604: Program error ....

jtf_grid.removeAllBindVariables package reports error:
An unexpected error occurred in
jtf_grid.removeAllBindVariables

grid: <GRID_BLOCK.GRID_ITEM>
datasource: <IEX_DELINQUENCIES_UWQ>

The following information is available:
<null>


ORA-20001: APP-JTF-210691: Program error. Please inform your ....

JTF_GRIDDB package reports error:
Application Errror: jtf_griddb.setHasBindVariablesChanged
reports that

grid: <5.GRID_BLOCK.GRID_ITEM>

has not been initialized.  A grid must be specified using
BLOCK.ITEM_NAME in UPPERCASE.  The error is in the form.

ORA-06512: at "APPS.APP_EXCEPTION", LINE72
ORA-06512: at "APPS.JTF_GRIDDB"", line 64
ORA-06512: a


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