You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    How to Resync Arabic Hijrah Calendar in Oracle Fusion

    edited Feb 6, 2025 4:59PM in Reporting and Analytics for HCM 2 comments

    We are experiencing discrepancies in the dates within Oracle Fusion, specifically with the 'Arabic Hijrah calendar'. leading to issues with reports using Hijri Date.

    The code I am using is :
    to_char(PAPF.START_DATE,'YYYY/MM/DD','NLS_CALENDAR=''Arabic Hijrah''')

    but dates like '07-Jun-2024' should be '1445/12/1 ' in Hijri date but it's '1445/11/30'
    also '13-Nov-2022 ' should be '1444/4/19' in Hijri date but it's '1444/4/18'

    Kindly we need to ensure synchronization with the latest updates for Arabic Hijrah Calender

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!