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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms