For example, if you have the check currency code in USD, then the amount in words will be printing some thing like "One Thousand Four Hundred Twenty-Two Dollars And Eighty-Two Cents*****"
but if you have the check currecy code in SGD, then the amount in words will be printing some thing like "One Thousand Four Hundred Twenty-Two And Eighty-Two *****"
But some of the bank will be very particular about printing the units (dollar, euro,..) and subunits (cents,..) in the check print.
Ok here is the solution for this, From Release 12.0.2 oracle had defined some messages which we can use to print these units and subunits.
Unit:
IBY_AMT_IN_WORD_UP_[CURR] (for plural eg. Dollars)
IBY_AMT_IN_WORD_US_[CURR] (for singular eg. Dollar)
Subunit:
IBY_AMT_IN_WORD_SUP_[CURR] (for plural eg. Cents)
IBY_AMT_IN_WORD_SUS_[CURR] (for plural eg. Cent)
Here [CURR] is the currency code.
I know this may be a simple known solution for lot of you but this will be a grey area for lots and lot of new commers :)
for more details refer metalink document ID 465244.1
1 comment:
Dear AK Lakshmanan,
Thaks for your post it was really helpful. Please do post many more like the above.
Regards,
Chandan
Post a Comment