Collectors Work Queue (UWQ) Gives Error APP-JTF-210604 after Upgrade 12.2.6 (Doc ID 2286381.1)

Last updated on JULY 13, 2017

Applies to:

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

Symptoms

After upgrading to R12.2.6, when trying to open the UWQ, the following errors appear:

Error -

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

jtf_grid.populate package reports error:

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

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.


Error -

The error stack is (first 1000 bytes):
ORA-00904: "PARENT_PARTY_NAME": invalid identifier
ORA-06512: at "APPS.JTF_GRIDDB", line 837
ORA-06512: at "APPS.JTF_GRIDDB", line 878

You reviewed the view that is associated with IEX_BILLTO_DLN_ALL_UWQ and find that the following columns are missing from the view IEX_CU_DLN_ALL_UWQ_V:

IS_PARENT_PARTY
PARENT_PARTY_ID
PARENT_PARTY_NAME

 

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