This discussion is archived
1 2 3 Previous Next 41 Replies Latest reply: Feb 18, 2013 3:31 PM by Kyle.Thomas Go to original post RSS
  • 30. Re: EBS SDK for ADF Integration (Session Management)
    Kyle.Thomas Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    bummer =[                                                                                                                                                                                                                                                       
  • 34. Re: EBS SDK for ADF Integration (Session Management)
    987410 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points