Prevent Submitting Non-Catalog Requests with Missing DFF Using Visual Builder Studio Extension

Business Challenge

In Oracle Fusion Self Service Procurement, the Non-Catalog Request screen allows displaying DFF segments from the Requisition Lines Flexfield. One of our clients had a strict requirement: prevent submission of the request if the Legal Entity DFF segment is not populated. This was critical because the value is later used in account combination generation.

However, marking the DFF segment as “Required” in the flexfield setup was not sufficient — especially if for other usages the DFF segment is not defined as Required. Another solution specific for this screen was required.

Our Solution

The proposed solution is to extend the Non-Catalog Request form using Visual Builder Studio (VBS) via the Edit in Visual Builder Studio feature in Advanced mode.

Oracle exposes a powerful event named:

preAddToCartFromNCRAndSmartFormValidationsEvent

This event is triggered just before the line is submitted into the cart. By creating a custom Action Chain for this event, we were able to check if the Legal Entity DFF is empty, display a meaningful message to the user, and cancel the submission if needed.

Step-by-Step:

1. Open create_noncatalog_request page in VBS using Advanced mode.
2. Go to Events and locate preAddToCartFromNCRAndSmartFormValidationsEvent.
3. Create a new Action Chain and add conditional logic to check the DFF segment.
4. Use console and JSON.stringify to analyze the internal structure of the payload variable addtoCartPayloadFromNCRAndSmartForm.
5. If Legal Entity is empty, fire a notification and return stopPropagation: true.

Screenshot – VBS Event Hook:

Screenshot – Action Chain Logic:

Summary

This approach ensures that the Non-Catalog Request cannot be submitted unless all necessary DFF segments — including Legal Entity — are validated at runtime. It gives functional teams strong enforcement over business rules, while keeping the user experience intuitive and compliant.

Need help with customizing your Oracle Fusion Procurement screens? CID Software Solutions specializes in Fusion extensions using Visual Builder Studio, Application Composer, BIP, OIC, and more.

Let’s bring your custom business logic to life — safely and scalably.