My Oracle Support Banner

[4518] Code Cannot Be Blank and Unexpected Character ('~' (code 126)) Error When Updating OFSAA 8.1 T2Ts (Doc ID 2779378.1)

Last updated on MAY 26, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version to [Release 8.1]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI / AAI)
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
File to Table (F2T) Data Mapping
Data Management Tools (DMT)


On AAI when attempting to save most T2Ts, the following error is thrown in the UI when saving:

[4518] Code cannot be blank

In the Web Server nohup.out file:


Calling loadFilterCheck
Enter into invokeLoadFilterCheck method for :: com.ofs.aai.service.dmt.ojff.DMTDMDetailed
Calling loadFilterCheck
Enter into invokeLoadFilterCheck method for :: com.ofs.aai.service.dmt.ojff.DMTDMMapper
Calling loadFilterCheck
com.fasterxml.jackson.core.JsonParseException: Unexpected character ('~' (code 126)): was expecting comma to separate Object entries
 at [Source: (StringReader); line: 1, column: 82622]
at com.fasterxml.jackson.core.JsonParser._constructError(
at com.fasterxml.jackson.core.base.ParserMinimalBase._reportError(
at com.fasterxml.jackson.core.base.ParserMinimalBase._reportUnexpectedChar(

After further debugging, the issue appears to happen when using '' in ansijoin like the following:

ORIGINAL: dim_org_Unit_b.org_unit_code = stg_<table>.v_org_unit_code
CHANGE: dim_org_Unit_b.org_unit_code = REPLACE(stg_<table>.v_org_unit_code,' ','')

After saving it, then upon re-opening the T2T, this is what is in the ansijoin on the screen:

dim_org_Unit_b.org_unit_code = REPLACE(stg_<table>.v_org_unit_code,' ',''~)

If backing out this part: ''~) and retype this: ''), then able to save it along with any other changes.

The issue can be reproduced at will with the following steps:

1. Navigate Common Object Maintenance -> Data Management Tools -> Data Mapping
2. Edit existing T2T
3. Attempt to Save


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.