My Oracle Support Banner

OFSAA T2T After Edit Gives [8368] MANDATORY COLUMNS ARE NOT MAPPED [9024] DO YOU WANT TO CONTINUE? Pop-Up Message (Doc ID 2551534.1)

Last updated on SEPTEMBER 13, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Enterprise Performance Management (EPM)
Table to Table (T2T) Data Mapping
Data Management Tools (DMT)

Symptoms

On OFSAA 8.0.7 after edit of a T2T and adding a new Expression, after clicking OK, the T2T fails to save.

ERROR
[8368] Mandatory Columns are not Mapped [9024] Do you want to continue?

Deployed Web Server OFSAA.log error:

[02-05-19 10:19:18 AM] [DEBUG] [WEB] [NA] [DMT] [Util]~[logThis]~[DMT SERVICE OJFF]Transformation Or Expression present.
[02-05-19 10:19:18 AM] [DEBUG] [WEB] [NA] [DMT] [Util]~[logThis]~[DMT SERVICE OJFF][Util] complete source entity : {"type":"FUNCTION","attribute":{"length":null,"scale":null,"precision":null,"ordinal":null,"parent":null,"ispartition":false,"phyname":"V_PRODUCT_TYPE_CD","ismandatory":false,"idenincrement":null,"partitionvalue":null,"logdatatype":"Number","fieldorder":"-1","querykey":null,"startpos":null,"fieldformat":null,"nullif":null,"defaultif":null,"datatype":null,"isprimary":false,"complextype":null,"expr":"CASE WHEN STG_LOAN_CONTRACTS.V_LOAN_TYPE='CL' THEN CASE STG_LOAN_CONTRACTS.V_PRODUCT_TYPE WHEN 'FIXED' THEN 12120 WHEN 'LIBOR-FLOAT' THEN 12119 WHEN 'LIBOR-TR' THEN 12121 WHEN 'TIER1' THEN 12112 WHEN 'TIER3' THEN 12113 WHEN 'VARIABLE' THEN 12111 ELSE 5199 END END","isidentity":false,"logname":null},"phyname":"EXPRESSION","attributes":null,"logname":null}
[02-05-19 10:19:18 AM] [DEBUG] [WEB] [NA] [DMT] [Util]~[logThis]~[DMT SERVICE OJFF][Util] complete target entity : {"type":"APPEND","attribute":{"length":"5","scale":"","precision":"","ordinal":"282","parent":null,"ispartition":false,"phyname":"PRODUCT_TYPE_CD","ismandatory":false,"idenincrement":"","partitionvalue":"","logdatatype":"Number","fieldorder":"-1","querykey":null,"startpos":null,"fieldformat":"","nullif":"","defaultif":"","datatype":"NUMBER","isprimary":false,"complextype":null,"expr":null,"isidentity":false,"logname":"Product Type Code"},"phyname":"FSI_D_LOAN_CONTRACTS","attributes":null,"logname":"Loan Contracts"}
[02-05-19 10:19:18 AM] [DEBUG] [WEB] [NA] [DMT] [Util]~[logThis]~[DMT SERVICE OJFF]Exception Occurred : null
java.lang.NullPointerException: null
at com.ofs.aai.service.dmt.ojff.Util.getcompleteDestTableFamilyExt(Util.java:1097) ~[aai-dmt-ojff.jar:?]
at com.ofs.aai.service.dmt.ojff.Util.getDestTableFamily(Util.java:895) [aai-dmt-ojff.jar:?]
at com.ofs.aai.service.dmt.ojff.DMTDMDetailed.saveForm(DMTDMDetailed.java:2309) [aai-dmt-ojff.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_141]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[?:1.7.0_141]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_141]
at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_141]


The issue can be reproduced at will with the following steps:
1. Create new Expression as:

CASE WHEN STG_LOAN_CONTRACTS.V_LOAN_TYPE='CL' THEN
  CASE STG_LOAN_CONTRACTS.V_PRODUCT_TYPE
  WHEN 'FIXED' THEN 10000
  WHEN 'LIBOR' THEN 20000
  WHEN 'VARIABLE' THEN 40000
  ELSE 30000
  END
END

2. Attempt to save

Changes

 

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
Changes
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.