Then the encoder is either not working or not being called correctly. Seeing as you are using the encoder that ships with the BIP install you just need two fields in your template: 1. The register bardcode field. This lets the template processor know that you are going to be calling the barcode encoder.…

Hi I dont think the minor version of the patch will be shown in the about page. This would be a good question for the support team to clarify for you. I'd log an SR with them to check. Cheers Tim

Hi You need to provide more explanation that this one liner for anyone to be able to help. Tim

More questions ... OK, so a readable string say 123 Park Way Austin TX is being encoded as Í,È3ÂParkÂWayÂAustinÂTX-Î successfully. Assuming that, you now add the barcode font back in and get a barcode in the final output. However, the scanner can not read it, correct? Does the scanner have any settings on it to change what…

Hi Just downloaded and tested the font. I took the string and encoded it using the web site here: The string 123456789012 is encoded as Í,BXnz,VÎ Then dropped that into a word document and tested the barcoded string with my phone and it works. So the font is OK, at least for that string and that encoder. So if the font is…

Hi The PDF output does not reference fonts on the desktop like Word, Excel and HTML. The PDF has all of the fonts glyphs it uses in the file itself. Therefore you need to make the BIP server aware of the Arial Narrow font you are using ie load a copy to hte server and create the mapping for the server. Then it can be…

If you have lots of plan types that you need to manage. It might be better to break them all out into a separate document and call them dynamically to be pulled in. Blog post I wrote a while ago here: https://blogs.oracle.com/xmlpublisher/conditional-templates If it is only a few types then you might need to investigate…

Hi Do you not have the sub total and toal rows defined in the RTF template already? If so, you can add the borders you need by using a table (even a single celled table) around the values. That said, I would recommend using a table for everything in the RTF template so that it 'translates' to an excel sheet with cells more…

Hi To cover the missing font issue in the PDF first. The reason you are seeing the fonts in Excel and HTML is that the fonts on your desktop are being referenced from those outputs. In PDF, the fonts are embedded inside the file to make it a truly portable document format. You need to make the BIP server aware of the fonts…

You need to get the users information to the query. In the standalone BIP version the user and their role are available to the data model and the layout template. Once you have that information you can do a lookup in the queries to limit the rows returned by the report. Check out row level security with BI Publisher paper…

To see if the encoding algorithm is being called correctly. Remove the barcode font in the template and replace it with something like Arial ie humanly readable. Then run the report. if the encoder is being called correctly then you will see your original data replaced with an encoded string. You did add the register…

Hi Assuming you are using an Oracle Application (EBS/PSoft, JDE, Fusion) why not go a get the report that is doing this right now and get the SQL out of it. I remember many years ago working on the Asset Detail Report ... it was a monster! Good luck Tim

Hi The Code 128 barcode has three variants, a|b|c. You need to specify which encoding you want for the barcode string ie for type 'a' >>> <?format-barcode:SHIPMENT_XID;'code128a'?> If that is still not working then remove the barcode font from the string in the word template and use a readable font to check that the…

You need a template. However, what you can use is an XSL template that does not actually do anything to the XML during the transformation. There are examples out on google. Cheers Tim

Hi You have not said what version you are running? Looks like 12c but what is the minor version? How is not working? Is it being ignored by BIP? You are using the least function in your SQL. Are you expecting multiple values for the prompt value? Why not limit the user to a single value? If its working for Person Number in…

This should help https://blogs.oracle.com/fadevrel/logical-and-relational-data-model-diagrams-for-fusion-applications If you need more info about the specific tables. Id get over to the Fusion Apps forums and ask there, Tim

Errrr ... for which product? For EBS, this is a good start - http://etrm.oracle.com/pls/etrm/etrm_search.search You can google or search the o.com website for the others. Tim

Hi John Welcome to the world of BIP. What you are asking for is a group left total. Check the docs and examples for the RTF template for more help. I dont have time this morning to look at your template but will later today. Regards Tim

Hi When Excel opens it see and recognizes the date data and then applies the default date format to the data. Its out of the RTF templates hands at that point. AS the other reply has stated, the only way around it is to get the date format to a string using to_char so that Excel does not think its a date. You might still…

Hi Darcy Im not entirely clear about the issue. What version/flavor of BI Publisher are you using and in what context? Can you expand on the problem a little more? Tim