Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

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

This post first appeared on EBiz Integration Technics, please read the originial post: here

Share the post

Oracle Applications :Receivables: : Duplicate Receipt Numbers


Subscribe to Ebiz Integration Technics

Get updates delivered right to your inbox!

Thank you for your subscription