Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Incorrect Timestamp dateTime format: expected YYYY-MM-DDTHH:MM:SS.NNNNNNNNN

user8539507Aug 3 2012 — edited Feb 26 2020
When i insert the data XML data using BPEL Process getting the following exception for date-format
detail>oracle.j2ee.ws.client.jaxws.JRFSOAPFaultException: Client received SOAP Fault from server : Exception Description: Incorrect Timestamp dateTime format: [2010-01-01] (expected [YYYY-MM-DDTHH:MM:SS.NNNNNNNNN])</detail>
</part>

I have used the following date format and tried all the cases same above error.
xp20:format-dateTime(../../DocumentHeader/EffectiveDate,'[Y0001]-[M01]-[D01] [h]:[m01]:[s01]')
xp20:format-dateTime(../../DocumentHeader/EffectiveDate,'[Y0001]-[M01]-[D01]')

Any idea how to convert Date to date format given error?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 2 2012
Added on Aug 3 2012
2 comments
1,874 views