APP-JTF-210604 Error: An unexpected error occurred in jtf_grid.populate

(Doc ID 2291423.1)

Last updated on DECEMBER 19, 2017

Applies to:

Oracle Common Applications - Version 12.1.3 and later
Information in this document applies to any platform.


When attempting to test metadata definition, the following error occurs.


jtf_grid.populate package reports errors:

An unexpected error occurred in jtf_grid.populate

datasource: <IEX_COLL_TRX_DTL>

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: "REFERENCE": invalid identifier
ORA-06512: at "APPS.JTF_GRIDDB", line 837
ORA-06512: at "APPS.JTF_GRIDDB", line 878

Same errors in Navigation: CRM Administrator -> Spread Table -> Meta Data Administration.
Query data source: IEX_COLL_TRX_DTL
The seeded view should be: IEX_TRANSACTIONS_V .
From that screen, click on the Test tab, then the Test button.

The issue can be reproduced at will with the following steps:
1. Navigate to CRM Administrator Responsibility-> Spreadtable/Meta Data Administration.
2. Search for data source as IEX_COLL_TRX_DTL.
3. Go to Test Tab and press test button to test the definition. Encountered with error.

The issue has the following business impact:
Due to this issue, users cannot test metadata definition and facing the error in Collection form while using this.


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