Need to fetch records with valid primary phone in OTBI analysis

Summary

In OTBI, How to check if all characters in phone number field is numeric

Content

Hi,

In OTBI analysis, I have a requirement to fetch employees whose primary phone number is NOT VALID. This means, we need to check if all characters in the primary phone number field is Numeric.

I tried using the below condition in the "Worker"."Primary Phones Number" filter

LENGTH(TRIM(TRANSLATE("Worker"."Primary Phones Number", '0123456789',' '))) IS NOT NULL

However, this is giving error. Not sure if the TRANSLATE function is supported in OTBI.

I also tried using REGEXP_LIKE. Even this errored out.