Concurrent Program Name with Parameter and Value set Posted by Dayakar k at 04:35 Labels: APPS QUERIES On request here is the query to list concurrent program name with its parameter, values set and default value/type. ![]() Issue: ------ The BI Publisher Report with excel output is splitting lines into separate rows for the same record. Findings: --------- As per my analysis, carriage returns on the field is one of the reason for row splitting on BI Publisher Report. Oracle BI Publisher report output generator cannot identify those non-human readable carriage returns. I continued my analysis and found out there are similar issue with some others fields also and Swiss characters are not creating this issue. I tried to create a prototype to replace those non-human readable carriage returns symbol with spaces. Finally the prototype has been successfully created for both the fields in test instance. Hopefully this solution has been successfully fixed the row splitting issue. Drakorindo running man eps exo. Solution: Edit the data definition XML file and for each field with carriage return char with space replace with following: TRANSLATE(TRANSLATE(htv.TCRD_COMMENT_TEXT, CHR(10),' '), CHR(13),' ').
0 Comments
Leave a Reply. |