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.