Trial Balance Report Errors :Failed To Load(Odbc Driver Returned An Error (SQLExecDirectW))
Last updated on MARCH 08, 2017
Applies to:Oracle Fusion General Ledger Cloud Service - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
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).)
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.
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