{"id":7762,"date":"2025-06-20T16:05:14","date_gmt":"2025-06-20T16:05:14","guid":{"rendered":"https:\/\/morphis-tech.com\/blog\/?p=7762"},"modified":"2025-06-20T16:21:08","modified_gmt":"2025-06-20T16:21:08","slug":"understanding-when-validate-item-and-when-validate-record-in-oracle-forms","status":"publish","type":"post","link":"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/","title":{"rendered":"Understanding &#8220;When Validate Item&#8221; and &#8220;When Validate Record&#8221; in Oracle Forms"},"content":{"rendered":"\n<p>Oracle Forms is a powerful tool for building data entry applications with a graphical user interface. One of its key features is the use of <strong>triggers<\/strong>, which allow developers to control application behavior based on user interactions.<\/p>\n\n\n\n<p>Two important validation triggers in Oracle Forms are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>&#8220;When Validate Item&#8221; (WVI)<\/strong> \u2013 Validates data at the <strong>field (item) level<\/strong> before the user moves to another field.<\/li>\n\n\n\n<li><strong>&#8220;When Validate Record&#8221; (WVR)<\/strong> \u2013 Validates the <strong>entire record<\/strong> before saving or navigating away from it.<\/li>\n<\/ul>\n\n\n\n<p>Although both triggers ensure data integrity, they have different scopes and execution timings. This article explains their differences, use cases, and best practices.\u00a0<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong>What Is <strong>1. When Validate Item in Oracle Forms<\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. <strong>What is &#8220;When Validate Item&#8221;?<\/strong><\/h3>\n\n\n\n<p>The <strong>When Validate Item (WVI)<\/strong> trigger fires when the user <strong>modifies<\/strong> a field and then tries to leave it. If the user does not change the field\u2019s value, the trigger <strong>does not fire<\/strong> even if they navigate away.<\/p>\n\n\n\n<p><strong>Use Cases for &#8220;When Validate Item&#8221;<\/strong><\/p>\n\n\n\n<p>\u2705 <strong>Data Formatting<\/strong> \u2013 Ensuring that input follows a specific format (e.g., validating email or phone number formats).<br>\u2705 <strong>Value Constraints<\/strong> \u2013 Checking that numeric values fall within an acceptable range (e.g., a discount cannot exceed the total price).<br>\u2705 <strong>Business Rule Enforcement<\/strong> \u2013 Preventing users from entering logically incorrect values (e.g., a start date cannot be after an end date).<\/p>\n\n\n\n<p><strong>Example: Preventing past dates in an &#8220;order_date&#8221; field<\/strong><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">IF :order_date &lt; TRUNC(SYSDATE) THEN\n   MESSAGE('The order date cannot be in the past.');\n   RAISE FORM_TRIGGER_FAILURE;\nEND IF;\n<\/pre>\n\n\n\n<p>\ud83d\udca1 <strong>Why this works:<\/strong> TRUNC(SYSDATE) ensures that time values are ignored, so only the date is considered.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>2. When Validate Record in Oracle Forms<\/strong><\/h3>\n\n\n\n<p><strong>What is &#8220;When Validate Record&#8221;?<\/strong><\/p>\n\n\n\n<p>The <strong>When Validate Record (WVR)<\/strong> trigger fires when the user <strong>tries to leave a record or save it<\/strong>. It ensures that <strong>all fields within the record<\/strong> meet validation rules before committing.<\/p>\n\n\n\n<p><strong>Execution Order:<\/strong><\/p>\n\n\n\n<p>1 <strong>WVI triggers run first<\/strong> for any modified fields.<br>2\ufe0f <strong>WVR runs after all WVI triggers<\/strong> to validate the complete record.<\/p>\n\n\n\n<p><strong>Use Cases for &#8220;When Validate Record&#8221;<\/strong><\/p>\n\n\n\n<p>\u2705 <strong>Cross-Field Validation<\/strong> \u2013 Ensuring relationships between fields are valid (e.g., the total price must equal quantity \u00d7 unit price).<br>\u2705 <strong>Referential Integrity<\/strong> \u2013 Checking if a record conflicts with existing data before saving.<br>\u2705 <strong>Transaction Validations<\/strong> \u2013 Ensuring all required fields are filled before committing data.<\/p>\n\n\n\n<p><strong>Example: Preventing negative quantities before saving<\/strong><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">IF :quantity &lt; 0 THEN\n   MESSAGE('Quantity cannot be negative!');\n   RAISE FORM_TRIGGER_FAILURE;\nEND IF;\n\n<\/pre>\n\n\n\n<p>\ud83d\udca1 <strong>Why this works:<\/strong> The system will block the record from being saved if an invalid quantity is detected.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>3. Key Differences Between &#8220;When Validate Item&#8221; and &#8220;When Validate Record&#8221;<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><td><strong>Feature<\/strong><\/td><td><strong>When Validate Item (WVI)<\/strong><\/td><td><strong>When Validate Record (WVR)<\/strong><\/td><\/tr><\/thead><tbody><tr><td><strong>Scope<\/strong><\/td><td>Single field (item)<\/td><td>Entire record<\/td><\/tr><tr><td><strong>Trigger Timing<\/strong><\/td><td>When user leaves the field (if value changed)<\/td><td>Before committing or leaving the record<\/td><\/tr><tr><td><strong>Common Use Cases<\/strong><\/td><td>Checking field constraints (e.g., date range, numeric limits)<\/td><td>Ensuring logical consistency across fields (e.g., total calculations)<\/td><\/tr><tr><td><strong>Dependency<\/strong><\/td><td>Fires only if the field value changes<\/td><td>Fires after all WVI triggers in the record<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>4. Best Practices for Using These Triggers<\/strong><\/h3>\n\n\n\n<p>\u2705 <strong>Use WVI for individual field validation<\/strong> and WVR for <strong>validating relationships between fields<\/strong>.<br>\u2705 <strong>Avoid redundant checks<\/strong> \u2013 If a validation applies to multiple fields at once, it\u2019s better placed in WVR.<br>\u2705 <strong>Use clear error messages<\/strong> so users understand why their input is invalid.<br>\u2705 <strong>Test dependencies between fields<\/strong> \u2013 If an item\u2019s value depends on another, ensure validations fire in the correct sequence.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong><strong>Conclusion<\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/h2>\n\n\n\n<p>Both <strong>&#8220;When Validate Item&#8221; (WVI)<\/strong> and <strong>&#8220;When Validate Record&#8221; (WVR)<\/strong> are essential for ensuring data accuracy in Oracle Forms. WVI is used for <strong>field-level validation<\/strong>, while WVR ensures that <strong>entire records meet business rules<\/strong> before saving. Understanding how and when these triggers fire allows developers to create more reliable and efficient forms while preventing data entry errors.<\/p>\n\n\n\n<p>By using these triggers correctly, you can enforce business logic, enhance data integrity, and improve user experience in Oracle Forms applications. \ud83d\ude80<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\ud83d\udd17 <a href=\"https:\/\/www.morphis-tech.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Learn more at morphis-tech.com<\/a>&nbsp;<\/p>\n\n\n<style type=\"text\/css\">\r\n\t\t#dae-shortcode7697-download-wrapper {\r\n\t\t\tbackground: url() !important;\r\n\t\t\tbackground-attachment: scroll !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-download-file-image {\r\n\t\t\twidth: 80% !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper.dae-shortcode-download-wrapper-wide .dae-shortcode-download-file-image {\r\n\t\t\twidth: 100% !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-download-title {\r\n\t\t\tfont-size: 20px !important;\r\n\t\t\tfont-family: Arial, Helvetica, sans-serif !important;\r\n\t\t\tcolor: #494950 !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-download-text {\r\n\t\t\tfont-size: 16px !important;\r\n\t\t\tfont-family: Arial, Helvetica, sans-serif !important;\r\n\t\t\tcolor: #444444 !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-download-text h1,\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-download-text h2,\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-download-text h3,\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-download-text h4,\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-download-text h5 {\r\n\t\t\tfont-family: Arial, Helvetica, sans-serif !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-download-button {\r\n\t\t\tcolor: #a3ca6d !important;\r\n\t\t\tbackground: none !important;\r\n\t\t\tfont-size: 18px !important;\r\n\t\t\tfont-family: Arial, Helvetica, sans-serif !important;\r\n\t\t\twidth: auto !important;\r\n\t\t\tpadding: 12px 8px !important;\r\n\t\t\tborder-color: #a3ca6d !important;\r\n\t\t\tborder-radius: 10px !important;\r\n\t\t\t-moz-border-radius: 10px !important;\r\n\t\t\t-webkit-border-radius: 10px !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-download-button:hover {\r\n\t\t\tcolor: #ffffff !important;\r\n\t\t\tbackground: #a3ca6d !important;\r\n\t\t\tborder-color: #a3ca6d !important;\r\n\t\t\tfont-size: 18px !important;\r\n\t\t\tfont-family: Arial, Helvetica, sans-serif !important;\r\n\t\t\twidth: auto !important;\r\n\t\t\tpadding: 12px 8px !important;\r\n\t\t\tborder-radius: 10px !important;\r\n\t\t\t-moz-border-radius: 10px !important;\r\n\t\t\t-webkit-border-radius: 10px !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-label {\r\n\t\t\tfont-size: 18px !important;\r\n\t\t\tfont-family: Arial, Helvetica, sans-serif !important;\r\n\t\t\tcolor: #444444 !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-icon {\r\n\t\t\theight: calc(45px + 4px) !important;\r\n\t\t\tfont-size: 15px !important;\r\n\t\t\tfont-family: Arial, Helvetica, sans-serif !important;\r\n\t\t\tpadding: 15px !important;\r\n\t\t\tcolor: #ffffff !important;\r\n\t\t\tbackground: #0073aa !important;\r\n\t\t\tborder-radius: 10px 0 0 10px !important;\r\n\t\t\t-moz-border-radius: 10px 0 0 10px !important;\r\n\t\t\t-webkit-border-radius: 10px 0 0 10px !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-field {\r\n\t\t\theight: calc(45px + 4px) !important;\r\n\t\t\tfont-size: 15px !important;\r\n\t\t\tfont-family: Arial, Helvetica, sans-serif !important;\r\n\t\t\tpadding: 15px !important;\r\n\t\t\tcolor: #444444 !important;\r\n\t\t\tbackground: #f9f9f9 !important;\r\n\t\t\tborder-radius: 0 10px 10px 0 !important;\r\n\t\t\t-moz-border-radius: 0 10px 10px 0 !important;\r\n\t\t\t-webkit-border-radius: 0 10px 10px 0 !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-select-icon {\r\n\t\t\ttop: calc(50% - 7.5px) !important;\r\n\t\t\tright: 15px !important;\r\n\t\t\tfont-size: 15px !important;\r\n\t\t\tfont-family: Arial, Helvetica, sans-serif !important;\r\n\t\t\tcolor: #444444 !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-field::-webkit-input-placeholder,\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-field::placeholder {\r\n\t\t\tcolor: #888888 !important;\r\n\t\t\tfont-family: Arial, Helvetica, sans-serif !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-field::-ms-input-placeholder {\r\n\t\t\tcolor: #888888 !important;\r\n\t\t\tfont-family: Arial, Helvetica, sans-serif !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-checkbox-text {\r\n\t\t\tcolor: #444444 !important;\r\n\t\t\tfont-size: 12px !important;\r\n\t\t\tfont-family: Arial, Helvetica, sans-serif !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-checkbox-text a {\r\n\t\t\tcolor: #0073aa !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-checkbox-text a:hover {\r\n\t\t\tcolor: #0081c1 !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-submit {\r\n\t\t\tcolor: #ffffff !important;\r\n\t\t\tfont-size: 18px !important;\r\n\t\t\tfont-family: Arial, Helvetica, sans-serif !important;\r\n\t\t\tpadding: 18px !important;\r\n\t\t\tbackground: #0073aa !important;\r\n\t\t\tborder-radius: 10px !important;\r\n\t\t\t-moz-border-radius: 10px !important;\r\n\t\t\t-webkit-border-radius: 10px !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-submit:hover {\r\n\t\t\tcolor: #ffffff !important;\r\n\t\t\tbackground: #0081c1 !important;\r\n\t\t\tfont-size: 18px !important;\r\n\t\t\tfont-family: Arial, Helvetica, sans-serif !important;\r\n\t\t\tpadding: 18px !important;\r\n\t\t\tborder-radius: 10px !important;\r\n\t\t\t-moz-border-radius: 10px !important;\r\n\t\t\t-webkit-border-radius: 10px !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-loading {\r\n\t\t\tcolor: #0073aa !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-message {\r\n\t\t\tfont-size: 16px !important;\r\n\t\t\tfont-family: Arial, Helvetica, sans-serif !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-error {\r\n\t\t\tcolor: #dd1111 !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-success {\r\n\t\t\tcolor: #0073aa !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-category-interests h4,\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-input-wrap-interest label {\r\n\t\t\tfont-family: Arial, Helvetica, sans-serif !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper {\r\n\t\t\talign-items: center !important;\r\n\t\t\t-webkit-align-items: center !important;\r\n\t\t\tjustify-content: flex-start !important;\r\n\t\t\t-webkit-justify-content: flex-start !important;\r\n\t\t\t-moz-justify-content: fle-start !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-download-content-wrapper,\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-download-title,\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-download-text,\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-wrapper p,\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-category-interests-wrap {\r\n\t\t\ttext-align: center !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-field-wrap {\r\n\t\t\tjustify-content: center !important;\r\n\t\t\t-webkit-justify-content: center !important;\r\n\t\t\t-moz-justify-content: center !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-label,\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-message,\r\n\t\t#dae-shortcode7697-download-wrapper .dae-shortcode-register-category-interests-wrap {\r\n\t\t\tmargin: 20px auto !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper.dae-shortcode-download-wrapper-wide {\r\n\t\t\talign-items: center !important;\r\n\t\t\t-webkit-align-items: center !important;\r\n\t\t\tjustify-content: center !important;\r\n\t\t\t-webkit-justify-content: center !important;\r\n\t\t\t-moz-justify-content: center !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper.dae-shortcode-download-wrapper-wide .dae-shortcode-download-content-wrapper,\r\n\t\t#dae-shortcode7697-download-wrapper.dae-shortcode-download-wrapper-wide .dae-shortcode-download-title,\r\n\t\t#dae-shortcode7697-download-wrapper.dae-shortcode-download-wrapper-wide .dae-shortcode-download-text,\r\n\t\t#dae-shortcode7697-download-wrapper.dae-shortcode-download-wrapper-wide .dae-shortcode-register-wrapper p,\r\n\t\t#dae-shortcode7697-download-wrapper.dae-shortcode-download-wrapper-wide .dae-shortcode-register-category-interests-wrap {\r\n\t\t\ttext-align: center !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper.dae-shortcode-download-wrapper-wide .dae-shortcode-register-field-wrap {\r\n\t\t\tjustify-content: center !important;\r\n\t\t\t-webkit-justify-content: center !important;\r\n\t\t\t-moz-justify-content: center !important;\r\n\t\t}\r\n\t\t#dae-shortcode7697-download-wrapper.dae-shortcode-download-wrapper-wide .dae-shortcode-register-label,\r\n\t\t#dae-shortcode7697-download-wrapper.dae-shortcode-download-wrapper-wide .dae-shortcode-register-message,\r\n\t\t#dae-shortcode7697-download-wrapper.dae-shortcode-download-wrapper-wide .dae-shortcode-register-category-interests-wrap {\r\n\t\t\tmargin: 20px auto !important;\r\n\t\t}\r\n\t<\/style>\r\n\t\t<div id=\"dae-shortcode7697-download-wrapper\" class=\"dae-shortcode-download-wrapper\">\r\n\t\t\t\r\n\t\t\t<div class=\"dae-shortcode-download-content-wrapper\">\r\n\t\t\t\t<h2 class=\"dae-shortcode-download-title\">Find out how Morphis can enable your digital reinvention<\/h2>\r\n\t\t\t\t\r\n\t\t\t\t<div class=\"dae-shortcode-download-button\">\r\n\t\t\t\t\t<span class=\"dae-shortcode-download-button-icon\"><i class=\"fas fa-download\"><\/i><\/span>\r\n\t\t\t\t\t<span class=\"dae-shortcode-download-button-text\">Download Whitepaper<\/span>\r\n\t\t\t\t<\/div>\r\n\t\t\t\t<div class=\"dae-shortcode-register-wrapper\">\r\n\t\t\t\t\t<p class=\"dae-shortcode-register-label\">Send download link to:<\/p>\r\n\t\t\t\t\t<form class=\"dae-shortcode-register-form\" method=\"post\" novalidate=\"novalidate\">\r\n\t\t\t\t\t\t<input type=\"hidden\" name=\"file\" value=\"Morphis-Transformer-for-Legacy-Modernization.pdf\" \/>\r\n\t\t\t\t\t\t<div class=\"dae-shortcode-register-field-wrap\"><div class=\"dae-shortcode-register-icon\"><i class=\"fas fa-envelope\"><\/i><\/div><div class=\"dae-shortcode-register-input-wrap\"><input class=\"dae-shortcode-register-field\" type=\"email\" name=\"email\" placeholder=\"Email\" autocomplete=\"off\" \/><\/div><\/div>\r\n\t\t\t\t\t\t\r\n\t\t\t<p>\r\n\t\t\t\t<input class=\"dae-shortcode-register-checkbox\" type=\"checkbox\" name=\"required_checkbox\" value=\"I confirm that I have read and agree to the &lt;a href=&quot;https:\/\/morphis-tech.com\/privacy-policy\/&quot; target=&quot;_blank&quot;&gt;Privacy Policy&lt;\/a&gt;.\" \/>\r\n\t\t\t\t<span class=\"dae-shortcode-register-checkbox-text\">I confirm that I have read and agree to the <a href=\"https:\/\/morphis-tech.com\/privacy-policy\/\" target=\"_blank\">Privacy Policy<\/a>.<\/span>\r\n\t\t\t<\/p>\r\n\t\t\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\t<p>\r\n\t\t\t\t\t\t\t<input class=\"dae-shortcode-register-submit\" type=\"submit\" value=\"Send link\" \/>\r\n\t\t\t\t\t\t<\/p>\r\n\t\t\t\t\t\t<p class=\"dae-shortcode-register-loading\">\r\n\t\t\t\t\t\t\t<i class=\"fas fa-spinner fa-spin\"><\/i>\r\n\t\t\t\t\t\t<\/p>\r\n\t\t\t\t\t<\/form>\r\n\t\t\t\t\t<p class=\"dae-shortcode-register-message\"><\/p>\r\n\t\t\t\t<\/div>\r\n\t\t\t<\/div>\r\n\t\t<\/div>\r\n\t\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle Forms is a powerful tool for building data entry applications with a graphical user interface. One of its key features is the use of triggers, which allow developers to control application behavior based on user interactions. Two important validation triggers in Oracle Forms are: Although both triggers ensure data integrity, they have different scopes [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":7766,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[203],"tags":[115,116,117,204],"class_list":["post-7762","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle-forms-modernization","tag-oracle-forms","tag-oracle-forms-migration","tag-oracle-modernization","tag-oracle-reports"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>When Validate Item and When Validate Record in Oracle Forms - Morphis Tech<\/title>\n<meta name=\"description\" content=\"Both &quot;When Validate Item&quot; (WVI) and &quot;When Validate Record&quot; (WVR) are essential for ensuring data accuracy in Oracle Forms.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"When Validate Item and When Validate Record in Oracle Forms - Morphis Tech\" \/>\n<meta property=\"og:description\" content=\"Both &quot;When Validate Item&quot; (WVI) and &quot;When Validate Record&quot; (WVR) are essential for ensuring data accuracy in Oracle Forms.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/\" \/>\n<meta property=\"og:site_name\" content=\"Morphis-Tech Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-20T16:05:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-20T16:21:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/morphis-tech.com\/blog\/wp-content\/uploads\/2025\/06\/confused-man-in-office-using-laptop-and-raising-ar-2025-03-26-08-17-51-utc-scaled.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1707\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Ana Andrade\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ana Andrade\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/\"},\"author\":{\"name\":\"Ana Andrade\",\"@id\":\"https:\/\/morphis-tech.com\/blog\/#\/schema\/person\/83a66b5c5b78398ad20b1cd731ec8bfd\"},\"headline\":\"Understanding &#8220;When Validate Item&#8221; and &#8220;When Validate Record&#8221; in Oracle Forms\",\"datePublished\":\"2025-06-20T16:05:14+00:00\",\"dateModified\":\"2025-06-20T16:21:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/\"},\"wordCount\":623,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/morphis-tech.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/morphis-tech.com\/blog\/wp-content\/uploads\/2025\/06\/confused-man-in-office-using-laptop-and-raising-ar-2025-03-26-08-17-51-utc-scaled.webp\",\"keywords\":[\"oracle forms\",\"oracle forms migration\",\"oracle modernization\",\"oracle reports\"],\"articleSection\":[\"Oracle Forms Modernization\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/\",\"url\":\"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/\",\"name\":\"When Validate Item and When Validate Record in Oracle Forms - Morphis Tech\",\"isPartOf\":{\"@id\":\"https:\/\/morphis-tech.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/morphis-tech.com\/blog\/wp-content\/uploads\/2025\/06\/confused-man-in-office-using-laptop-and-raising-ar-2025-03-26-08-17-51-utc-scaled.webp\",\"datePublished\":\"2025-06-20T16:05:14+00:00\",\"dateModified\":\"2025-06-20T16:21:08+00:00\",\"description\":\"Both \\\"When Validate Item\\\" (WVI) and \\\"When Validate Record\\\" (WVR) are essential for ensuring data accuracy in Oracle Forms.\",\"breadcrumb\":{\"@id\":\"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/#primaryimage\",\"url\":\"https:\/\/morphis-tech.com\/blog\/wp-content\/uploads\/2025\/06\/confused-man-in-office-using-laptop-and-raising-ar-2025-03-26-08-17-51-utc-scaled.webp\",\"contentUrl\":\"https:\/\/morphis-tech.com\/blog\/wp-content\/uploads\/2025\/06\/confused-man-in-office-using-laptop-and-raising-ar-2025-03-26-08-17-51-utc-scaled.webp\",\"width\":2560,\"height\":1707},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/morphis-tech.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Understanding &#8220;When Validate Item&#8221; and &#8220;When Validate Record&#8221; in Oracle Forms\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/morphis-tech.com\/blog\/#website\",\"url\":\"https:\/\/morphis-tech.com\/blog\/\",\"name\":\"Legacy Modernization - Blog\",\"description\":\"Legacy to Cloud\",\"publisher\":{\"@id\":\"https:\/\/morphis-tech.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/morphis-tech.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/morphis-tech.com\/blog\/#organization\",\"name\":\"Morphis Tech\",\"url\":\"https:\/\/morphis-tech.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/morphis-tech.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/morphis-tech.com\/blog\/wp-content\/uploads\/2024\/06\/Logo_Blog_2024-1.svg\",\"contentUrl\":\"https:\/\/morphis-tech.com\/blog\/wp-content\/uploads\/2024\/06\/Logo_Blog_2024-1.svg\",\"width\":344,\"height\":51,\"caption\":\"Morphis Tech\"},\"image\":{\"@id\":\"https:\/\/morphis-tech.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.instagram.com\/morphis_technologies\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/morphis-tech.com\/blog\/#\/schema\/person\/83a66b5c5b78398ad20b1cd731ec8bfd\",\"name\":\"Ana Andrade\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/morphis-tech.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7db769fad7c53ef5a6638e255ed739e4fc1af3c9e9c8c6b0b656807b6d00f5e2?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7db769fad7c53ef5a6638e255ed739e4fc1af3c9e9c8c6b0b656807b6d00f5e2?s=96&d=mm&r=g\",\"caption\":\"Ana Andrade\"},\"url\":\"https:\/\/morphis-tech.com\/blog\/author\/ana-andrade\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"When Validate Item and When Validate Record in Oracle Forms - Morphis Tech","description":"Both \"When Validate Item\" (WVI) and \"When Validate Record\" (WVR) are essential for ensuring data accuracy in Oracle Forms.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/","og_locale":"en_GB","og_type":"article","og_title":"When Validate Item and When Validate Record in Oracle Forms - Morphis Tech","og_description":"Both \"When Validate Item\" (WVI) and \"When Validate Record\" (WVR) are essential for ensuring data accuracy in Oracle Forms.","og_url":"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/","og_site_name":"Morphis-Tech Blog","article_published_time":"2025-06-20T16:05:14+00:00","article_modified_time":"2025-06-20T16:21:08+00:00","og_image":[{"width":2560,"height":1707,"url":"https:\/\/morphis-tech.com\/blog\/wp-content\/uploads\/2025\/06\/confused-man-in-office-using-laptop-and-raising-ar-2025-03-26-08-17-51-utc-scaled.webp","type":"image\/webp"}],"author":"Ana Andrade","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ana Andrade","Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/#article","isPartOf":{"@id":"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/"},"author":{"name":"Ana Andrade","@id":"https:\/\/morphis-tech.com\/blog\/#\/schema\/person\/83a66b5c5b78398ad20b1cd731ec8bfd"},"headline":"Understanding &#8220;When Validate Item&#8221; and &#8220;When Validate Record&#8221; in Oracle Forms","datePublished":"2025-06-20T16:05:14+00:00","dateModified":"2025-06-20T16:21:08+00:00","mainEntityOfPage":{"@id":"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/"},"wordCount":623,"commentCount":0,"publisher":{"@id":"https:\/\/morphis-tech.com\/blog\/#organization"},"image":{"@id":"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/#primaryimage"},"thumbnailUrl":"https:\/\/morphis-tech.com\/blog\/wp-content\/uploads\/2025\/06\/confused-man-in-office-using-laptop-and-raising-ar-2025-03-26-08-17-51-utc-scaled.webp","keywords":["oracle forms","oracle forms migration","oracle modernization","oracle reports"],"articleSection":["Oracle Forms Modernization"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/","url":"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/","name":"When Validate Item and When Validate Record in Oracle Forms - Morphis Tech","isPartOf":{"@id":"https:\/\/morphis-tech.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/#primaryimage"},"image":{"@id":"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/#primaryimage"},"thumbnailUrl":"https:\/\/morphis-tech.com\/blog\/wp-content\/uploads\/2025\/06\/confused-man-in-office-using-laptop-and-raising-ar-2025-03-26-08-17-51-utc-scaled.webp","datePublished":"2025-06-20T16:05:14+00:00","dateModified":"2025-06-20T16:21:08+00:00","description":"Both \"When Validate Item\" (WVI) and \"When Validate Record\" (WVR) are essential for ensuring data accuracy in Oracle Forms.","breadcrumb":{"@id":"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/#primaryimage","url":"https:\/\/morphis-tech.com\/blog\/wp-content\/uploads\/2025\/06\/confused-man-in-office-using-laptop-and-raising-ar-2025-03-26-08-17-51-utc-scaled.webp","contentUrl":"https:\/\/morphis-tech.com\/blog\/wp-content\/uploads\/2025\/06\/confused-man-in-office-using-laptop-and-raising-ar-2025-03-26-08-17-51-utc-scaled.webp","width":2560,"height":1707},{"@type":"BreadcrumbList","@id":"https:\/\/morphis-tech.com\/blog\/understanding-when-validate-item-and-when-validate-record-in-oracle-forms\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/morphis-tech.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Understanding &#8220;When Validate Item&#8221; and &#8220;When Validate Record&#8221; in Oracle Forms"}]},{"@type":"WebSite","@id":"https:\/\/morphis-tech.com\/blog\/#website","url":"https:\/\/morphis-tech.com\/blog\/","name":"Legacy Modernization - Blog","description":"Legacy to Cloud","publisher":{"@id":"https:\/\/morphis-tech.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/morphis-tech.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/morphis-tech.com\/blog\/#organization","name":"Morphis Tech","url":"https:\/\/morphis-tech.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/morphis-tech.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/morphis-tech.com\/blog\/wp-content\/uploads\/2024\/06\/Logo_Blog_2024-1.svg","contentUrl":"https:\/\/morphis-tech.com\/blog\/wp-content\/uploads\/2024\/06\/Logo_Blog_2024-1.svg","width":344,"height":51,"caption":"Morphis Tech"},"image":{"@id":"https:\/\/morphis-tech.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.instagram.com\/morphis_technologies\/"]},{"@type":"Person","@id":"https:\/\/morphis-tech.com\/blog\/#\/schema\/person\/83a66b5c5b78398ad20b1cd731ec8bfd","name":"Ana Andrade","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/morphis-tech.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7db769fad7c53ef5a6638e255ed739e4fc1af3c9e9c8c6b0b656807b6d00f5e2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7db769fad7c53ef5a6638e255ed739e4fc1af3c9e9c8c6b0b656807b6d00f5e2?s=96&d=mm&r=g","caption":"Ana Andrade"},"url":"https:\/\/morphis-tech.com\/blog\/author\/ana-andrade\/"}]}},"_links":{"self":[{"href":"https:\/\/morphis-tech.com\/blog\/wp-json\/wp\/v2\/posts\/7762","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/morphis-tech.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/morphis-tech.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/morphis-tech.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/morphis-tech.com\/blog\/wp-json\/wp\/v2\/comments?post=7762"}],"version-history":[{"count":3,"href":"https:\/\/morphis-tech.com\/blog\/wp-json\/wp\/v2\/posts\/7762\/revisions"}],"predecessor-version":[{"id":7765,"href":"https:\/\/morphis-tech.com\/blog\/wp-json\/wp\/v2\/posts\/7762\/revisions\/7765"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/morphis-tech.com\/blog\/wp-json\/wp\/v2\/media\/7766"}],"wp:attachment":[{"href":"https:\/\/morphis-tech.com\/blog\/wp-json\/wp\/v2\/media?parent=7762"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/morphis-tech.com\/blog\/wp-json\/wp\/v2\/categories?post=7762"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/morphis-tech.com\/blog\/wp-json\/wp\/v2\/tags?post=7762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}