Siebel Open UI, Tools, Scripting and EAI (MOSC)

MOSC Banner

UTC DateTime value

edited Dec 16, 2016 12:27AM in Siebel Open UI, Tools, Scripting and EAI (MOSC) 9 commentsAnswered
Hi,

We are inserting SRs from an external system into Siebel. In the incoming external XML one of the attributes is a date that comes in a UTC format like this:

<Date>2012-01-21T21:05:23.000000+0100</Date>

When we map this value to our internal IO we get the error:

Error invoking service 'EAI Data Transformation Engine', method 'Execute' at step 'Map SR'.(SBL-BPR-00162)
--
The value '<?>' cannot be converted to a date time value.(SBL-DAT-00359)

If I change the format of the date in the incoming XML for something like this

<Date>01/21/2012 21:05:23</Date>

It works but we lose the UTC information that is critical for us.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center