Request you to upload correct package specification, body and XML data template...

Not Sure about BI Publisher. But in Fusion and Oracle Report we control Parameter dependency by the Value Set. Value set : It is nothing but list of value we attached to the report parameter. So that while running report user can see only those parameter which is relevant to them. Could you see if you have such option…

You cannot put nested <? ?> in XML tag. The correct syntax is <?if: to_number(TOTAL_AMOUNT) > 25000 ?> <?call:jack?> <?end if?>

Hi , You are calling BPHXC_PROJTIMECARD_UTIL.Generate_otl_emp_rtc from the Before report trigger but the code you have pasted is package XXBP_PROJTIMECARD_UTIL. Could you have a look?

I tried to load the data into excel and extracted it using preview option it ran fast without performance. So template looks good. Is this fast for 4-5 reports or then also excel download is slow?

Excel export is slow for 4-5 rows also? or it slow for more than 1000-2000 rows? Because when I generated the output it was 4 records in excel and it exported fast

This happen when you have merge columns in Excel. Each merge takes some KB in excel and suppose you have 1000 rows in report and some 5 merge columns then size will be in 4-5 MB and report will take time to open. Try to minimize your merge cells and see the performance. Most likely this will solve the issue else we will…

If possible please upload you template and sample XML to debug further

Looks like there is problem in your package BPHXC_PROJTIMECARD_UTIL.Generate_otl_emp_rtc. Could you please check parameter P_ORDER_BY_TXT is declared in your package

Could you follow the Note "Unable To LOad Data Source (Doc ID 2235407.1)" if this help

Could you please upload the rtf and sample xml

Yes you are correct. Its something to do with table alignment, that can guess only by seeing rtf

do your report contains any special character?

Thank you, I got my answer. So If i am right this report is running from Primavera then you are facing this issue. As you also mentioned this could be P6 issue so could you check if any setting is available in Primavera to change the name of attachment.

Hi, If you want attachment as message body, then you can use your message body as HTML tags and from the HTML you can call PDF file to embed that as body. Let me know if you face issue in syntax? Regards, Brajesh

Hi, I am not referring, I mean where you are using your rtf Oracle fusion , OTBI and Oracle application or any other platform?

Could let me us know what is your repeating group tag e.g. batch, payment, invoice etc.? based on that you can use for-each or for-each-group

Hi , Its all about adjustment of table layout in RTF. It will be helpful if you can upload your rtf and xml

Which platform you are running the report?

Can you see server name, port number etc. in the busting file is correct and configure correctly in Production ? check with DBAs if from the mail delivery side all the server and port level configuration is up and running and please upload the log file if you have any?