1 2 3 Previous Next 41 Replies Latest reply: Feb 18, 2013 5:31 PM by Kyle.Thomas Go to original post RSS
      • 30. Re: EBS SDK for ADF Integration (Session Management)
        Kyle.Thomas
        Sara,

        I have been able to further debug the issue. Using AppsDataSource instead of AppsXADataSource...

        I am getting the below error:

        Exception breakpoint occurred at line 156 of AppsDataSource.java.
        java.lang.RuntimeException: ORA-20001:
        ORA-06512: at "APPS.APP_EXCEPTION", line 72
        ORA-06512: at "APPS.FND_SECURITY_PKG", line 533
        ORA-06512: at line 1

        Exception in thread "main" java.lang.RuntimeException: ORA-20001:
        ORA-06512: at "APPS.APP_EXCEPTION", line 72
        ORA-06512: at "APPS.FND_SECURITY_PKG", line 533
        ORA-06512: at line 1

        *     at oracle.apps.fnd.security.AppsDataSource.setDbcFile(AppsDataSource.java:156)*
        *     at dstest.Test.init(Test.java:40)*
        *     at dstest.Test.main(Test.java:22)*
        ERROR: JDWP Unable to get JNI 1.2 environment, jvm->GetEnv() return code = -2
        *JDWP exit error AGENT_ERROR_NO_JNI_ENV(183):  [../../../src/share/back/util.c:820]*

        I notice when I add breakpoints in the code it is hitting the exception when it's trying to invoke:

        BEGIN fnd_security_pkg.fnd_encrypted_pwd_x(:1,:2,:3,:4,:5,:6,:7,:8); END;

        This is where it throws the: SQLException

        And it dumps the above message.
        • 31. Re: EBS SDK for ADF Integration (Session Management)
          Kyle.Thomas
          I have confirmed that all the machines are under the same DOMAIN NAME. So that shouldn't be my case.
          • 32. Re: EBS SDK for ADF Integration (Session Management)
            Sara Woodhull-Oracle
            Kyle,

            At this point, please put all this info in your existing SR and ask Support to log a bug for it. I don't think we can get any further on your particular issue in the forum, and development will need to look at it through the regular process.

            Thanks,

            Sara
            • 33. Re: EBS SDK for ADF Integration (Session Management)
              Kyle.Thomas
              bummer =[                                                                                                                                                                                                                                                       
              • 34. Re: EBS SDK for ADF Integration (Session Management)
                987410
                Kyle,

                Looks like, we fixed the issue. We are testing the fix. Please refer metalink ID 1514651.1. The FND profile option had the node name in lower case and it was changed to Upper case and the data source was created successfully.
                Please check the option at your end. Hope this helps.

                Symptoms
                1. Creating a datasource using the Weblogic Server Console.
                2. When doing a connection test after providing all datasource parameters, the following error occurs:
                Connection test failed.
                Message icon - Error ORA-01017: invalid username/password; logon denied

                oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
                oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:397)
                oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
                oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:689)
                oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:452)
                oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
                oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
                oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:384)
                oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:811)
                oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:411)
                oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:678)
                oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:238)
                oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
                oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567)
                oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:404)
                oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:288)
                oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:208)
                weblogic.jdbc.common.internal.DataSourceUtil.testConnection(DataSourceUtil.java:331)
                com.bea.console.utils.jdbc.JDBCUtils.testConnection(JDBCUtils.java:734)
                com.bea.console.actions.jdbc.datasources.createjdbcdatasource.CreateJDBCDataSource.testConnectionConfiguration(CreateJDBCDataSource.java:474)
                ...

                Cause
                The profile option "FND: Desktop Nodes allowed" value is in lowercase.
                Solution
                The value of Profile Option "FND: Desktop Nodes allowed" needs to be in upper case as follows:
                "FND: DESKTOP NODES ALLOWED"


                Thanks
                Viswa
                • 35. Re: EBS SDK for ADF Integration (Session Management)
                  Kyle.Thomas
                  Thanks Viswa, I will have our DBA change that and i'll let you know if it resolved our issue and mark it correct if it is.

                  Thanks for following up on this thread!
                  • 36. Re: EBS SDK for ADF Integration (Session Management)
                    Kyle.Thomas
                    So ...

                    We did not make the "Profile" change as stated in the previous thread response.

                    What we found to be our issue was this:

                    - Our DBC was generated using this format: XXX_OURNODE-123-SRV.OURDOMAIN.COM.dbc

                    It didn't like the fact that we had - and . in our DBC file and in the FND_NODES table.

                    We formatted it in this format XXX_OURNODE.dbc

                    We got past the DataSource issue but now when we run our Session Management code in the CustomPhaseListener we're getting the same issue others have with:

                    When validating the icx cookie it returns a cookie status of GUEST_VALID

                    Anyone have a suggestion on this?
                    • 37. Re: EBS SDK for ADF Integration (Session Management)
                      Kyle.Thomas
                      Regardless whether we put the code to obtain the ICX Session Management in the ADF CustomPhaseListener or we use the standard J2EE servlet we have issues with the SESSION using the "GUEST" account instead of the user logging in. Even though the user has the ROLE - UMX|APPS_SCHEMA_CONNECT

                      xxx session.getUserId() - 6 (this is GUEST in our FND_USER table)
                      FUNCTION_ID: NULL
                      NODE_ID: 7137
                      RESPONSIBILITY_APPLICATION_ID: NULL
                      USER_ID: 6
                      NLS_DATE_LANGUAGE: AMERICAN
                      SECURITY_GROUP_ID: NULL
                      LIMIT_CONNECTS: 2000
                      PROXY_USER_ID: NULL
                      DISABLED_FLAG: N
                      RESPONSIBILITY_ID: NULL
                      NLS_NUMERIC_CHARACTERS: .,
                      FIRST_CONNECT: 2013-02-18 13:22:21.0
                      LIMIT_TIME: 12
                      LAST_CONNECT: 2013-02-18 13:22:21.0
                      LANGUAGE_CODE: US
                      MODE_CODE: 115P
                      MAC_KEY: [B@1ffccfd
                      SESSION_ID: 1991221235
                      ORG_ID: 102
                      NLS_TERRITORY: AMERICA
                      NLS_SORT: BINARY
                      DATE_FORMAT_MASK: DD-MON-RRRR
                      COUNTER: 1
                      NLS_LANGUAGE: AMERICAN
                      HOME_URL: NULL
                      <HomeServlet> <isAuthenticated> Icx session either has expired or is invalid
                      • 38. Re: EBS SDK for ADF Integration (Session Management)
                        987410
                        Kyle,

                        I faced the same issue, I was getting the apps session as NULL. As Sara mentioned, the domain names must be the same. The EBS domain(http://ebs.testdomain.com) and the domain name of the external node on which the ADF pages are hosted (http://host.testdomain.com) had to be same and we are getting the ICX cookie as VALID now. It might not be the same case with you, but that worked for us.

                        Thanks
                        Viswa
                        • 39. Re: EBS SDK for ADF Integration (Session Management)
                          452071
                          Kyle,

                          Glad to hear that you passed the .dbc file issue. We certainly will add those details into the MOS note. I think it would also help if you could share the code from you customPhaseListener to validate it against ours.

                          Thanks,

                          Juan C.
                          • 40. Re: EBS SDK for ADF Integration (Session Management)
                            Kyle.Thomas
                            Thanks Viswa!

                            That was our issue as well. Thanks for the prompt replies and your help!
                            • 41. Re: EBS SDK for ADF Integration (Session Management)
                              Kyle.Thomas
                              There are various issues that were resolved in this thread. I recommend anyone with similar issues to read the entire thread.
                              1 2 3 Previous Next