APEX

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!

Format Mask for Local Currency with Negative Value

Sad21Jan 26 2017 — edited Jan 26 2017

Hi Experts,

I am using Oracle Apex 5

I am facing issue when try to format Number with Local currency using

FML999G999G999G999G990D00 for item number format
accounting.formatMoney(myvalue, "£", 2); using javascript function if item value is changed.

Now the issue is occurring when user is entering negative value.

For example: If user enters -100 it changes it to £-100 .... while saving its throwing. I have NUMBER datatype column

"PL/SQL: numeric or value error: character to number conversion error".

Let me know if you need any other details,

Regards,

Sadia

This post has been answered by Huzaifa_Apex on Jan 26 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 23 2017

Added on Jan 26 2017

#apex-discussions

2 comments

834 views