My Oracle Support Banner

JSON Parse Exception while viewing T2T in MDB Screen (Doc ID 2795248.1)

Last updated on FEBRUARY 27, 2022

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.9 and later
Information in this document applies to any platform.


Problem Description

While trying to view T2T in Metadata Browser(MDB) screen, following error occurs.



MDB.log(Deployed Layer)

[29-06-21 15:25:02,057 GMT PM] [INFO ] [WEB] [T2TLayoutImpl][formQuery]Final query to get rows - SELECT "V_SRC_TABLE_NAME", "V_SRC_COLUMN_NAME",
"V_DEST_TABLE_NAME", "V_DEST_COLUMN_NAME", "IFRS17" FROM rev_object_repository_tl rtl left outer join mdb_etl_mapping mem on upper(rtl.object_name) = upper(mem.v_definition_name) LEFT OUTER JOIN TAB_COL_UDP_LIST_VIEW ulv ON upper(v_src_table_name) LIKE upper('%@@' || table_name || '%') AND upper(v_src_column_name) LIKE upper(column_name) WHERE rtl.object_def_id = ? offset ? rows fetch next ? rows only
[29-06-21 15:25:02,069 GMT PM] [ERROR] [WEB] [RequestController][parseRequest]MDB-0004 java.lang.Exception: MDB-0004
at com.ofss.fsgbu.mdb.service.controller.utils.ControllerUtils.invokeActions( ~[mdb-ui.jar:]
at com.ofss.fsgbu.mdb.service.controller.RequestController.parseRequest( ~[mdb-ui.jar:]

Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "IFRS17": invalid identifier

at oracle.jdbc.driver.T4CTTIoer11.processError( ~[ojdbc8.jar:]
at oracle.jdbc.driver.T4CTTIoer11.processError( ~[ojdbc8.jar:]
at oracle.jdbc.driver.T4C8Oall.processError( ~[ojdbc8.jar:]
at oracle.jdbc.driver.T4CTTIfun.receive( ~[ojdbc8.jar:]

 Steps to Reproduce
Metadata Browser >> Applications >> Drill down till 'Data Mapping' task

Business impact
Unable to view T2Ts from MDB


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.