Found 901 results.

Creating a Validation for DFF Fields in Document of Record Using Visual Builder Studio - Oracle HCM Cloud

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.

  • Blog
  • Creating a Validation for DFF Fields in Document of Record Using Visual Builder Studio - Oracle HCM Cloud
Creating a Validation for DFF Fields in Document of Record Using Visual Builder Studio - Oracle HCM Cloud
June 25, 2025

Creating a Validation for DFF Fields in Document of Record Using Visual Builder Studio - 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.

 

Creating a Validation for DFF Fields in Document of Record Using Visual Builder Studio - Oracle HCM Cloud - Fig 1: Document of Records DFF

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.

 

Creating a Validation for DFF Fields in Document of Record Using Visual Builder Studio - Oracle HCM Cloud - Fig 2: After submitting the Fields

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’.

 

Creating a Validation for DFF Fields in Document of Record Using Visual Builder Studio - Oracle HCM Cloud - Fig 3: Open 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.

 

Creating a Validation for DFF Fields in Document of Record Using Visual Builder Studio - Oracle HCM Cloud - Fig 4: Open Validate Field Values

Fig 4: Open Validate Field Values

 

  • Click the Validation icon.

 

Creating a Validation for DFF Fields in Document of Record Using Visual Builder Studio - Oracle HCM Cloud - Fig 5: Select 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, which 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.

 

Creating a Validation for DFF Fields in Document of Record Using Visual Builder Studio - Oracle HCM Cloud - Fig 6: Validation Rule Tab

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.

 

Creating a Validation for DFF Fields in Document of Record Using Visual Builder Studio - Oracle HCM Cloud - Fig 7: Click Advance Expression

Fig 7: Click Advanced 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.

 

Creating a Validation for DFF Fields in Document of Record Using Visual Builder Studio - Oracle HCM Cloud - Fig 8: Rule Box

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.

 

Creating a Validation for DFF Fields in Document of Record Using Visual Builder Studio - Oracle HCM Cloud - Fig 9: Click the code icon

Fig 9: Click the code icon

 

Creating a Validation for DFF Fields in Document of Record Using Visual Builder Studio - Oracle HCM Cloud - Fig 10: Javascipt coding Dialogue box

Fig 10: JavaScript coding Dialogue box

 

  • The Second option was to directly write 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 JavaScript automatically.

 

Creating a Validation for DFF Fields in Document of Record Using Visual Builder Studio - Oracle HCM Cloud - Fig 11: Javascipt coding Dialogue box

Fig 11: JavaScript coding Dialogue box

 

Creating a Validation for DFF Fields in Document of Record Using Visual Builder Studio - Oracle HCM Cloud - Fig 12: After saving the code

Fig 12: After saving the code

 

  • Once the code was saved, click preview to check the validation.

 

Creating a Validation for DFF Fields in Document of Record Using Visual Builder Studio - Oracle HCM Cloud - Fig 13: Enter the error message

Fig 13: Enter the error message

 

  • The First two columns have the same value the error message is thrown.

 

Creating a Validation for DFF Fields in Document of Record Using Visual Builder Studio - Oracle HCM Cloud - Fig 14: Test case 1

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.

 

Creating a Validation for DFF Fields in Document of Record Using Visual Builder Studio - Oracle HCM Cloud - Fig 15: Test Case 2

Fig 15: Test Case 2

 

  • All fields have different values, the error message was not shown, and the DOR can be submitted.

 

Creating a Validation for DFF Fields in Document of Record Using Visual Builder Studio - Oracle HCM Cloud - Fig 16: Without error

Fig 16: Without error

 

Business Benefits of Using Oracle Visual Builder Studio for DFF Validation

Implementing custom field-level validations in the Document of Record (DOR) module through Oracle Visual Builder Studio (VBS) brings several tangible business advantages:

  • Improved Data Accuracy and Integrity: Real-time validations ensure each Descriptive Flexfield (DFF) entry is both unique and mandatory, reducing the risk of duplicate or incomplete data—crucial for maintaining high-quality HR records.
  • Enhanced Compliance and Governance: By enforcing mandatory input and uniqueness rules, organizations align better with internal policies and external compliance standards, ensuring data governance across Oracle Cloud HCM modules.
  • Reduced Manual Errors and Rework: Automating validation directly within Redwood UI pages reduces human errors during data entry, eliminating the need for post-submission data cleanups or audits.
  • Accelerated User Adoption with No-Code/Low-Code Interface: VBS’s intuitive interface empowers functional users to create or modify validations without needing deep technical knowledge, enabling faster deployment and agility.
  • Cost-Efficient and Scalable Customization: Instead of relying on extensive backend development, this low-code validation setup provides a cost-effective way to tailor Oracle HCM Cloud workflows to evolving business needs.
  • Seamless Integration with Oracle Cloud Ecosystem: As a native Oracle tool, VBS ensures smooth integration and compatibility with Redwood design standards, allowing consistent UX and optimal system performance.

 

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.

 

Take the Next Step with Kovaion

Custom validations in Oracle Cloud HCM don’t just improve user experience—they drive better decisions, ensure compliance, and strengthen data quality across your organization. With Oracle Visual Builder Studio (VBS), you now have the power to implement intelligent, real-time validations without complex backend development.

At Kovaion, we help organizations unlock the full potential of Oracle Cloud applications by building smart, low-code, and scalable solutions that are fully aligned with Redwood design standards. Our team has deep expertise in:

  • Configuring and customizing Document of Record (DOR) validations
  • Enforcing mandatory and unique input logic using Visual Builder Studio
  • Enhancing data governance through robust field-level control
  • Ensuring smooth user experiences within Oracle HCM Cloud

Whether you’re planning to optimize your existing HCM workflows or build new custom validations from scratch, our experts can help you do it faster, cleaner, and more cost-effectively—all while maintaining Oracle best practices.

Why Choose Kovaion?

  • Oracle Partner with proven HCM Cloud transformation success
  • Expertise in Visual Builder Studio and Redwood UI customization
  • End-to-end consulting from strategy to implementation

Your data deserves more than default configurations. Let Kovaion help you build HCM processes that are accurate, compliant, and future-ready. Schedule a free consultation today to learn how we can tailor Oracle Visual Builder Studio to meet your exact business needs!

Oracle HCM Cloud Solution

Connect with us for End-to-End Implementation, Enhancement, Updates, and Support for Oracle HCM.

Read More

Categories