Oracle BI Report > Parameter based on LOV having string limitations
SummaryOracle BI Report Parameter dissappeared due to long string value on list
Hello Community and experts,
I am building a BI report based on a SQL query, and when I add my parameters there's one in particular (p_Descripcion) that uses a LOV containing equipment description from Oracle Fusion table.
Due to there are several lenghty descriptions on this LOV like this one for example: " GUILLOTINA HIDRAULICA INDUSTRIAL ANCHO DE CORTE 490 MM 1929 Y ALTURA DE CORTE 80 MM 314 " , my parameter (p_Descripcion) disappears from the report screen along the other parameters. (See my screenshot attached).
I managed trimming spaces and special characters, making the parameters appear again on screen but when I use the parameters