2 Replies Latest reply: Feb 3, 2012 4:29 PM by user10206381 RSS

    ORA-02074: cannot SET NLS in a distributed transaction has been detected

    user633859
      Hi Guys,
      we are developing Mobile apps applicaiton for iExpense approval functionality. While testing this functionality we are getting the following error. Please help me out.

      ORA-20001: Oracle error -20001: ORA-20001: Oracle error -2074: ORA-02074: cannot SET NLS in a distributed transaction has been detected in fnd_global.set_nls.set_parameter('NLS_LANGUAGE','AMERICAN'). has been detected in fnd_global.set_nls.

      The process is: iExpense report is created by the user at EBS 11i side. We are using SOA to connect to 11i through apps adaptor. The user who is going to approve will login to the mobile(iPad) and approves the iexpense report. The approve value is passing to the workflow and resumes. But while executing the next function,AP_WEB_EXPENSE_WF.storenotes, the above error is getting.

      We checked the payload structure and did not find any error.


      any one have idea how to close the distribution transaction after the workflow resumes.


      Your help is greatly appreciated. Please let me know if you need any further details.

      Thanks,
      Pal.