I have a display only field on my page – P1_TEXT_DISPL that gets populated when another field on the page changes. If that field does not equal to “TEST_1” I need to display an error on the page. For that I used validation:

I have a select list that has a is set to Static LOV with two values ‘YES’ and ‘NO’ but I want to allow the user to add additional values to it by typing them in or be setting the select list to a value in code. I have Display Extra Values selected but that still does not work. If the field is set to a value not in the static list, nothing gets selected. But if I check session state, P1_RESPONSE is set to the value I set it to in code. What can I do to allow an extra value to be entered?

I have a popup LOV with multiple columns and number of page items that get populated whenever a record is selected in the popup LOV. Which DA can I use to save the values populated into the session state before submit of the page?

I have a multi-column popup LOV based on the query:

I am using Oracle APEX 22.1.4 and I am trying to invoke automatic row processing (DML) process programmatically.