My Oracle Support Banner

APP-JTF-210604 Error When Viewing Specific Metadta Tables in Advanced Collections (Doc ID 2935505.1)

Last updated on APRIL 28, 2023

Applies to:

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


When opening the 'Strategy Work Items: Bill To' node in the Collectors Work Queue (UWQ), 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

datasource: <IEX_BILLTO_STR_UWQ>

The following information is available:


The error is most likely in the form of the metadata definition.

Click OK and get a second error:

ORA-00938 not enough arguments for function
ORA-06512 at APPS.JTF_GRIDDB line 837
ORA-06512 at SYS.DBMS_SQL line 1134
ORA-06512 at APPS.JTF_GRIDDB line 722
ORA-06512 at APPS.JTF_GRIDDB line 878

Steps to Reproduce:

Responsibility: Collections Agent
: Collections or Collectors Work Queue

  1. Open the UWQ and select the 'Strategy Work Items: Bill To' node.
  2. Similar errors can occur in various CRM and Collections forms.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.