Hi , Please follow the below in link, it is nice with good example https://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-em…

You can use below in xslfo. Please note that division operator is Div in 11g onward . Before that division operator was / in 10g <?xdofx:to_number((A+B)*100 Div (C+D))?> In core XSL you can write below <xsl:value-of select="number((A+B)*100 div (C+D))"/>

Sorry somehow missed this thread. You can follow the below steps 1. Add column CEIL(ROWNUM/65000) COUNTROW as new column in the query which is generating the line details. 2. in the group create new group G_COUNTROW and place element as COUNTROW on and under that your remaining line level detail will be there in same line…

Hi , To access other database in oracle is possible through DB link...you can follow below steps if it helps 1. Can have DB link to all the distributed database....lets say DBLINK1, DBLINK2, DBLINK3, DBLINK4,......etc 2. Create list of value as a parameter where you can select distributor name...lets say…

If I understand your requirement correctly...you want to run report with same tables which is lying in the different database? If I am correct...could you please provide below details 1. Do you have all the database access you are talking about? In simple word your report definition will store in one database and actual…

Hi, You can create tags and put your xsl template code there....and call as bellow. Please note in each tag you can put only 240 characters so you need to create number of tags so that you can place all your template code: E.g. I have below xsl code and I put in three tags <xsl:template name="Brajesh"> <fo:inline…

You need to change the way you are generating your XML. Please generate the XML as below way <Header1> <Detail1> </Header1> <Header2> <Detail2> </Header2> <Header3> <Detail3> </Header3> . . . .<Total> </Total>

Did you try below Note by any chance ? Java.lang.ArrayIndexOutOfBoundsException When Uploading BI Publisher Reports to Clustered Environment (Doc ID 1929440.1)

DO you have rtf or excel template?

XDO_SHEET_? (you can specify the condition to move the data to new sheet) and XDO_SHEET_NAME_? are the tags name using that you can specify your condition and can rename the workbook name. Refer the below document for more details BI Publisher: How to create Multisheet in Single Excel file using Excel Template (Doc ID…

This is possible in database side only..... From your period table you can select the Min(Start_date) and max(end_date) group by each quarter.

If your data is like You can write below sql SELECT QUARTER_NUM, MIN(START_DATE), MAX(END_DATE) FROM <Period_table> WHERE PERIOD_NAME LIKE '%17' AND application_id = 200 AND ledger_id = 2021 GROUP BY QUARTER_NUM order by QUARTER_NUM; Alternatively if you want to get start date and end date of current quarter, you can add…

From where you are getting value for :PM_BUYER bind variable. I believe this should be one of the column name from parent sql. so where clause should be (buyer = nvl(:buyer,buyer))

After all change still we are getting same error and also before report trigger package(BPHXC_PROJTIMECARD_UTIL.Generate_otl_emp_rtc) what I got from you is different than what message is appearing in latest message(PBHXC_PROJTIMECARD_UTIL.Generate_otl_emp_rtc) ...this may indicate that, are we using same code what we are…

What is the type of parameters ? Can you try Parameter type Menu

Hi , to_number is xdofx function, so its mandatory to use xdofx if we to_number. And also <?call:template?> inside if is not possible because of nested xml tags (<??>) So Please use below xsl code to achieve your requirement. 1. Create one XML placeholder tag. 2. Put the below code in the tag <xsl:if…

....Please follow the below steps 1. Do not declare your trigger with IN Parameter. Signature of before report should be FUNCTION Generate_otl_emp_rtc RETURN BOOLEAN; 2. You can directly refer the XML Data template parameters to trigger body. So no need to call the beforereport trigger by passing parameters. Call like…

Please try below <?xdofx:to_char(to_date(replace('2017/12/21','/','-'),'YYYY-MM-DD'),'dd-mon-yyyy')?>

Hi , In this case you need to adjust the space in the page body in such a way that it can only take 11 lines. and if next line come it should go on next page. You can see from the below template I have some table in the footer(its hidden table for understanding I have highlighted the table borders) that table controls the…

As you mentioned you need 11 lines to print if customer header detail you are printing in the top of line table. So add the number of lines in footer to restrict body size to print only 11 lines. Number of lines in footer depends on your page size...so one by one you need to add lines and check the lines in body. In this…