My Oracle Support Banner

BI Publisher Custom Report Using an Excel Template Does Not Recognize Date Columns (Doc ID 3013182.1)

Last updated on MARCH 28, 2024

Applies to:

Primavera Unifier Cloud Service - Version 20.12 and later
Primavera Unifier - Version 20.12 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------

In a custom report that has an Microsoft Excel custom template, when the report is exported from Unifier, any date columns are not read as a date value by Excel. As a result, users are unable to filter the date columns by month or year.


EXPECTED BEHAVIOR
-----------------------

The date columns in the exported report should be considered as date values when opened in Excel.

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
Cause
Solution


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