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

    Getting error -ORA-01840: input value not long enough for date format

    in Reporting and Analytics for HCM 5 comments

    Summary:

    I am getting error in BI report due to below line of code. Error - ORA-01840: input value not long enough for date format

    to_date(:sdt,'yyyy-MM-dd') <= to_timestamp(fucif.value,'YYYY-MM-DD"T"HH24:MI:SS.ff3"Z"')

    where fucif is FF_USER_COLUMN_INSTANCES_F table

    Can anyone please help me.

    Content (please ensure you mask any confidential information):


    Version (include the version you are using, if applicable):

    23D

    Code Snippet (add any code snippets that support your topic, if applicable):

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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