SH.SHIPMENT_GID=nvl(:P_SHIP_ID,SH.SHIPMENT_GID) , This will not handle multiple input values at a time. Use this condition SH.SHIPMENT_GID in(:P_SHIP_ID) instead of above.

for single input value the report runs fine ? problem is with query , can you post the query ?

Just close this thread with correct answer and then open new thread.

Log an SR to Oracle.

what is your bip version ?

Try this to_char(auth_date,'dd/mon/yyyy')

https://blogs.oracle.com/xmlpublisher/watermarking-ii

http://www.oracle.com/technetwork/middleware/bi-publisher/overview/bip-webdav-sharepoint-integration-130172.pdf https://rseshan.wordpress.com/tag/bi-publisher-sharepoint-integration/

I got this from the log... is the error related to the size of XDO_USER_ROLES Can you post list of roles of user who are trying to run ? Also run same query with user who has bi consumer role.

Issue is with one single report or group of reports ?

https://blogs.oracle.com/saas-fusion-app-performance/bi-publisher-memory-guard-performance-monitor

Are You directly updating the form field i.e C , use field browser and add the required code and then update , sometimes if you add directly change will not reflect , OR directly paste the code <?if:(CF_BALANCE!='0' and UNAPP_AMOUNT!='0')?>

If Your source Type is SQL Query then convert auth_date into char , to_char(auth_date,'dd/mon/yyyy') , OR use directly in the RTF template <?xdofx:to_date(SYSDATE,'dd-mon-yyyy')?>

Try to find the length of each row using length(version field name ) select * from (select version_column, length(version_column) Lnth_column from table ) order by Lnth_column

Is you issue Fixed?

If it is PDF output , then you can encrypt output , you can create dynamic password for with your logged username. refer below link Password Protect PDF Output - quest4apps Thanks

Looks Like its bug ,

Any Update?

Problem is with single report or or all reports ? have verified all the server configuration properties same in both systems (old and new system)? Run detailed log for a specific report that causing problem and get execution time for sql from log and compare this with sql execution plan from sql developer or Toad. Try to…

https://myoracleappsworld.wordpress.com/2015/03/19/to-reference-a-parent-level-element-in-a-child-level-table-bi-publisher/