Do you have a string that contains &ampersands? IF this is in an Element of the XML it can trip up a parser. Check out the use of a CDATA element to allow the & Tim

BIP has a set of REST API services. You would need to call the runreport service from the DB (doable). https://docs.oracle.com/middleware/12213/bip/BIPAP/api-Manage Reports.html Tim

Hey Daniel I see that you saw the compatibility mode option on the stackoverflow answer and got past this issue. Yes, its time to upgrade :0) Tim

Hi Luis Look at turning off the border line on the table in the template and see if that gets you what you need. It will still be multiple rows but the reader of the report will only see one. Tim

Hi Thiagu BIP can handle XLS/XLSX as inputs for a report. So you can place all the emps in a single column and load them into a data model. Each time the report runs it will look for the file to process it. Check the BIP documentation for more on Excel data sources Tim

Hi John Couple of points. 1. The set|get variable functions were created because native XSL does not support the concept of an updateable variable. It has variables as you might read but these are more like constants. XSL wants you to use recursion to handle updating values. In a complex report, things can get a little…

You need to be on 11.1.1.7. Check the documentation on the migration from 11g to 12c. Documentation is here: https://docs.oracle.com/middleware/1221/core/BIMIG/GUID-D0867450-1AEF-43DE-8144-7816F7105CB1.htm#BIMIG-GUID-D0867450-1AEF-43DE-8144-7816F7105CB1 Tim

As long as we are talking about migrating catalog objects and roles. They are completely compatible. Not sure I have seen any official docs on it but the process is pretty straightforward ie as if you are moving objects frm dev to prod Tim

Hi Is this in the context of a BI Publisher report? If so, does the query work outside of BIP consistently? Can you reproduce the issue at will ie with a specific transaction? All BIP is doing at runtime is handing the query over to the DB for execution. Its prolly worth running the report with the debugger on to see whats…

In the link above that I gave you, it states 4.4.1.7 Specific Dates Add Date - use the date selector to enter the specific date and time to run the job. Add multiple specific dates as needed. So, when you schedule the report you can add all of the dates you want the report to execute on. I hope that helps Tim

Hi A Get out the books and find the section on scheduling on specific dates https://docs.oracle.com/cd/E28280_01/bi.1111/e22257/create_rpt_jobs.htm#BIPUG204 Regards Tim

In the chart dialog box under the Slice Label section you can set the number of decimals using the Decimal Digit field - its takes integer values. For other features that are not exposed in the properties, This document Graph_FAQ_with_style will answer many questions. The old Oracle Reports and BIP share a charting engine…

So, we have been conversing on another thread. What is the command you are using in the 1. Pre fetch data trigger - https://docs.oracle.com/middleware/12213/bip/BIPDM/GUID-757ABC83-8CBC-4660-84CE-B8C1D48F7498.htm#BIPDM-GUID-BBCC37B1-40C… 2. Pre Process Function -…

This should help on using the @section command https://blogs.oracle.com/xmlpublisher/anatomy-of-a-template-ii-headers-and-filler Check the docs too. It also supports headers for each invoice too Tim

Hi SBassabe Clearly there is some difference between your dev and test environments? Googling gets a few hits on this issue but not specifically for the invalid document structure e.g. https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/1913713_1.htm… The error appears…

Hi The error is coming from the DB not from BIP. Its tough to help without more information 1. What version and flavor of BIP are you using? 2. Whats the SQL you are using? Does it have parameters? 3. Are you using any plsql trigger code? Tim

what is the session identifier for? Tim

Ahhh I see now. It would require an enhancement request to create a proxy variable for the server that could be accessed out of the box in your templates. For that you need to log an SR with support who will log the enhancement for you. There are a couple of workaround I can think of 1. Create a table in the db to hold the…

Hi This could be a file cache issue, but Im not sure you can clear that on your own. A quick google and there are hits on a document in Oracle Support (I dont have access, hopefully you do to get the solution) check this link out - https://support.oracle.com/knowledge/Oracle%20Fusion%20Applications/1940857_1.html Tim

Hi Antoine You need to use a group left layout in word and a for-each-group command to achieve this. Word is not great at nested tables which is what you need. Your best approach will be to use the report wizard in the Word BIP plugin. It will get you the layout and the fields you need. The plugin does not use nested…