Posts Tagged ‘reports’
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 [...]
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 [...]
How to View Oracle Reports in Oracle Apps
Posted by: Edi Yanto on: December 26, 2007
- In: Oracle
- 6 Comments
When viewing report output (View -> Requests menu, Find button, place your cursor on the row of the report that you want to view, View Output button) using the standard Oracle Report Viewer, select Tools -> Copy File menu to open the report in a web browser (such as Netscape Navigator or Internet Explorer). a.) [...]
Customized Titles in Oracle
Posted by: Edi Yanto on: April 18, 2007
We can create a header and a footer to display customized titles at the top and bottom of each page in the report output using the TTITLE and BTITLE commands. Query for display the employees who work in SALES department and hire date year is 1981. After type the command to display the title 1981 [...]
Customized the Column Heading in Oracle
Posted by: Edi Yanto on: April 17, 2007
In Oracle, we can customize the column heading and formatted it’s value. Controls display of a column: COL[UMN] [ { column|alias } [option] ] CLE[AR] : Clears any column formats HEA[DING] text : Sets the column heading FOR[MAT] format : Changes the display of the column using a format model NOPRINT | PRINT NULL [...]
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