Stack Overflow
Stack Overflow

Questions tagged [bi-publisher]

Business Intelligence Publisher - Oracle's reporting application.

First released in 2003 as part of Oracle's E-Business Suite it has now been integrated into many of the Oracle products and is also available as a standalone application. It is capable of generating XML data from SQL queries, XML files, web services, LDAP, MDX queries, Excel files and Oracle ADF View objects.

532 questions
0
votes
1 answer

Date in Email Scheduling in Bi publisher

I want to Scheduled a File in BI publisher using Email option.. I want the attachment and Mail Subject and Mail Body to have sysdate .. I tried with %d, %m,%y it works for FTP destination but for Email it is not working . please help me i want the…
Eswar Vignesh
  • 77
  • 2
  • 17
0
votes
1 answer

bi publisher job scheduler

I have a request to schedule some reports one after another in oracle BI Publisher. The reports scheduler would start run at 7:00 PM and finish with all the reports nearly at 7:00 AM of the next day. What I thought was to create a trigger that…
amarilda
  • 1
  • 1
0
votes
1 answer

export Report in Excel using Bi publisher

I have two Layout in my Report(Report 1) Under Report1 i have layout 1 and Layout 2 if i use Export to Excel option in Bi publisher then i am getting only layout 1 or layout 2 in excel. I want the Report1 to be export in Excel file named as…
Eswar Vignesh
  • 77
  • 2
  • 17
0
votes
1 answer

TemplateBuilder.dot Missing

I have installed BI Publisher Desktop 11g for Windows. After installation I am not able to see Bi Publisher tab in MS word. I have tried adding TemplateBuilder.dot file, however, I am not able to find this dot file on my PC which is Windows 8.1 What…
Jacob
  • 14,463
  • 65
  • 207
  • 320
0
votes
1 answer

How do you use loops in ZPL to print labels on Zebra Printer in Oracle Apps R12.1.3

How can I use a ZPL loop in Oracle BI publisher to print the following labels: order number:1234 line: 1 item: ABC1 Qty: 10 order number:1234 line: 2 item: ABC1 Qty: 10 order number:1234 line: 3 item: ABC1 Qty: 10 Per above…
Rajesh123
  • 107
  • 1
  • 5
  • 17
0
votes
0 answers

BI Publisher BASE64 output generation error

I have created a BI Publisher report which file type is XML. Than I want to create base64 output via SOAP UI. And service that I have been calling "PublicReportService?wsdl". Firstly I run "getreportDefination" method and it ended without any error…
1010111100011
  • 83
  • 1
  • 3
  • 9
0
votes
1 answer

Issue with tags in RTF Template while validating in BI Publisher

I have the following rtf template which i am trying to use. No Letter has been generated for this employee as they were not eligible for a pay or bonus…
sreekem bose
  • 451
  • 3
  • 12
  • 28
0
votes
1 answer

BI Publisher - RTF Matrix Template

I have a data model like this: 01JAN <TITLE_NAME>Title 1</TITLE_NAME> …</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/rtf" class="post-tag grid--cell" title="show questions tagged 'rtf'" rel="tag">rtf</a> <a href="../../questions/tagged/bi-publisher" class="post-tag grid--cell" title="show questions tagged 'bi-publisher'" rel="tag">bi-publisher</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Aug 04 '16 at 06:30">asked Aug 04 '16 at 06:30</time> <a href="../../users/4552691/hoang-nguyen" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/4552691.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="Hoang Nguyen" /> </a> <div class="s-user-card--info"> <a href="../../users/4552691/hoang-nguyen" class="s-user-card--link">Hoang Nguyen</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">61</li> <li class="s-award-bling s-award-bling__silver" title="1 silver badges">1</li> <li class="s-award-bling s-award-bling__bronze" title="13 bronze badges">13</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-38683001"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>0</strong></span> <div class="viewcount">votes</div> </div> </div> <div class="status "> <strong>1</strong> answer </div> </div> </div> <div class="summary"> <h3><a href="../../questions/38683001/does-oracle-bi-publisher-support-xmp-metadata-in-pdf" class="question-hyperlink">Does Oracle BI Publisher support XMP metadata in PDF</a></h3> <div class="excerpt">I would like to know if Oracle BI Publisher supports XMP metadata in the PDF files. </div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/pdf" class="post-tag grid--cell" title="show questions tagged 'pdf'" rel="tag">pdf</a> <a href="../../questions/tagged/siebel" class="post-tag grid--cell" title="show questions tagged 'siebel'" rel="tag">siebel</a> <a href="../../questions/tagged/xmp" class="post-tag grid--cell" title="show questions tagged 'xmp'" rel="tag">xmp</a> <a href="../../questions/tagged/bi-publisher" class="post-tag grid--cell" title="show questions tagged 'bi-publisher'" rel="tag">bi-publisher</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Jul 31 '16 at 10:25">asked Jul 31 '16 at 10:25</time> <a href="../../users/2151881/stefan-ciprian-hotoleanu" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/2151881.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="Stefan Ciprian Hotoleanu" /> </a> <div class="s-user-card--info"> <a href="../../users/2151881/stefan-ciprian-hotoleanu" class="s-user-card--link">Stefan Ciprian Hotoleanu</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">2,202</li> <li class="s-award-bling s-award-bling__gold" title="1 gold badge">1</li> <li class="s-award-bling s-award-bling__silver" title="23 silver badge">23</li> <li class="s-award-bling s-award-bling__bronze" title="30 bronze badge">30</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-38633191"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>0</strong></span> <div class="viewcount">votes</div> </div> </div> <div class="status "> <strong>1</strong> answer </div> </div> </div> <div class="summary"> <h3><a href="../../questions/38633191/bi-publisher-display-data-horizontally" class="question-hyperlink">BI Publisher - Display Data Horizontally</a></h3> <div class="excerpt">I have the following data model: <SALE_LIST> <SALE> <YEAR>2010</YEAR> <ITEM>100001</ITEM> <AMOUNT>1,199.00</AMOUNT> </SALE> <SALE> <YEAR>2010</YEAR> <ITEM>100002</ITEM> …</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/rtf" class="post-tag grid--cell" title="show questions tagged 'rtf'" rel="tag">rtf</a> <a href="../../questions/tagged/bi-publisher" class="post-tag grid--cell" title="show questions tagged 'bi-publisher'" rel="tag">bi-publisher</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Jul 28 '16 at 10:03">asked Jul 28 '16 at 10:03</time> <a href="../../users/4552691/hoang-nguyen" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/4552691.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="Hoang Nguyen" /> </a> <div class="s-user-card--info"> <a href="../../users/4552691/hoang-nguyen" class="s-user-card--link">Hoang Nguyen</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">61</li> <li class="s-award-bling s-award-bling__silver" title="1 silver badges">1</li> <li class="s-award-bling s-award-bling__bronze" title="13 bronze badges">13</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-38548582"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>0</strong></span> <div class="viewcount">votes</div> </div> </div> <div class="status "> <strong>1</strong> answer </div> </div> </div> <div class="summary"> <h3><a href="../../questions/38548582/the-query-could-not-be-run-because-the-criteria-for-field-contained-an-invalid" class="question-hyperlink">The query could not be run because the criteria for field '<?>' contained an invalid arithmetic expression</a></h3> <div class="excerpt">The query could not be run because the criteria for field '' contained an invalid arithmetic expression Hi, I faced some issue when i try to pass a value in Server Script and it keep come out with this error " doesnt support operator …</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/siebel" class="post-tag grid--cell" title="show questions tagged 'siebel'" rel="tag">siebel</a> <a href="../../questions/tagged/bi-publisher" class="post-tag grid--cell" title="show questions tagged 'bi-publisher'" rel="tag">bi-publisher</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Jul 24 '16 at 03:52">asked Jul 24 '16 at 03:52</time> <a href="../../users/5602202/yan" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/5602202.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="Yan" /> </a> <div class="s-user-card--info"> <a href="../../users/5602202/yan" class="s-user-card--link">Yan</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">35</li> <li class="s-award-bling s-award-bling__gold" title="1 gold badge">1</li> <li class="s-award-bling s-award-bling__silver" title="4 silver badge">4</li> <li class="s-award-bling s-award-bling__bronze" title="10 bronze badge">10</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-38349583"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>0</strong></span> <div class="viewcount">votes</div> </div> </div> <div class="status "> <strong>1</strong> answer </div> </div> </div> <div class="summary"> <h3><a href="../../questions/38349583/autofit-to-content-in-bi-publisher" class="question-hyperlink">AutoFit to content in Bi publisher</a></h3> <div class="excerpt">is it possible to Auto Fit to the Content in Bi publisher I have like max 30 Column and max of 30 Character length I want the Cells to be Auto_Fit Can this be done using on-line Layout Report Design or using RTF(Word Template) Note:Excel template…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/bi-publisher" class="post-tag grid--cell" title="show questions tagged 'bi-publisher'" rel="tag">bi-publisher</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Jul 13 '16 at 10:50">asked Jul 13 '16 at 10:50</time> <a href="../../users/6059833/eswar-vignesh" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/6059833.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="Eswar Vignesh" /> </a> <div class="s-user-card--info"> <a href="../../users/6059833/eswar-vignesh" class="s-user-card--link">Eswar Vignesh</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">77</li> <li class="s-award-bling s-award-bling__silver" title="2 silver badges">2</li> <li class="s-award-bling s-award-bling__bronze" title="17 bronze badges">17</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-38299286"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>0</strong></span> <div class="viewcount">votes</div> </div> </div> <div class="status "> <strong>1</strong> answer </div> </div> </div> <div class="summary"> <h3><a href="../../questions/38299286/mandatory-and-non-mandatory-field-in-sql" class="question-hyperlink">Mandatory and NON-Mandatory Field in SQL</a></h3> <div class="excerpt">I have two parameter for a SQL query as shown below Select * from table1 where :B in B and (:C in C or :C is null) Requirement: :B is a mandatory Field.if this value is null no record will be displayed but :C is non mandatory Field.if this value…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/sql" class="post-tag grid--cell" title="show questions tagged 'sql'" rel="tag">sql</a> <a href="../../questions/tagged/oracle11g" class="post-tag grid--cell" title="show questions tagged 'oracle11g'" rel="tag">oracle11g</a> <a href="../../questions/tagged/bi-publisher" class="post-tag grid--cell" title="show questions tagged 'bi-publisher'" rel="tag">bi-publisher</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Jul 11 '16 at 04:41">asked Jul 11 '16 at 04:41</time> <a href="../../users/6059833/eswar-vignesh" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/6059833.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="Eswar Vignesh" /> </a> <div class="s-user-card--info"> <a href="../../users/6059833/eswar-vignesh" class="s-user-card--link">Eswar Vignesh</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">77</li> <li class="s-award-bling s-award-bling__silver" title="2 silver badges">2</li> <li class="s-award-bling s-award-bling__bronze" title="17 bronze badges">17</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-38261719"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>0</strong></span> <div class="viewcount">votes</div> </div> </div> <div class="status "> <strong>2</strong> answers </div> </div> </div> <div class="summary"> <h3><a href="../../questions/38261719/how-to-update-counter-in-bi-publisher-for-each-tag" class="question-hyperlink">How to update counter in BI Publisher for-each tag</a></h3> <div class="excerpt">I have a counter variable: <?xdoxslt:set_variable($_XDOCTX, ‘storeCounter’, 0)?> I put this counter into a for-each tag and hope that it will return the loop times: <?for-each:G_1?> <?xdoxslt:set_variable($_XDOCTX, 'storeCounter',…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/bi-publisher" class="post-tag grid--cell" title="show questions tagged 'bi-publisher'" rel="tag">bi-publisher</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Jul 08 '16 at 08:01">asked Jul 08 '16 at 08:01</time> <a href="../../users/4552691/hoang-nguyen" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/4552691.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="Hoang Nguyen" /> </a> <div class="s-user-card--info"> <a href="../../users/4552691/hoang-nguyen" class="s-user-card--link">Hoang Nguyen</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">61</li> <li class="s-award-bling s-award-bling__silver" title="1 silver badges">1</li> <li class="s-award-bling s-award-bling__bronze" title="13 bronze badges">13</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-38074157"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>0</strong></span> <div class="viewcount">votes</div> </div> </div> <div class="status answered-accepted"> <strong>2</strong> answers </div> </div> </div> <div class="summary"> <h3><a href="../../questions/38074157/repeating-header-in-bi-publisher-template" class="question-hyperlink">repeating header in BI publisher template</a></h3> <div class="excerpt">I am trying to design a template in BI publisher for the xml file generated by oracle BI PUBLISHER. I want my header part to repeat on all the pages like if the data is printed across pages the header portion related to the data should be printed on…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/rtf" class="post-tag grid--cell" title="show questions tagged 'rtf'" rel="tag">rtf</a> <a href="../../questions/tagged/bi-publisher" class="post-tag grid--cell" title="show questions tagged 'bi-publisher'" rel="tag">bi-publisher</a> <a href="../../questions/tagged/xml-publisher" class="post-tag grid--cell" title="show questions tagged 'xml-publisher'" rel="tag">xml-publisher</a> <a href="../../questions/tagged/oracle-xml-publisher" class="post-tag grid--cell" title="show questions tagged 'oracle-xml-publisher'" rel="tag">oracle-xml-publisher</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Jun 28 '16 at 10:49">asked Jun 28 '16 at 10:49</time> <a href="../../users/6498774/siddharth-srivastava" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/6498774.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="Siddharth Srivastava" /> </a> <div class="s-user-card--info"> <a href="../../users/6498774/siddharth-srivastava" class="s-user-card--link">Siddharth Srivastava</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">3</li> <li class="s-award-bling s-award-bling__gold" title="1 gold badge">1</li> <li class="s-award-bling s-award-bling__silver" title="1 silver badge">1</li> <li class="s-award-bling s-award-bling__bronze" title="3 bronze badge">3</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="s-pagination pager fr"> <a class="s-pagination--item" href="../../questions/tagged/bi-publisher_page=28" rel="prev" title="Go to page 28">Prev </a> <a class="s-pagination--item" href="../../questions/tagged/bi-publisher_page=1" rel="" title="Go to page 1">1</a> <a class="s-pagination--item" href="../../questions/tagged/bi-publisher_page=2" rel="" title="Go to page 2">2</a> <a class="s-pagination--item" href="../../questions/tagged/bi-publisher_page=3" rel="" title="Go to page 3">3</a> <div class="s-pagination--item s-pagination--item__clear">…</div> <a class="s-pagination--item" href="../../questions/tagged/bi-publisher_page=35" rel="" title="Go to page 35">35</a> <a class="s-pagination--item" href="../../questions/tagged/bi-publisher_page=36" rel="" title="Go to page 36">36</a> <a class="s-pagination--item" href="../../questions/tagged/bi-publisher_page=30" rel="next" title="Go to page 30"> Next</a> </div> </div> </div> </div> </div> <script src="../../static/js/stack-icons.js"></script> <script src="../../static/js/fromnow.js"></script> </body> </html>