6 Replies Latest reply: Oct 9, 2012 5:47 AM by Gumas RSS

    Content/Document Management certificate path not working

    570033
      Hopefully this the correct location to post this, but I am having some issues getting an HTTPS connection to a WebDAV Connection URL under Content/Document Management - Repository Setup. I have added the CA certificate to the "cacerts" file under $JAVA_HOME/jre/lib/security using the keytool. I specify the path to the cacerts file for the Certificate Path field. However, when I try to test the connection, I receive this error:

      Test Connection Failed: oracle.apps.dom.webdav.client.dav.HttpsConnectionFailedException

      Does anyone have any idea of what I might be doing wrong? Any help that anyone can provide would be helpful.

      Thank you.
        • 1. Re: Content/Document Management certificate path not working
          Hussein Sawwan-Oracle
          Hi,

          What is the application release?

          Please run the test as per (Note: 418209.1 - R12.0.[3-4] : Document Management and Collaboration Document Check Setup Test) and see if it returns any errors.

          Regards,
          Hussein
          • 2. Re: Content/Document Management certificate path not working
            570033
            Thank you for your response. The application version is 12.1.2. I did get these errors when I ran the report, but I don't think they are related to my issue as I don't see anything related to SSL or Certificates:

            Name     Type     Sequence     Error
            EUL5_GET_AUTOGEN_ITEM_NAME     FUNCTION     1     PL/SQL: ORA-00942: table or view does not exist
            EUL5_GET_AUTOGEN_ITEM_NAME     FUNCTION     1     PL/SQL: ORA-00942: table or view does not exist
            EUL5_GET_AUTOGEN_ITEM_NAME     FUNCTION     2     PL/SQL: SQL Statement ignored
            EUL5_GET_AUTOGEN_ITEM_NAME     FUNCTION     2     PL/SQL: SQL Statement ignored
            EUL5_GET_AUTOGEN_ITEM_NAME     FUNCTION     3     PL/SQL: ORA-00942: table or view does not exist
            EUL5_GET_AUTOGEN_ITEM_NAME     FUNCTION     3     PL/SQL: ORA-00942: table or view does not exist
            EUL5_GET_AUTOGEN_ITEM_NAME     FUNCTION     4     PL/SQL: SQL Statement ignored
            EUL5_GET_AUTOGEN_ITEM_NAME     FUNCTION     4     PL/SQL: SQL Statement ignored
            EUL5_GET_FOLDERNAME     FUNCTION     1     PL/SQL: ORA-00942: table or view does not exist
            EUL5_GET_FOLDERNAME     FUNCTION     2     PL/SQL: SQL Statement ignored
            EUL5_GET_JOIN     FUNCTION     1     PL/SQL: ORA-00942: table or view does not exist
            EUL5_GET_JOIN     FUNCTION     2     PL/SQL: SQL Statement ignored
            EUL5_GET_JOIN     FUNCTION     3     PLS-00905: object APPS.EUL5_GET_FOLDERNAME is invalid
            EUL5_GET_JOIN     FUNCTION     4     PL/SQL: Statement ignored
            EUL5_GET_JOIN     FUNCTION     5     PLS-00905: object APPS.EUL5_GET_FOLDERNAME is invalid
            EUL5_GET_JOIN     FUNCTION     6     PL/SQL: Statement ignored
            EUL5_GET_JOIN     FUNCTION     7     PLS-00905: object APPS.EUL5_GET_AUTOGEN_ITEM_NAME is invalid
            EUL5_GET_JOIN     FUNCTION     8     PL/SQL: Statement ignored
            EUL5_GET_JOIN     FUNCTION     9     PLS-00905: object APPS.EUL5_GET_AUTOGEN_ITEM_NAME is invalid
            EUL5_GET_JOIN     FUNCTION     10     PL/SQL: Statement ignored
            EUL5_GET_JOIN     FUNCTION     11     PLS-00905: object APPS.EUL5_GET_AUTOGEN_ITEM_NAME is invalid
            EUL5_GET_JOIN     FUNCTION     12     PL/SQL: Statement ignored
            EUL5_GET_JOIN     FUNCTION     13     PLS-00905: object APPS.EUL5_GET_AUTOGEN_ITEM_NAME is invalid
            EUL5_GET_JOIN     FUNCTION     14     PL/SQL: Statement ignored
            EUL5_GET_JOIN     FUNCTION     15     PLS-00905: object APPS.EUL5_GET_AUTOGEN_ITEM_NAME is invalid
            EUL5_GET_JOIN     FUNCTION     16     PL/SQL: Statement ignored
            EUL5_GET_JOIN     FUNCTION     17     PLS-00905: object APPS.EUL5_GET_AUTOGEN_ITEM_NAME is invalid
            EUL5_GET_JOIN     FUNCTION     18     PL/SQL: Statement ignored
            EUL5_GET_JOIN     FUNCTION     19     PLS-00905: object APPS.EUL5_GET_AUTOGEN_ITEM_NAME is invalid
            EUL5_GET_JOIN     FUNCTION     20     PL/SQL: Statement ignored

            Any other suggestions?

            Thank you.
            • 3. Re: Content/Document Management certificate path not working
              570033
              I am not sure if it's helpful or not, but I also noticed that if I have the Certificate Path option blank it gives me the same error.
              • 4. Re: Content/Document Management certificate path not working
                Hussein Sawwan-Oracle
                Hi,

                I would suggest you log a SR.

                Regards,
                Hussein
                • 5. Re: Content/Document Management certificate path not working
                  Gumas
                  Hi dhartle,

                  Have you solve this problem? I also got the same error and still haven't solve it. when try to ignore it and then try to attach file to the repositories specified in this connection. The error message is 'Logon Failed: The User ID and Password combination entered is not valid.'. The same error message keep appear eventhough i enter the valid user ID and Password.

                  Thanks
                  • 6. Re: Content/Document Management certificate path not working
                    Gumas
                    I think this problem could be solve by installing 9071475:R12.DOM.B patch