Trial Balance Report Errors :Failed To Load(Odbc Driver Returned An Error (SQLExecDirectW))
(Doc ID 2053658.1)
Last updated on MARCH 08, 2017
Oracle Fusion General Ledger Cloud Service - Version 18.104.22.168.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!