Saturday, July 11, 2015

Oracle Forms Personalization: when validate record fires multiple times

In Oracle Apps if your doing a personalization on Oracle Forms and requirement is to Display a Message on WHEN-VALIDATE-RECORD. Its typical that WHEN-VALIDATE-RECORD fires multiple times and the Message will be displayed multiple times.

The way to handle this situation is simply to check the RECORD STATUS is in NEW CHANGED. Include the below condition in your personlization

:SYSTEM.RECORD_STATUS IN ('NEW','CHANGED')






2 comments:

Anonymous said...

Thank you very much for this post

Smith said...

Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.