Using Regular Expression in EBS
OR
Using Regular Expression in Personalization
OR
NIC Format Verification
According to Pakistan's NIC format that is XXXXX-XXXXXXX-X
where X is a digit.
We can validate entered NIC format using Regular Expression also called REGEXP.
For Example we want to apply validation on Oracle EBS HRMS - Maintain Employee From.
Open Personalization then type the following as shown in the picture in the condition tab.
NVL((
SELECT 1
FROM DUAL WHERE
REGEXP_LIKE(:PERSON.NATIONAL_IDENTIFIER,'^[0-9]{5}-[0-9]{7}-[0-9]{1}$')
),0) = 0
