My Oracle Support Banner

UWQ Task APP-JTF-210604: Program error (Doc ID 2394677.1)

Last updated on JANUARY 09, 2025

Applies to:

Oracle Universal Work Queue - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Universal Work Queue

UWQ Task Error

Getting a series of errors in Universal Work Queue when using task functionality and completing/closing tasks.

-----------------------
APP-JTF-210604: Program error: Please inform your system
administrator or support representative that

jtf_grid.populate package reports error:

An unexpected error occured in jtf_grid.populate

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

ORA-00904: "COLLECTOR_RESOURCE_ID": invalid identifier
ORA-06512: at "APPS.JTF_GRIDDB", line 837


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

The error stack is (first 1000 bytes)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to collections form
2. Create task
3. Close the task
4. Go back to UWQ and Refresh All Work
5. Error occurs


Cause

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
Symptoms
Cause
Solution


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