ORA-20001 and ORA-02074 Cannot Set NLS In Distributed Transaction Using Smart View

(Doc ID 2348130.1)

Last updated on MAY 02, 2018

Applies to:

Oracle In-Memory Cost Management for Process Industries - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

We have configured In Memory Cost Management instance and using smart view to access it.

We are getting above error while accessing it form smart view.


ERROR
-----------------------
Error in main handler: 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').
hes been detected in fnd_global.set_nls
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.APP_GLOBAL", line 265
ORA-06512: at "APPS.APP_GLOBAL", line 1582
ORA-06512: at "APPS.APP_GLOBAL", line 2029
ORA-06512: at "APPS.APP_GLOBAL", line 2546
ORA-06512: at "APPS.APP_GLOBAL", line 2698
ORA-06512: at "APPS.APP_GLOBAL", line 2636
ORA-06512: at "APPS.CMI_SV_SIMULATION_WRAPPER", line 391
ORA-06512: at "APPS.CMI_SV_SIMULATION_WRAPPER", line 328
ORA-06512: at line 1
in DBConnection.getAppsInitConnection


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms