https://www.youtube.com/watch?v=WdQdS48wmtA

<?xdofx:to_date(SYSDATE,'dd-mon-yyyy')?> ----if date is in canonical format. Also please mention how the p_start_date is appearing in xml file.i.e formart of p_start_date

something went wrong with your file(might be corrupted), please recreate it and test. Thanks In order to test this just remove whatever in template and create same without for-each , it will display only one record.

can you try this , select TRUNC(sysdate, 'iw')+5 AS iso_week_start_date from dual; Thanks

please mark it as correct answer.

You have to use <?for-each:root element?> in order to display each record one by one ,and <?for-each-group:root element?> is different and you are giving condition to group data based on specific element (like group by in sql). if possible upload xml and rtf files. Thanks Follow this doc Oracle BI Publisher Consulting: XML…

please elaborate your requirement , Thanks

It is working for me , might be problem with your data , upload Template and Xml ,Thanks

please post your Template Type(RTF or EXCEL ) , Output you are generating, if you are printing to html ,then there are chances of not proper alignment , please upload template and xml , Thanks

Java version will be based on your machine 32 or 64 bit. For BI publisher desktop , it is based on your ms office version. In your case , install 32 bit bip desktop for ms office 32 bit version. For java install 64 bit version. Thanks

If you want to display user input value onto to excel output then define parameter and call value. https://docs.oracle.com/cd/E28280_01/bi.1111/e22254/create_excel_tmpl.htm#BIPRD2789 6.7.1.2 Declaring and Passing Parameters

Looks like You are installed Template builder for Ms office , You wants to install in server or in your local machine ? BI publisher installation and Template builder installation both are different. For BIp Installation follow https://www.youtube.com/watch?v=8bG4UkpGqPA For Plugin installation :…

Complexity of sql is one part , along with this 1) If you want to implement data Level security for the report based on user logon.(setup is complex) 2) A data model can also be complex, including parameters, triggers, and bursting definitions as well as multiple data sets. 4) complex Layout. etc

send to venkythota54@gmail.com

So you have created parameter to filter each language data ? why don't you try next page section break in ms word (not bi publisher functionality) at the end of each if condition. This will start new page for each language data. for this ,place your cursor where you want to start section break ,Go to page Layout tab then…

Log an SR to oracle. Thanks

[100217_102905645][][STATEMENT] ReportRepository - get data model: /RPT-TMP/Mysql_connection.xdm [100217_102905648][][STATEMENT] CatalogServiceUtil - input path: /RPT-TMP/Mysql_connection.xdm [100217_102905650][oracle.xdo.servlet.resources.catalog.ResourceCatalogServiceImpl][STATEMENT] Loading: Basic…

Please upload docs ?

John , I recently faced same issue , could you upload xml and Template , Thanks

use xdofx function instead of xdoxslt , here available_date will be your tarnsaction_date <?xdofx:to_char(max(AVAILABLE_DATE),’mm-dd’)?> <?xdofx:to_char(max(current-group()//TRANSACTION_DATE),'mm-dd-yyyy')?>