Friday, December 20, 2024

OIC XSLT - Use of fn:format-number() | Formatting Large Amount Values to Two Decimal Places in XSLT

Use Case: Formatting Large Amount Values to Two Decimal Places in XSLT.

Scenario:

We are receiving an amount field value in the following format:

Input Data: 0000567892987

Our goal is to transform this input into a properly formatted number with two decimal places:

Target Output: 5678929.87

solution code:

fn:format-number((number($ReadSourceFile/nsmp0:ReadResponse/ns25:Payments/ns25:FileTrailer/ns25:TotalStubAmount) div 100), "#.00")




No comments:

Post a Comment

Featured Post

OIC - Sending JSON Data as Email Body Content via Twilio SendGrid API in OIC

Use Case Description: When integrating Oracle Integration Cloud (OIC) with Twilio SendGrid API to send emails, JSON data intended for the em...