Technology Stack - EBS (MOSC)

MOSC Banner

How to resolve isssue "ORA-02074: cannot SET NLS in a distributed transaction" when calling fnd_glob

edited May 28, 2019 5:01AM in Technology Stack - EBS (MOSC) 3 commentsAnswered

For example below SQL statement it is calling the fnd_global.apps_initialize over a DB Link,

DECLARE

  lv_message   VARCHAR2 (1000);

BEGIN

   fnd_global.apps_initialize@TS10 (user_id => 12602, resp_id => 60184, resp_appl_id => 700);

END;

when executing it in TOAD, below error occuured, how to resolve it?

Error at line 1

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 271

ORA-06512: at "APPS.FND_GLOBAL", line 1575

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center