Process not triggered based on date as a Start Condition

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The admin designed a process that is supposed to trigger based on the update of Benefit Plan Details. The process stopped working after migrating to another database server. This is the start condition:

Start Condition: any( ( Benefit Plan Detail (Subobject) Created Date != '1/1/90' ) )

any("benefitplandetail", benefitplandetail.created_date != date("1990-01-01T00:00:00"), benefitplan.odf_pk, ctx )

Resolution

• NLS_DATE_FORMAT not set correctly in the database.
• This is a documented requirement for Oracle and Clarity.
• Details on how to setup NLS_DATE_FORMAT are here: Check and set NLS_DATE_FORMAT