20001:Oracle 报错 Ora-20001

 配资学习 配资网

这应该是2113个bug配资20001,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