Cloud Platform

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!

XML Disbursement Payment file - datetime formatting

3424814Aug 2 2018

Hi,

I'm trying to create a custom disbursement payment template and am having issues with the datetime formatting in XSL version 1.0.

Seeded:

<xsl:value-of select="PaymentInstructionInfo/InstructionCreationDate"
/>

</CreDtTm>

Result - <CreDtTm>2018-07-31T15:02:20+00.00</CreDtTm>

We need to remove the red highlighted so tried the following but it's not working. The format payment files has the error "Parse Error in format-dateTime function". I think the issue is with the syntax for the datetime format. Can somebody help with the correct format.

Custom:

<xsl:value-of select="format-dateTime(PaymentInstructionInfo/InstructionCreationDate, '[Y0001]-[M01]-[D01]T[H01]:[m01]:[s01]')"/>

</CreDtTm>

Required Result - <CreDtTm>2018-08-01T15:36:26</CreDtTm>

Added on Aug 2 2018

#cloud-applications, #cloud-applications-discussions, #xml

1 comment

598 views