How to resolve isssue "ORA-02074: cannot SET NLS in a distributed transaction" when calling fnd_glob
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