Invoice Number duplicate check

Summary:

Hi Team,

In EBS, we have used when validate trigger in form personalization to identify duplicate invoices as per following sceneries.

Examples:

Invoices number: 12340785 vs i234O785.

Suspected Duplication Invoice - 1's vs i's (#1). If all 1's were i's

Suspected Duplication Invoice - i's vs 1's (#2). If all i's were 1's

Suspected Duplication Invoice - 0's vs O's (#3). If all 0's were O's

Suspected Duplication Invoice - O's vs 0's (#3). If all O's were 0's

How to use when validate trigger on invoices number field with page personalization.

System should automatically restrict users when trying to save invoices with similar number.