"How to Correctly Display Validation Errors in Oracle APEX"
Question
Kim has defined a validation of "Item is NOT zero" on P5_SAL.
When she runs the page, the error is displayed in the notification, but does not highlight the item or display the error below the item.
Kim changes Display Location to "Inline with Field and Notification"
However, the validation error still does not display under the item.
What must Kim do to ensure that the validation error appears correctly under the item and also in the notification?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D.B.
https://stackoverflow.com/questions/57100939/display-error-message-inline-with-field-in-oracle-apex-interactive-gridIn Oracle Application Express (APEX), validations are used to check user input for correctness and completeness. When a validation fails, APEX displays an error message to the user.
In this scenario, Kim has defined a validation on an item called P5_SAL. The validation is checking if the item is not zero. However, when Kim runs the page, the error message is displayed in the notification, but it does not highlight the item or display the error below the item.
To resolve this issue, Kim can change the Display Location property of the validation. The Display Location property determines where the error message is displayed when the validation fails.
Kim has already tried changing the Display Location property to "Inline with Field and Notification", but it did not resolve the issue. This is because the "Inline with Field and Notification" setting only displays the error message next to the item, but does not highlight the item or display the error below the item.
To ensure that the validation error appears correctly under the item and also in the notification, Kim should select "Inline with Field" as the Display Location property. This setting will display the error message below the item and highlight the item in red, making it easier for the user to see which item has failed validation.
Option A, adding JavaScript to the item to display the error, is not necessary as APEX has built-in functionality for displaying validation errors. Option C, setting Value Required to Yes on P5_SAL, is not relevant as it will not affect the validation error display. Option D, setting Validation Associated Item to P5_SAL, is also not necessary as the validation is already associated with the item.
Therefore, the correct answer is B, set Display Location to "Inline with Field".
