Error APP-JTF-210604 when Clicking on Work Item in the Strategy Tab of an Upgraded Instance R11i to R12 (Doc ID 1673080.1)

Last updated on JUNE 07, 2016

Applies to:

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

Symptoms


In an upgraded environement, When attempting to click on the Strategy tab,the following error occurs.

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

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

grid: <IEXSTTAB_WKITEM.WKITEM_GRID>
datasource:<IEX_STRATEGY_WORK_ITEMS_DS>

The following information is available:

<null>

The error is most likely in the form or the metadata definition. Please check the following alert for the error code.

Click OK and the below error appears

ORA-00904: at "COLUMN_NAME", Invalid Identifier
ORA-06512: at "APPS.JTF_GRIDDB", line 837
ORA-06512: at "APPS.JTF_GRIDDB", line 878 


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open the UWQ
2. Click on a customer
3. Go to Strategies
4. Try to click on a work item, the error appears



Changes

 Upgrade from 11i

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