My Oracle Support Banner

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.

Symptoms

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:

-- Error
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)

 -- Steps
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.

Changes

 Bug 31193901 - OTBI - ACCOUNT ANALYSIS REPORT ISSUE WITH ACCOUNTING DATE EXPORT TO XLS FORMAT 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.