Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

Is it possible to use WHEN-LIST-CHANGED on forms personalization?

User_BU5N5May 31 2021

I'm using EBS R12
I'm trying to write a personalization for orders form in Oracle EBS. Requrement: When you insert an inventory in shipping tab in lines, the personalization should insert a subinventory automatically. We have a list of inventories for which this behavior should be used, so it will only work for inventories from a select statement, and subinventory is chosen by custom select as well. Seems that form trigger WHEN-LIST-CHANGED would work perfectly here, but we cant use that trigger in forms personalization. I tried using WHEN-VALIDATE-RECORD but: doesnt work for some reason, even if it did work, the user wouldn't see the change, unless he saves the form and goes back to check. At this point I'm using WHEN-VALIDATE-RECORD to display a warning that subinventory is empty, but thats simply just not enought. Is there a way to use WHEN-LIS-CHANGED by for examle launching a stored procedure from forms personalization? Or maybe custom.pll edit would be required? Any ideas or help would be appreciated

Comments
Post Details
Added on May 31 2021
1 comment
466 views