Can you share steps on how you manage and run the report

Hi Rose You are talking about UBEs so the report is running inside another application? What version of BIP are you using? You should check the caching level for the report in the report properties. Check the user docs here :…

Pleased you have it working :0) Some points would be greatly appreciated at this point (excuse the pun)

Ahhh ... thats a slightly different question. You don't want the minimum value, you want the invoice number that has the lowest amount correct? For that I'd use a second query to get that id, something like select invoice_num from invoices where rev = (select min(rev) from invoices) You could do it in the template but…

I dont have time to check right now but you might take a look at two posts I wrote a while back on conditional charts https://blogs.oracle.com/xmlpublisher/conditional-charting https://blogs.oracle.com/xmlpublisher/conditional-charting-ii Read both before starting anyting and note they are both for RTF templates. They both…

How do you want the report to behave? I would push back against the business and ask them how they want things to behave. If you want the tables kept together and they are collectively too big (rowwise) to fit on the first page, then they will get moved to the second and so on. The renderer can not squeeze the tables down…

1. The barcode font being used is the one you downloaded from here:https://www.dafont.com/fr/code-128.font I know its that font because I can reproduce the issue only with that font. Using the BIP code128 barcode, you will not get regular charachers in the barcode. So, that font is still in your system somewhere and is…

Hi When you say uploaded image? Is that into a directory or into a DB? BIP can handle both but it makes a difference. If its into a directory and assuming BIP has access to that directory or there is a URI that can be used to access the image. Check the docs here:…

1. We need to investigate the file thats generated ie open it in notepad or try unzipping it and check that it is an xlsx file 2. Can you try HTML or another format to see if you are getting all the rows? The table template was a check to see if your original template had some kind of filter on the data. Tim

I think you have mixed up the fonts. I would 1.remove the fonts from the windows/fonts directory on your local machine 2. Then do the same on the server with the font that you downloaded. 3Now install the BIP delivered font from the Template for Word/fonts directory into the windows/fonts dir 4Use the font in the template…

Are you using the for-each@section for the grouping in your template. This will reset the pge numbering for you Tim

The keep lines together will not affect the tables and they will split. When the BIP renderer runs it will work out how much room there is on the page for the data rows to be dispayed. IF there is not enough room, it will break across a page. The simplest way to force the renderer to move tables together to the next page…

Well you need to get at the logs. The default setting will not give you much. Follow instructions on my post here to get a more detailed log of whats happening https://blogs.oracle.com/xmlpublisher/debugging-bip-under-ebs Tim

Ensure all your report code ie anything contained in <? ?> is inside a gray formfield.As someone wlse has mentioned you can use simple if statements rather than a choose to speed up the report. You would have something like <?for-each:ROW?><?if:C.PLAN_TYPE=10?> Health Insurance xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx <?end…

Just adding to 2807661's answer. Its not a push to run the report as soon as there is a new record in the table. Its a case of setting up a BIP report with the trigger to look for a new record and putting that on a very regular schedule. IF you are expecting new records every hour then set the schedule for 30|15|10 mins so…

The BIP Code 128 fonts are available in the BI Publisher installation directory. There is a fonts directory under the Template Builder for Word directory. Install the Code 128 font into windows and use that in MSWord. Once on the server, BIP will pick up the font and use it Tim

Hi BIP has the concept of variables (check the docs) so you could create a variable x to hold an initial value of say 10000. In the loop, check the value of the calculation against the variable value and update it accordingly. At the end of the loop you would have the lowest value. TBH thou, I think I would push all of…

Hi K Just checked the docs and as I thought. The digital signature can only be added once to a report output https://docs.oracle.com/cd/E23943_01/bi.1111/e22255/digital_sig.htm#BIPAD4712 Step 6: Specify the location in the document where you want the digital signature to appear by setting the appropriate properties as…

K Im not sure if I was clear enough. In the documentation, it states that BI Publisher only supports a digital signature on the first page. You could look at the Digital Signature API here, https://docs.oracle.com/cd/E24001_01/bi.1111/e18863/javaapis.htm#BABDDIFA to see if you can add more digsig fields to the generated…

Hi If you want to pull the attachment files and zip them and then attach them to the BIP output. Thats a post processing step for your code. The BIP APIs that I mentioned could help you out but that functionality would reside in your code ie BIP can not pull, zip (or not zip) and attach on its out, out of the box. Regards…