I think the failure jobs are storing in XMLP_SCHED_JOB(status column) , you can create simple query on top this tables to retrieve failed jobs for a time and you can re-run again , OR You can setup notifications for each report that will send notification to your email (success , warning or failure), Setting Up Delivery…

can you try this link https://blogs.oracle.com/xmlpublisher/formatting-concatenated-datasources can you upload xml and rtf document?

follow oracle user guide https://docs.oracle.com/cd/E28280_01/bi.1111/e22254/create_rtf_tmpl.htm

1) xml data retrieval time in data model and data retrieval time in sql developer are almost same , both will use jdbc connection. 2) response time will definitely vary based on output records , lower records lower time and more records more time ,so for 500 records and 12k and 60k response time will be different. 3) what…

also apply below configurations To Improve Performance it is good to have the value for the following parameters set to True under the report level: -Use BI Publisher's XSLT processor - Enable scalable feature of XSLT processor -Enable XSLT runtime optimization

can you post the bipublisher.log ? OR after you run data model then click on view engine log , Thanks log contain detailed information to debug , Thanks

please post how you want to display in report , i.e sample output , Thanks

Might be due to multiple schemas in the database and bip unable to choose among one , add schema name infront of table as select from schema_name.table1 Thanks

please go through doc https://blogs.oracle.com/xmlpublisher/lexical-reference-problems

have you defined a parameter in pl/sql package for this data model in new migrated bip environment ? please do , if you can able to pass parameter directly in the sql queries instead of dynamically displaying where clause using pl/sql package , please post complete data model code , Thanks

Just rename extension file .jsp to PDF , Thanks

upload rtf and xml , Thanks

same condition: <?if:field_name=''?> - <?end if?> --------if you want to replace null with - <?if:field_name=''?> '-' <?end if?> ---if you want to replace null with '-' OR <?xdofx: nvl(field_name,'-')?> , OR <?xdofx:replace(name,'','-')?> still if you find issue , upload RTF and XML.

<if:sum(current-group()/BUDGET)=0?><?'-'?><?endif?> http://www.oracleerpappsguide.com/2014/06/how-to-use-if-else-conditions-in-xml-publisher-rtf-template.html

Can you change the browser ? are you able to upload template to bip server ? only PDF is not generated or other outputs too ? please upload xml and layout ?

what is your data source ?

Try below https://blogs.oracle.com/xmlpublisher/continued

please upload xml and template , Thanks

tell me first , how you created template for the report ? is it RTF template or default bi publisher Layout ? when you view in PDF output what is the error or message you are getting ? Thanks

yes possible , you can create parameters in data model but can hide at report level , first create data model with parameter, then create report , edit the parameter tab in report screen,where you have to disable the parameter for the report , assign default value like 'novalue' for the parameter, same value has to be…