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.

Symptoms

Problem Description

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

 



Error

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(ControllerUtils.java:53) ~[mdb-ui.jar:8.1.1.0.0_1613540081]
at com.ofss.fsgbu.mdb.service.controller.RequestController.parseRequest(RequestController.java:69) ~[mdb-ui.jar:8.1.1.0.0_1613540081]

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

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) ~[ojdbc8.jar:19.3.0.0.0]

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

Business impact
Unable to view T2Ts from MDB

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
References


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