Oracle Fusion - OIC - Helpful Points

OIC Helpful/Reference Points

Q1 - How to pass current date (SYSDATE) in required format in OIC

A1: fn:current-dateTime() => Send current date

To change the format, we can use the following

xp20:format-dateTime(DateTime,Format)

Example: xp20:format-dateTime(string(fn:current-dateTime()),'[MNn,3-3]-[YYYY]')

Q2 - How to add months in the date stored in the string variable in OIC integration?

A2: string(xsd:date('2016-12-25') + xsd:yearMonthDuration("P1M"))

Q3 - How to get the date by adding days to the current date in OIC integration?

A3: string(fn:current-dateTime()-xsd:dayTimeDuration(‘P30D’))