My Oracle Support Banner

How to Extract Fiscal Week Information Based On Custom Date Attributes In Reports? (Doc ID 2143531.1)

Last updated on MARCH 20, 2019

Applies to:

Oracle Fusion Sales Cloud Service - Version and later
Information in this document applies to any platform.


Our Fiscal Calendar is 4-4-5 and does not begin or end per Standard Calendar Year. We have reports that are to be built on Fiscal Week information. We need to extract this information from custom date attributes created on the opportunity object. Since we cannot extract Fiscal Information from custom date attributes using oob subject areas, we are building custom subject areas and defining date leveling for the custom date attributes. However, the date leveling is available only for Fiscal Quarter, Fiscal Month but not for Fiscal Week.

How to extract Fiscal Week information in the reports using the date leveling folder?


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

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