OIA data save operation to Oracle Database through Oracle Integration Cloud

Vidya Jade

Hi Team,

I am trying to Save OIA data (3 number and 1 Text attribute will be captured while OIA Interview Journey) to Oracle Database with the help of Oracle Integration Cloud.

We could successfully create an Integration in OIC, and on executing the Interview journey, we are facing the issue from OIC while saving data to database. Please refer the attached snapshot (Image1.png and Image2.png) for your quick reference.

Referring to Image3.png, we are getting all the Interview Journey data in the OIC, but only while saving those data to database, there is some issue 'DBWriteInteractionSpec Execute Failed Exception.'

Also note, we are dealing with on-premises database so we are using the agent configuration, even it is also running as expected, so this shouldn't be the issue.

Can anyone please help ?

Thanks,

-Vidya.

Richard Napier

Hi

Looking at the error message

: The object [glooal], of class [class java.lang.String], could not be converted to [class java.math.BigDecinal].

it does sound like the database is expecting a numeric and you are passing a String into the column. Are the column classes all correctly defined ?

R