AnsweredAssumed Answered

Oracle E-Bussines Date problem

Question asked by aderybel213309 on Nov 27, 2017
Latest reply on Nov 27, 2017 by suman.anisetty914598

Hi Boomi Boys and Girls,

 

 

I'm having trouble with an Oracle EBS-Connector. 
I've set up an Oracle E-bussiness connector in Boomi pointing to a specific procedure set up within Oracle.
I've imported a profile from this procedure.
There Are some fields of the data type DATE -> Oracle Data Types 

 

Now the profile is asking for a date/time of format yyyyMMdd HHmmss.SSS.
Which is the internal Date/time Format Of Boomi.  And setting this to any other Date/time format gives a bug asking for this Format.

How would you pass in just a date to Oracle without changing things on Oracle Side?
Sending characters is also possible but then things from Oracle side need to be changed also.

Anyone has experience in this problem ?

Outcomes