You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Oracle BI Report > Parameter based on LOV having string limitations

edited Aug 25, 2021 1:07AM in Reporting and Analytics for ERP 8 comments

Summary

Oracle BI Report Parameter dissappeared due to long string value on list

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!