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
AND WHAT SHOULD BE WRITTEN IN THE ACTION TAB ?
ReplyDeleteAction depends on your requirements.
ReplyDeletePlease explain your requirements.
ReplyDeletePlease help me to personalize in the ID .
ReplyDeleteCondition:-
If any national identifier (Id Number) is inserted and it will validate that if it is duplicate and already exist. It doesn't allow to go further in the Form to create new/update any person detail.
Thanks,
Syed Hasan
Shirazzzz you have to create a new personalization on validate trigger and pass the ID Number to query and count the number of rows returned.
ReplyDeleteIf you find more than 0 rows than it means this Id number is already exits.