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

Last updated on MARCH 08, 2017

Applies to:

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

Goal

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?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms