How to handle the data which has a new line in it in LOV/BI Reports.
Summary:User has mistakenly entered new line in a column, where data type CLOB is text, for that the LOV value is populated in 2 line and the report parameter is not handling it, it’s getting disable. That is how the LOV is not able to handle the data to display in BI/OTBI reports.
Also in report query if we run it without any parameter, the data which has 2 lines it’s not fetched.
Let us know if any one has phased this kind of issue, please help us.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):