OTBI - Account Analysis Report issue with Accounting Date format
(Doc ID 2669976.1)
Last updated on JUNE 10, 2020
Applies to:Oracle Fusion General Ledger Cloud Service - Version 11.13.20.01.0 and later
Information in this document applies to any platform.
On Applications Oracle Fusion 11.13.20.01.0:
When the user tries to export the Transaction Details Report to Excel the Accounting Date column is not formatted as DATE. Also, they get the following error message:
We found a problem with some content in 'Subledger Journals.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click yes.
-- Expected Behaviour
The Excel export should carry over the Accounting Date formatting
-- What is working
Report is pulling the data and all other export formats are working fine (PDF, CSV, etc)
The issue can be reproduced at will with the following steps.
1. Navigate to FRC > Bi Catalog > FIN > GL > seeded "Account Analysis Report"
2. Run the report for the parameters.
3. Dill down to Transaction Details
4. export the report to excel.
Bug 31193901 - OTBI - ACCOUNT ANALYSIS REPORT ISSUE WITH ACCOUNTING DATE EXPORT TO XLS FORMAT
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