My Oracle Support Banner

"There are too many characters." Error in View SQL or Validate Screen for T2T (Doc ID 2881611.1)

Last updated on JULY 13, 2022

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.1 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)


On AAI the View SQL screen when editing any T2T like T2T_FSI_D_CASA is showing the following error in the screen:

"There are too many characters."

The issue can be reproduced at will with the following steps:
1. Navigate Select T2T_CASA, Active = Y
2. Under Mapping Details click Map
3. Under Target Table Map Details
4. Select all and then select 'Validate' or 'View SQL'
The error occurs in bottom window.

The same steps above work in instance.




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.