My Oracle Support Banner

The Date Functions Are Not Working In Assign Action Results Error "Addition operator only accepts numbers as operands" (Doc ID 2465161.1)

Last updated on NOVEMBER 16, 2020

Applies to:

Oracle Integration-OIC - Version 18.2.5 and later
Information in this document applies to any platform.

Symptoms

This knowledge article reflects updated product names. Oracle Integration (OIC) was formerly known as Autonomous Oracle Integration Cloud (AOIC, A-OIC, AIC, OAIC,OIC, OAC). Please see KM document for the full list of recently renamed PaaS services.

On : 18.2.5 version, Integration UI/API

ACTUAL BEHAVIOR
---------------
Following date functions are not working in Assign action in an integration flow.

fn:current-dateTime()
xsd:dateTime(inputArg)
xsd:dayTimeDuration(inputArg)
fn:days-from-duration(inputArg)
fn:hours-from-duration(inputArg)
fn:minutes-from-duration(inputArg)

IF the above functions used in Assign, expression builder fails with error:



ERROR
-----------------------
Addition operator only accepts numbers as operands. Operand is not numeric: xsd:dateTime("2018-08-22T07:44:42")

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an assign action and use any of the above date function and not it won't take effect.

 

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
References


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