My Oracle Support Banner

When Attempting To Pass "value" To OptionalData Via API Call Email Fails To Send With #if Statement Comparing To A Number Receive an Error: The Only Legal Comparisons Are Between Two Numbers, Two Strings, Or Two Dates (Doc ID 2209995.1)

Last updated on DECEMBER 05, 2022

Applies to:

Oracle Responsys Marketing Platform Cloud Service - Version 6X and later
Information in this document applies to any platform.

Symptoms

When Attempting To Pass "value" To OptionalData Via API Call Email Fails To Send With #if Statement Comparing To A Number in RPL, example:

{
"name": "Gift_Card_Amount",
"value": "100.00"
}

and using an #if statement in RPL:
<#if (Gift_Card_Amount gt 99.00)>

the following error occurs in Live Report Failed:

Template /contentlibrary/campaigns/QA_eGift_Card_Purchaser/QA_eGift_Card_Purchaser.htm caused an execution error: The only legal comparisons are between two numbers, two strings, or two dates. Left hand operand is a freemarker.template.SimpleScalar Right hand operand is a freemarker.template.SimpleNumber

The issue can be reproduced at will with the following steps:
1. Make API Call with OptionalData

2. Using #if statement in RPL

3. Trigger API Call

4. Review Live Report Failed

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.