Found 901 results.
Learn how to use Oracle Visual Builder Studio to add real-time validation for Descriptive Flexfields in Document of Record. Improve data accuracy and enforce uniqueness across fields in Oracle HCM Cloud.
Oracle Visual Builder Studio (VBS) is a powerful, low-code development platform that enables users to design, extend, and validate applications built on Oracle Cloud. With its intuitive interface and advanced scripting capabilities, VBS allows both developers and functional users to enhance page-level validations and user experience directly within Redwood UI pages.
In this context, we leverage Visual Builder Studio to implement custom validation for Descriptive Flexfield (DFF) inputs within the Document of Record (DOR) module. The business requirement is to ensure that all ten DFF fields are mandatory and must hold unique values. Without validation, the system permits submission even if duplicate values exist, risking data redundancy and inconsistency. Using VBS, we can introduce real-time validations that trigger error or warning messages before the data is submitted—ensuring better data quality and governance.
Steps to Create the Validation
The Document of Record has ten DFF fields, with some fields containing the same values.
Fig 1: Document of Records DFF
The page will not display any error or warning message initially. It will allow the submission of the Document of Record, and the DOR will be saved for this person.
Fig 2: After submitting the Fields
To set up the Validation for the DOR, open the DOR page and Select Profile in the top right corner and click ‘Edit Page in Visual Builder Studio’.
Fig 3: Open Visual Builder Studio
The Page will navigate to the new tab Visual Builder studio page and click the Validate Field Values.
Fig 4: Open Validate Field Values
Click the Validation icon.
Fig 5: Select the Validation Icon
Click the Message icon and write the error message under Details.
The summary acts as a label for the error message
Severity is used to define the message should be error, warning, info, or confirmation that will be selected based on the validation requirement.
Target Fields are used to display the message under a specific field alone.
In this case, select the severity as warning or error.
Once the Validation message was given, select the edit option to define the validation
query.
Fig 6: Validation Rule Tab
Select the “Use Advanced Expression” Because the field-to-field validation for the same page values can be done using the advanced option.
Fig 7: Click Advance Expression
Once the Advanced Expression is enabled, there are two options to write the validation.
One, we can drag and drop the condition and search the field label name from the condition option.
Drag the If condition and place it under Return.
Fig 8: Rule Box
This is the validation using the design option made.
For this Design Visual Builder studio automatically creates the JavaScript.
The Code can be viewed by clicking the code option.
Fig 9: Click the code icon
Fig 10: JavaScript coding Dialogue box
The Second option was to directly write a JavaScript code and Place in the code option.
The Fields used in the JavaScript can be inserted using the search option.
In this JavaScript, all field validation was written manually by taking the field name.
The System will generate the Design for the JavaScript automatically.
Fig 11: JavaScript coding Dialogue box
Fig 12: After saving the code
Once the code was saved, click preview to check the validation.
Fig 13: Enter the error message
The First two columns have the same value the error message is thrown.
Fig 14: Test case 1
The code will check for all the fields in all possible conditions.
It will not allow to submit of the DOR with an error even if any one field does not satisfy the condition.
Fig 15: Test Case 2
All fields have different values, the error message was not shown, and the DOR can be submitted.
Fig 16: Without error
Conclusion:
By utilizing Oracle Visual Builder Studio to implement field-level validations for the Document of Record, organizations can enforce mandatory input rules and ensure uniqueness across DFF fields in a flexible, user-friendly manner. This approach significantly reduces data entry errors, improves user experience, and enhances the overall reliability of employee records in Oracle HCM Cloud. Whether through drag-and-drop condition builders or JavaScript logic, VBS offers a scalable solution for real-time validations that align with modern digital workflows and Redwood design standards.
Connect with us for End-to-End Implementation, Enhancement, Updates, and Support for Oracle HCM.
Read MoreThis website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.
