https://docs.oracle.com/middleware/12212/bip/BIPAD/GUID-A9AF337A-7A62-4BCB-B22A-7ECBCCB2869E.htm#BIPAD4858

it clearly says java.lang.OutOfMemoryError: Java heap space , increase memory for the server where report server is running

what is the version ?

merging reports in BI Publisher if it's possible to merge two or more .rtf templates in BI Publisher based on a condition use sub templates to call other template within one template based on condition. create two rtf templates rtf1 and rtf2 then open rtf1 and call rtf2 using RTF conditions.…

could you able capture queries when report job is failed? then you can easily find the error what causing error , while scheduling report there is option in diagnostic tab to choose log files , select last option then schedule report. whenever report failed , upload log file using report failed time stamp, you can find…

you have to logon with administrator user

Issue might be due to cascaded parameters that some parameters depends on other. Is the scheduled report or on demand ? please gather param values when report got failed. better schedule the report and enable diagnostic log file in scheduler page when the report is failed then you will know where exactly the report is…

You cannot achieve all with Default BIP Layout , its only for creating simple straight farward report , I guess reports created using bip layout is not much complex and recreate it using RTF in 10 min. if you want to achieve requirement you must follow RTF template.

Do you know how frequent the report is getting failed , the issue is with cascaded parameters (refresh parameters on change) , please check :p_bu does not have any data issues like in place of number there nay be symbols in the data. does all the parameters are fixed values from database or keep on changing ?

what is the configuration followed for adding font ?

If there is no common relation what is the purpose of combining two data sources into 1 , you can create two reports as separate. please check what is business logic combining two sources. Thanks

so your requirement is to show two reports data one after the other in one pdf ? if yes ,then create two data sets in single data model then generate xml , create two tables for each datasets groups in rtf template.then click preview then result pdf is combination of two data sets data.

you can easily achieve requirement using RTF template , please upload direct xml file and uplosd here , i will send you new RTF template. Thanks

using RTF template you can generate output in excel , pdf , html etc.

looks problem is with multiple selection of param values in data model , what is the bip version and post screen shots of LOV query and set up in parameter section.

https://blogs.oracle.com/xmlpublisher/formatting-concatenated-datasources please follow above link , let me know if you have any issues.

once you linked both the data sets ,generate xml and create RTF as usual ,then use this formula xdofx:nvl(COL2,COL1) in place of column that replace values. Thanks let me know if you have issues.

please upload RTF template and xml, Thanks

Yes it is possible , but you should have xml attribute in your data model data. example : you should have a password or SSN for each customer in xml data to have dynamic password protection.…