Oracle Receivables: Duplicate Receipt Numbers
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
