E1: RDA: In Report Design Aid (RDA), the String Value Assigned Through Direct Assignment (e.g. szNewVariable = szOldVariable) Will Be Truncated to Maximum 256 Characters, When the Source Variable Value Has More Than 256 Characters (Doc ID 3049199.1)

Last updated on OCTOBER 01, 2024

Applies to:

Symptoms

When using Media Object API to fetch a media object text attachment longer than 256 characters, the value which is assigned to the variable used in the API call will hold the whole string including the line endings.
This is according to the Note ID 867608.1 - E1: RDA: How to Create a Report Variable to Display a String of More than 256 Characters
If the value assigned to the aforementioned variable is directly assigned to a second variable of the same type and size (based on the same data dictionary item), the new variable will hold a text value which is truncated to 256 characters.
If both variables will be used for example in a report output the output will look like this:

Steps to replicate the issue:
1. Create a custom report where Media Object API will fetch the text media object attachment and assign it to a data dictionary based report variable (e.g. MOTextSystemFunctionValue is the name of the report variable which will hold the fetched the media object text attachment).
2. Assign to a second report variable, the value of the variable used by Media Object API (e.g. RV MOTextAssignedValue = RV MOTextSystemFunctionValue)
3. Run the report and notice that the MOTextSystemFunctionValue field shows the whole text, while the MOTextAssignedValue shows the text truncated to 256 characters)

Cause

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