I have a P13_START_DATE item with associated DA to fire on the "change". The dynamic action uses Server Side Condition to determine if it should fire. The condition uses the P13_START_DATE value to determine overlapping with records which already exist in DB.
It looks like no matter what I try the selected value for P13_START_DATE is not available for the condition. I tried different approach of "submitting the item" by using the dummy execution, tried to use javascript to set a value of different P13_START_DATE_HIDDEN item but nothing seems to be working as I think it should (am I wrong). When I examine the session state of those item(s) they are havign exposed value.
Here is the code from the Server Side Condition logic:
SELECT 'x'
FROM cnd_emp_appt_details_v d
,cnd_emp_appt_headers_v h
WHERE d.emp_appt_header_id = h.emp_appt_header_id
AND h.person_id = :P13_PERSON_ID
AND d.appt_category_code = 'PRM'
AND d.status NOT IN ('REJECTED', 'VOID')
AND utl_date.is_overlap(d.start_date, d.end_date, TO_DATE(:P13_START_DATE), TO_DATE(:P13_END_DATE)) = 'Y';
As you see the logic calls to the "is_overlap" function. I put debug logging in this function to examine the values passed and the P13_START_DATE is NULL
The P13_START_DATE corresponds to "i_new_start" parameter and it is NULL.
I also tried to use a "button" to fire copy of this DA to see if it is somehow related to the "change" event on an item but it is not. I just cannot make the value in question to be available for processing.