Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Report output through Oracle Apps

Posted on 2004-10-25
Medium Priority
Last Modified: 2013-12-03

I have a report using Euro(€) as a currency symbol. I am using chr(128) to get € symbol.
The report being executed through concurrent program. I set destination format as PDFin conc program.
When I run the report through Conc Program, the ghost view is showing the symol € and if I give print from ghost view the symbol € is printing But If i opt printer in applications
then report is not printing. It appears to me something like the Pl/sql code is printing.

If I set  post script format in conc Program the symbol € is not printing in both ghost view
as well as report output.
I am using reports 6i in  oracle apps 11i.

can any one analyse the problem please.
Question by:Venkat_y
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 12407152

  From Reports 6i Release Notes on Euro support:

 13.1.3 Euro Currency Symbol Has Limited Support

There is limited support in this release for the Euro currency


To enable a limited use of the Euro symbol in this release, you

must do the following:

1. If you are using Windows 95 or NT, update that operating

system with the appropriate Euro-related patch from


(Windows 98 already contains the Euro support.)

2. Install Microsoft TrueType fonts that contain the Euro


3. Verify that your database and client NLS_LANG character sets

both support the Euro symbol. If you will print the Euro

symbol, Euro support on the printer is also required.

Microsoft has reserved hexcode 0x80 for the Euro symbol. To

enter the Euro symbol on keyboards without an explicit Euro key,

click the NumLock key to enable the Numeric Keypad, then click

Alt + 0128.

Author Comment

ID: 12407407
Please once again go through the described problem .

1. I already said i am using chr(128) fro that symbol.
And I also mentioned the report is being printed through ghost view in athe applications.
Hence  Reports 6i  Euro support, Windows, Printer support ....can be ruled out.
My problem is If i directly print through concurrent program in the application the report is
output is not printed .

I am thinking the problem lies rughly with areas like  PDF format, concurrent programme and Unix. I don't know exactly where the problem lies. I appreciate if any one give the right direction.

Accepted Solution

alexfrl earned 800 total points
ID: 12535166
You are right - your Adobe installation in Unix is wrong or missing.
By the way, it is not a PlSql, it is an Adobe code (Adobe files are built using Adobe internal code language)
As the result of wrong installation in Unix there is no correct driver which able to manage printing in Adobe format (PDF/PostScript)
and, therefore, the not interpretted file content is being printed.
Ask your DBA for help.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have problems displaying reports in CRM after a new installation, review the following steps: Check that SQL Server Reporting Services is working On the server that has SQL Server Reporting Services (SQL SRS) installed, check that the S…
Note: You must have administrative privileges in order to create/edit Sharing Rules. Salesforce.com (http://www.salesforce.com) (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales an…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses

596 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question