Total Pageviews

March 16, 2017

3/16/2017 07:45:00 PM



Oracle Receivbales Duplicate Numbers
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
 
Related Posts Plugin for WordPress, Blogger...