search cancel

Data type of input parameters for cmn_date_time_diff_fct function

book

Article ID: 255513

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Following error is being thrown while accessing an _v2 view, of a custom object.

ORA-01861: literal does not match format string

Environment

Version: 16.0.3

Cause

The data type of input parameters defined in the cmn_date_time_diff_fct function is DATE. However, some _v2 views that make use of this function are invoking it by converting dates into varchars using the to_char function.

Resolution

  1. Create a dummy attribute in the object that the _v2 view belongs to
  2. This will refresh the _v2 view. Access it using a SELCT statement to verify
  3. Delete the attribute created in step 1