Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

user633859Aug 3 2011 — edited Feb 3 2012

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.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 2 2012

Added on Aug 3 2011

#integration-adapters, #integration-general, #soa-process-management

2 comments

1,169 views