Oracle Receivables: Duplicate Receipt Numbers form personilazation

Problem: How to avoid duplicate Receipt numbers while entering.

Solution:

Responsibility:  Receivables
Navigation: Receipts > Receipts > Help >  Diagnostics > Custom Code > Personalize
 
Enter the below details.
 
Trigger Event : WHEN-VALIDATE-RECORD
Trigger Object : RGW_FOLDER


Condition :

0<>(select count(*) from ar_cash_receipts_all a where a.RECEIPT_NUMBER=:RGW_FOLDER.M_RECEIPT_NUMBER )
and :system.record_status='INSERT' AND :RGW_FOLDER.CASH_RECEIPT_ID IS NULL

 
Click On Actions Tab

Seq : 10
Type : Message
Message Type : Error
Message Text : Please enter unique Receipt Number