Hello,
I have a Form region (REST Data Source) with “Add Row” and “Delete Row” operations in a Modal page with one DML process.
When I submit a DELETE operation, the DML process validates all required parameters defined for the REST Data Source, regardless of the operation.
Because I have multiple required parameters for the Insert database action (for example “value"), the DELETE operation fails with the following error: “ORA-20999: Required REST Source IN parameter "value" of type "Request body" must have a value.” This happens even though the DELETE operation does not have“value" parameter at all, it requires only one parameter ("id").
Am I missing something? I would like to avoid setting dummy default values for all required params in all forms.
Oracle APEX 24.2.6