Fusion Apps BI Publisher: Incrementing Date Parameters In BI Publisher Scheduled Report Fails {$SYSDATE()-1$}, error Date should be of the format: MM-dd-yyyy (Doc ID 1983488.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Fusion Application Toolkit - Version 11.1.9.2.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.9.2.0 and later
Oracle Fusion Global Human Resources Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

Oracle Fusion Global Human Resources Cloud Service, R9.2

Issue with a BIP Data Model.

Description from our customer:
"I am trying to increment an effective date parameter in a BI Publisher schedule.

I have defined the parameter in the Data Model as a date field and it has a default value of {$SYSDATE()$}

When I come to schedule this report it puts the date in as today's date and won't let me enter {$SYSDATE()$}, i receive an error of Date should be of the format: MM-dd-yyyy

This has previously worked and I will upload screenshots of the error and when this has previously run"

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms