Skip to Main Content

Oracle Forms

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!

SSN Masking using Format Mask option in Forms

934365Sep 19 2012 — edited Sep 20 2012
All,

I need to mask the SSN field with 'X' for the first 5 digits.
Is it possible to achieve this using the Format Mask option.

I tried many regular expressions and can only format the number 123456789 to 123-45-6789 but not into XXX-XX-6789.

Can you please help with a solution.

As of now, I am using the post-query and other triggers to do this. But I'm feeling that there must be a better solution.

My solution is very complex where I have the actual SSN in a hidden field and show the masked ssn in the visible field.
SSN is the driving value for our business logic which I cannot change at this point.

Thanks for your help
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 18 2012
Added on Sep 19 2012
3 comments
1,480 views