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 188.8.131.52 to 184.108.40.206 [Release 11.5.10]
Information in this document applies to any platform.
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
### 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
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