sales@capstoneonline.com   Toll Free: 877-255-2561  Local: 410-549-9165
Capstone Consulting, Inc.
  • Home
  • Services
  • Contact Us
  • About Us
    • Testimonials
    • Survey Results

Reports unable to connect to 11g database

7/23/2013

2 Comments

 
REMEMBER:  by default the 11g database has case sensitive passwords.  If you are having issues with your Reports Server connecting to the 11g database have your DBA change the password case sensitive parameter (SEC_CASE_SENSITIVE_LOGON) to "FALSE". 
2 Comments

ADD LOGO ICON to web URL in Oracle Forms

10/23/2012

1 Comment

 
Edit the webutiljpi.html file (or basejpi.html file if you are not using webutil).  Modify the <HEAD> tag to include:   <link rel="SHORTCuT ICON" href="../forms/files/myFILE.ico"> 

** myFile.ico is the name of your icon file.  Place the myFile.ico file in the directory on the server where your /forms/files virtual path is pointing to.

In my case, I have a virtual path /forms/files pointing to c:\temp.  Therefore, myFile.ico is in the c:\temp directory.   The virtual paths are set in the forms.conf file.
1 Comment

REP:66023 error when running report with image

2/23/2012

1 Comment

 
Recevied REP:66023 error on application server on 64bit windows server when running a report with an image. To resolve this issue go to the Server (Application Server) and create a new registry string entry in the Oracle Application Server Wow6432Node, Oracle, Key_oracleas1, REPORTS_DEFAULT_DISPLAY  and set it to no
1 Comment

Oracle 10g Reports containing images generate huge PDF files

7/23/2011

12 Comments

 
Add the following registry string value entry to your Oracle forms key:   REPORTS_JPEG_QUALITY_FACTOR  provide a setting between 0 and 100.  I chose 50.  The default is 100.  Oracle suggests 75.

My report contained 12 images.  Adding this entry with a value of 25 took my 24mb file down to 1mb and the images were still very good.  It will depend on your image resolution and original compression, as to how far you can decrease the quality factor.

12 Comments

    Author

    Over the years we have addressed many issues and resolved many problems for our clients.  In our TECH CORNER, I will share our experiences along the way and lessons learned as a result. Enjoy!
    Kim Nupp

    Archives

    July 2013
    October 2012
    February 2012
    July 2011

    Categories

    All
    Oracle Forms
    Oracle Reports

    RSS Feed

Proudly powered by Weebly