Oracle Fusion Etext Report template output file numeric filed decimal value format issue

Problem Summary:

I have generated Etext file template where decimal numeric field value in Amount not showing properly. I have tried with format masking also but still facing the same issue.

We have to provide this output text payment detail file to Bank system so they can make payment against the customer.

Bank the requirement is to use decimal separator ‘,’ instead of ‘.’ (Bank accepted format – 10,50 QAR)

i.e If payment the amount is 10.50 than output showing 10.5 only. Which is not correct as per the bank requirement, bank system wants 10.50 as an output.

i.e If payment the amount is 1.88 than output showing 1.88 properly.

Report Path: Shared Folders/Custom/Financial/Payment

Report Name: Disbursement payment file formats. (Seeded Report we made custom template)

Etext RTF template Amount field datatype where we facing an issue:

I have tried with the format, masking option suggested by oracle but we not able to use this solution because oracle uses Decimal separator as ‘.’ When as per bank the requirement we have to use decimal separator as ‘,’

Oracle SR suggested solution: (Which is not working in our case, as we have required decimal separator ‘,’)

Solution:

Step1: Add Format setup command in RTF template.

Step 2: Add extra ‘0’ in decimal part based on conditional format. You can add condition as per your business needs.

Syntax: 

IF Length(DECIMAL_PART (PaymentAmount/Value)

) = 1 THEN

‘0’

END IF

Now issue will be resolve.

Report output: