My Oracle Support Banner

How To Return The Month Name? MonthName Function Returns the Month Number (Doc ID 2737592.1)

Last updated on JANUARY 19, 2024

Applies to:

Oracle Fusion Loyalty - Version and later
Oracle Fusion Incentive Compensation Cloud Service - Version and later
Oracle Fusion CX Sales Cloud Service - Version and later
Oracle Fusion B2B Service Cloud Service - Version and later
Information in this document applies to any platform.


The MonthName function that should return the name of the month for data provided. However, it is currently returning the number of the month.

To recreate the scenario:

  1. Navigate to BI Analytics
  2. Create a new analysis with a new subject area. For example, use "Sales - CRM Pipeline"
  3. Add "Opportunity"."Created Date"
  4. Edit Formula field and change the formula to: MONTHNAME("Opportunity"."Created Date")

For example, if the Created Date is 12/15/2020, customer expects to return December. However, it returns 12.

How to display the month name?


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.