Posts Tagged ‘XML/BI Publisher’
Excel Limitations on Images in Oracle Apps
Posted by: Edi Yanto on: May 23, 2009
The Excel output can’t showing the image (even after you save and send to another person or open it at different notebook), but it is showing only small red color empty cross written ‘An Image’. Why??? As many of you know or have noticed, our Excel output for all flavors of BIP/XMLP is not true [...]
BLOB Images in XML Publisher
Posted by: Edi Yanto on: May 21, 2009
- In: Oracle
- 107 Comments
BLOB is “a collection of binary data stored as a single entity in a database management system. Blobs are typically images, audio or other multimedia objects, though sometimes binary code is stored as a blob. Database support for blobs is not universal.” (wikipedia) Support for extracting BLOB images to XML is coming, the XMLP extraction [...]
The XML Publisher Concurrent Request Fails Due to the Output Post Processing (OPP)
Posted by: Edi Yanto on: February 7, 2009
- In: Oracle
- 12 Comments
Three possible errors can occur as below: The Output Post Processor is not running or does not pick up the request … +————- 1) PUBLISH ————-+ Unable to find an Output Post Processor service to post-process request [request_id]. Check that the Output Post Processor service is running. +————————————–+ … Solutions: * Verify that the Output [...]
Securing PDF Output on XML Publisher
Posted by: Edi Yanto on: January 24, 2009
Worked Example I – Securing a PDF output You can now embed any of the XML Publisher properties into your RTF template <<reference to property lists>> These would then be resolved at runtime by the XML Publisher engine; you can either use hard coded values or embed the values inside the incoming XML data. If [...]
Request ID Parameter LoV Not Populated for XML Report Publisher Program
Posted by: Edi Yanto on: January 12, 2009
When you submit the XML Report Publisher Program (XDOREPPB) you are prompted to select the Request ID for the data generation program. The LoV for this parameter is not being populated due to an incorrect profile option reference. To work around this issue, you must change the references to the incorrect profile option in the [...]
How to Get XML File From XML/BI Publisher Report in Oracle Apps
Posted by: Edi Yanto on: January 12, 2009
You can get the XML file from the XML/BI Publisher report based on concurrent request with the below steps: *) View->Requests *) Find the request you’re interested in *) Click on Diagnostics button *) Click the View XML *) Save the file to your PC by doing File->Save As, *.xml Or you can get it [...]
Moving Concurrent Programs, Data Definitions and Templates Between eBusiness Suite Instances
Posted by: Edi Yanto on: January 2, 2009
BI Publisher provides the FNDLOAD and XDOLoader utilities to move component across eBusiness Suite instances. The FNDLOAD utility is used to upload and download the concurrent program, data definition and data template created via created via System Administrator and XML Publisher Administrator responsibility. The XDOLoader utility is used to upload and download the physical files [...]
Oracle XML Publisher / BI Publisher
Posted by: Edi Yanto on: December 29, 2008
You also can view and download My SlideShare Oracle XML Publisher / BI Publisher presentation here.
Unable to View EXCEL Output (XML Publisher) from Concurrent Program Request
Posted by: Edi Yanto on: December 17, 2008
- In: Oracle
- 6 Comments
While running XML Publisher report for EXCEL output, the Concurrent Program has the error message : “ORA-1403: no data found” The cause of this problem has been identified in Bug 4396843 by Metalink. The output of the report can be viewed from menu Request > Monitor through System Administration Responsibility or you can solve this [...]
Invoice Listing with Repeatable Row Header and Splitting Rows Across Pages on Oracle XML Publisher
Posted by: Edi Yanto on: May 21, 2008
- In: Oracle
- 2 Comments
Repeatable Row Headers If your transactions/invoices break across a page and you want to repeat the column header row this can be achieved using MSWord’s functionality. Highlight the header row Table > Table Properties Under the Row tab select the ‘Repeat as Header row at the top of each page’ If the transactions/invoices table breaks [...]
RSS Syndication
Edi Yanto
Oracle Applications Technical Consultant
My Certifications
- The XML Publisher Concurrent Request Fails Due to the Output Post Processing (OPP)
- BLOB Images in XML Publisher
- Tuning Dynamic SQL with EXECUTE IMMEDIATE and Cursor Variables
- Moving Concurrent Programs, Data Definitions and Templates Between eBusiness Suite Instances
- Receiving and Return Transaction with Receiving Open Interface (ROI)
- Transact Move Order and Ship Confirm Using API
- Spell Number (Function Terbilang)
- Making Custom Reports Oracle Apps Compliant
- ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
- ORA-01591: lock held by in-doubt distributed transaction
- Edi Yanto: Hi Mandi, Have you tried the steps on my blog? Please send me your RTF, XML and RDF files to my gmail (edi.y4nto@gmail.com), I'll take a look when I'
- Mandi: Hi Edi, I am trying to incorporate signature and logo for check printing template in R12. I have converted the blob to clob using getbase64 function
- Edi Yanto: Hi Siva, Images on excel output are not scale itself, so you must change the image size according to what you want. More info about excel limitation
Unknown Feed
- An error has occurred; the feed is probably down. Try again later.
Online Apps DBA
- Weekend Online Oracle R12 Apps DBA Training commencing from 03rd June 2012
- Weekend Online Oracle Weblogic Administrator 11g Training commencing from 02 June 2012
- Confused about Oracle IAM software version & release number ?
- ASM block corruption ORA-01115
- Oracle Adaptive Access Manager (OAAM) for beginners
Visitors
Users Online
Recent Comments