Oracle Database Discussions

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!

cannot SET NLS in a distributed transaction

704759Jun 2 2009 — edited Jun 3 2009

I meet some exceptions as below when I execute a normal stored procedure in Oracle EBS underlying database.
Could anyone help to look at this problem?

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.
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.FND_GLOBAL", line 240
ORA-06512: at "APPS.FND_GLOBAL", line 1410
ORA-06512: at "APPS.FND_GLOBAL", line 1655
ORA-06512: at "APPS.FND_GLOBAL", line 2178
ORA-06512: at "APPS.FND_GLOBAL", line 2320
ORA-06512: at "APPS.FND_GLOBAL", line 2258
ORA-06512: at "APPS.IBM_WEBSPHERE_CUSTOMER_IMP", line 3
ORA-06512: at line 1
, error code: 20001

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 1 2009

Added on Jun 2 2009

#general-database-discussions

2 comments

2,678 views