are you able to generate output in any other format ? are you using interactive mode for layout or any template like RTF , PDF etc

for BI Publisher the date should be in Canonical format like ‘YYYY-MM-DD’ or ‘YYYY-MM-DDTHH:MI:SS’ format. create the column in your SQL query , so the data is already formatted per requirement.

SBassabe, what user are you using ? if you are not already using the Admin user, can you try with that... another approach is to try putting this on a new dashboard and rule out any permission issue .. Thanks, Yugandhar

is the issue resolved ?

Vineela, You will not be able to change the catalog type "BIP 12c introduced the change that the catalog type is hard coded depending upon the products installed: if BIP is integrated with OBIEE, then the catalog will be set to "Oracle BIEE Catalog", if BIP is standalone, the catalog will be "Oracle BI Publisher- File…

Can you try Excel (mhtml) output ? As i assume the columns /rows are being merged ? Also check Generating an Excel Output With a RTF Template Columns and Rows From a Table Are Combined Or Merged (Doc ID 1590858.1) --Yugandhar

Rajesh - I assume this is for multi language looking at the control file you have provided ? if yes the use it in the filter condition .. refer to the link provided below http://garethroberts.blogspot.com/2010/08/ebs-bursting-filter-on-xml-elements.html

Vivek - please check the below article https://blogs.oracle.com/xmlpublisher/how-to-audit-and-monitor-bi-publisher-reports-access Hope this helps. --Yugandhar

Rajesh - Please see some good samples from XMLP Blog In Depth Apps - Oracle eBusiness Suite - Gareth Roberts: BI Publisher EBS Bursting 101: A tutorial/case study including … https://blogs.oracle.com/xmlpublisher/e-business-suite-bursting Hope this helps --Yugandhar

Verify the bipublisher.log file during the time frame of the error message and at-least you will get an idea.

Anwar - I do not think the MAXIMUM is supported function .. is there a chance you can apply the logic in your DM ?

Please review the following note Need the Names of Scheduler Tables in 11.1 of BI Publisher (Doc ID 1618405.1), all the schedule information is stored in the listed tables • XMLP_SCHED_DATA • XMLP_SCHED_DELIVERY • XMLP_SCHED_JOB • XMLP_SCHED_OUTPUT Hope this Helps

In your RTF template , you can put in a condition like IF ROWCOUNT > 0 CURRENT TABLE ELSE MESSAGE END IF Samples for COUNT https://blogs.oracle.com/xmlpublisher/counting-distinctly

As Brajesh mentioned you do not get BI Publisher when you install Peoplesoft. For basic training follow the link for oracle by example series http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bip/tb4word/tbwordbip.htm If you are looking for advanced training check out courses in Oracle Training Oracle Job…

When you create the DB connection in BI Publisher are you using APPS user ? if not make sure the user that is being used has the appropriate access to read and execute.

please check the following sample https://blogs.oracle.com/xmlpublisher/check-print-template hope this helps

Did you try using Event Triggers ? Check the XDO user guide for more info

verify the template for any blank spaces after the form field and / or any where is the template, easy way to identify is enabling the paragraph marks in MS word..

check the following blog post there is very good info on charts http://bipublisher.blogspot.com/2009/03/bi-publisher-charts-tips-and-tricks.html

Hello, Just checked your data file and it has the line breaks .. so a better way to handle this would be break the data elements into multiple each line as one data element .. this would give you more control on formatting ... Hope this helps.. --YG