Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Values changing due to When-Validate-item Trigger

535237Nov 3 2009 — edited Nov 6 2009
Hello,

I am developing a Form6i. I have a customer_name lov field. I have when-validate-item trigger to the cutomer name field.
When i select the cutomer_name i have other fields which will derive depending on the customer_name like payment_term, Sales_rep, Price list and so on.

The issue i have is Ex:

When i select Customer_Name = 'ABCD'. Payment Term field will be driven using some code from when_validate_item trigger and populate Payment Term = Net 45.
When i change the Payment Term = Net 30 and Save the Form, it will come back to Net 45 and saves.
I know this is because of the when-validate-trigger fires again at Form level.

I want to change the payment_term to change only when customer_name is changes. Kind of Same funtionality as Oracle Order Entry Form

How do i over come this, can any one please help.

Thanks.
This post has been answered by user602088 on Nov 6 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 4 2009
Added on Nov 3 2009
6 comments
864 views