R12: OIE: WebEx ORA-02074: Cannot SET NLS In A Distributed Transaction

(Doc ID 2309036.1)

Last updated on SEPTEMBER 19, 2017

Applies to:

Oracle Internet Expenses - Version 12.2.4 and later
Information in this document applies to any platform.
APEXP Expense Approval workflow
AME Enabled #EXCEPTION -20001
ORA-20001: Oracle error -20001: ORA-20001: Oracle error -2074: ORA-02074: cannot SET NLS in a distributed transaction
Solution Accelerator (SOA)
Imaging ExpenseReceiptProcessing
AP_WEB_EXPENSE_WF.apwxwkfb.pls

Symptoms

On : 12.2.4 version, Approval Workflow & Builder Issues

When submitting an expense report for approval the following error occurs in the workflow:

ERROR
-----------------------
Item Type Item Key Begin Date End Date Activity
---------- --------------- ------------------ ------------------ ---------------------------------------------
...
31-MAY-17 15:20:03 Manager (Spending) Approval Process/AME Enabled ERROR #EXCEPTION


20 rows selected.

**** Errored Activities

Activity Result Error Name
--------------------------------------------- --------------- ------------------------------
Error Message
------------------------------------------------------------------------------------------------------------------------------------
Error Stack
------------------------------------------------------------------------------------------------------------------------------------
AME Enabled #EXCEPTION -20001
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.

Wf_Engine_Util.Function_Call(AP_WEB_EXPENSE_WF.CALLBACKFUNCTION, APEXP, 414141, SET_CTX)
Wf_Engine_Util.Execute_Selector_Function(APEXP, 414141, SET_CTX)
Wf_Engine_Util.Function_Call(AP_WEB_EXPENSE_WF.AMEEnabled, APEXP, 414141, 649714, RUN)


*** Error Process Activity Statuses

Begin Date Activity Status Result User
------------------ --------------------------------------------- -------- --------------- ---------------
31-MAY-17 15:20:03 ROOT/Error Process with Retry ACTIVE #NULL
31-MAY-17 15:20:03 Error Process with Retry/Start COMPLETE #NULL
31-MAY-17 15:20:03 Error Process with Retry/Initialize Error COMPLETE COMPLETE
31-MAY-17 15:20:03 Error Process with Retry/Notify Administrator with Retry NOTIFIED KJONES


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit an Expense Report for approval
2. View workflow monitor and see the error

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