Report output through Oracle Apps

Posted on 2004-10-25
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
    LVL 5

    Expert Comment


      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

    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.
    LVL 5

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Supply Chain Event Management Supply chain visibility is the ability of a company to track its products and business processes in supply chain towards building operational excellence. The goal of supply chain visibility is to improve and strength…
    Oracle Apps Profiles option: A user profile is a set of shifting options that alter the way one runs an application. A value is set for each option under the user's profile when the Oracle application user logs on to any responsibility or changes…
    This video Micro Tutorial is the second in a two-part series that shows how to create and use custom scanning profiles in Nuance's PaperPort 14.5 ( But the ability to create custom scanning profiles a…
    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…

    846 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

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now