20001,Oracle 报错 Ora-20001

这应该是2113个bug20001,5261metalink上的说明4102如下1653ORA-20001,ORA-2074:Consolidation Cross Instance Data Transfer [ID 469104.1] Modified 12-AUG-2010 Type PROBLEM Status MODERATED In this Document Symptoms Changes Cause Solution ReferencesPlatforms: 1-914CU; This document is being delivered to you via Oracle Support\’s Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.Applies to: Oracle General Ledger – Version: to – Release: 11.5.10 to 11.5.10Information in this document applies to any platform.SymptomsOn 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 ResponsibilityNavigate to CONSOLIDATION –> TRANSFERQuery for Specific mapping and execute the query.Enter period on subsidiaryEnter period on parentPress run optionsVerify database link and responsibilityPress the Validate buttonMessage box appears saying that this may take a few minutes – acknowledge messageError box appears ChangesFND patch 11I.ATG_PF.H.RUP 5 has been applied. CauseThis is caused by Bug 6447350.APPS Initialization uses dbms_session API to set NLS parameters that is not supported across database links. Fixed files:patch/115/sql/glucirmb.pls-115.23.115103.3 patch/115/sql/glucirms.pls-115.15.115103.3 patch/115/sql/glucitrb.pls-115.36.115103.3 SolutionTo implement the solution, please execute the following steps:1. Download and review the readme and pre-requisites for Patch 9774858.2. Ensure that you have taken a backup of your system before applyingthe recommended patch.3. Apply the patch in a test environment.4. Retest the issue.5. Migrate the solution as appropriate to other environments. References RelatedProducts Oracle E-Business Suite > Financial Management > Financial Control and Reporting > Oracle General Ledger Keywords DISTRIBUTED TRANSACTIONS; DISTRIBUTED; CONSOLIDATION; CONSOLIDATION TRANSFER; 20001Errors ORA-20001; ORA-2074; PLS-115