1. What is the notorious "yellow bar" in Oracle apps? How does it affect the applications? What steps should one take to remove it?
  2. How do you find out the application patch level?

    Requires Free Membership to View

  1. Oracle Applications Rel 11.5.X (11i) requires that its code run in a trusted mode and uses JInitiator to run Java applets on a desktop client. If an applet is "trusted," however, Java will extend the privileges of 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, so Oracle Applications requires that all Java archive files must be digitally signed. This is a REQUIRED post-installation step that is often overlooked. This affects all users that try to access Oracle Applications Rel 11i using JInitiator that have a different identitydb.obj on their client, or where an instance never created the digital certificate, and signed their JAR files.

    In most cases, this has a minimal effect on the application.

    Usually, uninstalling and reinstalling your JInitiator will resolve the issue. If it does not, then you will need to check with your DBA to make sure all instillation steps were completed in the creation of your instance.

  2. The following SQL script will return your patch level. You can also use Application Manager to see each patch that has been applied.

    SELECT  SUBSTR(a.application_name,1,25)        application,
                    NVL (p.patch_level, 'Unknown' )        patchLevel
                    FROM    FND_APPLICATION_ALL_VIEW a,
                            FND_PRODUCT_INSTALLATIONS p
                    WHERE   a.application_id = p.application_id
    

This was first published in September 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.