This discussion is archived
2 Replies Latest reply: Jun 7, 2012 2:37 PM by user414585 RSS

Form Personalization: How to validate record?

user414585 Newbie
Currently Being Moderated
Hi,

We need your help. We have developed one custom form which captures data for Inter-Org transfer in Oracle Inventory. User enters Source Organization Code, Destination Organization Code, Item Number and rest of all other information. Source & Destination Organization are in one block of the form and Item number , Quantity etc are in another block on the same form. Item Number field is showing LOV of all list of items from mtl_system_items_b from master Org and that's the requirement of the form.

Through Form Personalization, User wants while saving the record on the form, it should validate item-Organization assignment for both Source & Destination organization. Item should exist in Source & Destination organization else it should display error message while saving the record.

Please help me how we can achieve this through Form Personalization.



Thanks

Rajesh

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points