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.


Responsibility:  Receivables
Navigation: Receipts > Receipts > Help >  Diagnostics > Custom Code > Personalize

Enter the below details.
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...