Did You Know? -- August 2002

By Hervé Deschamps, Oracle Corporation.

 

Apps: Yellow Bar

What is that yellow bar that I get on my browser when loading the applet?

The Yellow Warning Bar is a warning that your applet is not running in a trusted mode.

To indicate that an applet is trusted, it must be digitally signed using a digital Certificate. Creating a Digital Certificate and signing the JAR files is a required step in the Post Installation process, but is often overlooked.

Here is what you need to do on your client if the server stuff is take care of. If not, check Metalink for details.

Copy $APPL_TOP/admin/appltop.cer on your PC. Choose the appropriate Jinitiator home if you have several, for example:
c:\Program Files\oracle\JInitiator 1.1.8.16\bin
Then, open a DOS window in that same directory (\bin) and run these commands:
   javakey c <a_name> true
   javakey ic <a_name> appltop.cer
   javakey -l (to check).
You may have to clear your browser Cache and your jcache directory, but try without doing this first.
Then close your browser session and start a new one: logon, etc.
 
 

Apps:

Where are the concurrent manager logs? When the system refuses to let you see the log for a job you can always find it on the server file system in <HOME>comn\admin\log. Look for file l<ConMgrJobNumber>.req.
 
 

Reports miscellaneous:

This is a way to change the content of a field on the run, like if for example you want to filter out certain characters.
In the field's format trigger,
   srw.set_field(0,my_funtion(:line_description));

In positioning an anchor of an objet's edge, you can shift-click to move along the edge in 25% increments.

Handy keyboard shortcuts: F2: Layout/Data Model/PForm editor. F3: navigator. F4: Properties.

Do you know all the symbols used in the layout editor? This image is from the online help of 6i.

If a format trigger suppresses report output on the last page of the report, the last page will still be formatted and sent to the appropriate output and the page will be included in the total number of pages.
 
 

Reports - Worth noting about Print Object On & Base Printing On

A Print Object On of First Page and a Print Object On of All But First Page are not necessarily mutually exclusive. For example, if one object has a Print Object On of First Page and another has All But First Page and they both have the same Base Printing On setting, you might think that the two objects could never appear on the same page.  However, if the object with First Page overflows onto the second page, the two objects could appear on the same page.

Objects in the margin region are restarted on every physical page. As a result not all Print Object On settings make sense for margin objects. Because objects are restarted on every page, it is as if you are always on the first page of the object. First Page is the same as All Pages. Last Page and All But Last Page are invalid because "last" is never reached. All But First Page causes the object to never appear  because the object never goes beyond "first."

An object that is implicitly or explicitly anchored to its enclosing frame or repeating frame cannot have a Print Object On of Last Page or All But Last Page.  An object that is anchored to another object within  its frame or repeating frame cannot have a Print Object On of Last Page or All But Last Page with a Base  Printing On of Enclosing Object.
 
 

NT Networking:

From DOS, you can type 'hostname' to get your machine's host name. It is the first part of what you can see if you type 'ping localhost'. After the . is the domain.
 
 

NT Security:

If you want to run Admin Tools->User Manager but cannot see the icon, you can call it from Start->Run...: usrmgr
 
 

Printers HP

Some printers HP (for example the HP9000) have a web server integrated, so that if you know their IP address, you can type it in your browser and you will get HTML pages that let you configure the printer, view its logs, check or change the network parameters, setup security, check its current status, etc.
 


Hervé Deschamps is a Technical Manager with Oracle Corporation. Over the years he has developed a number of applications using Oracle Development Tools and others.  He has an extensive experience of all phases of the development life cycle. He is also known in the technical community for his article publications centered around best custom development practices and for his user group presentations. You can reach him by e-mail at herve.deschamps@.oracle.com. He also maintains a web site full of articles, scripts, tips and techniques at http://www.iherve.com.