My Oracle Support Banner

Trial Balance Report Errors :Failed To Load(Odbc Driver Returned An Error (SQLExecDirectW)) (Doc ID 2053658.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

When Trial Balance Report  is run , getting error CONCAT(TreeCode,TreeVersion Name).
The following processes are run.

Create Rules XML File for BI Extender Automation
Import Oracle Fusion Data Extensions for Transactional Business Intelligence

Now got new error.
Failed to load(Odbc driver returned an error (SQLExecDirectW).)

Changes

 More Details:The hierarchies in EssBase for Balancing Segment, Cost Center was not published due to which BI Extender deleted Tree Filter columns.
Trial Balance Report has Tree Filter columns for Balancing Segment, Natural Account and Cost Center which are mapped to corresponding Tree Filter columns in Genereal Ledger - Balances Real Time subject area
Since Tree filter columns for Balancing Segment, Cost Center were deleted by BI Extender (due to hierarchy not published) , ODBC error on these segments was encountered while  running Trial Balance Report.
Once the BI Extender deletes Tree filter columns from General Ledger - Balances Real Time SA, it wont map those back in incremental runs.

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
References


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.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.