My Oracle Support Banner

ORA-20001,ORA-2074:Consolidation Cross Instance Data Transfer (Doc ID 469104.1)

Last updated on SEPTEMBER 05, 2019

Applies to:

Oracle General Ledger - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

On the Consolidation Transfer Screen, an error is received after selecting Run Options > Validate Remote Sign on:
     Cross Instance Data Transfer Failed due to other Reasons. (RESULT=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_paramenters ('NLS_LANGUAGE;'AMERICAN').)

### Steps to Reproduce ###
Using GL Responsibility
Navigate to CONSOLIDATION --> TRANSFER
Query for Specific mapping and execute the query.
Enter period on subsidiary
Enter period on parent
Press run options
Verify database link and responsibility
Press the Validate button
Message box appears saying that this may take a few minutes  - acknowledge message
Error box appears
 

Changes

FND patch 11I.ATG_PF.H.RUP 5 has been applied.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.